39
Salesforce raises prices for the first time in 7 years – stock rises
(www.crmrank.com)
This is a most excellent place for technology news and articles.
Never had to use salesforce, what’s janky about their sql? Anything beyond the incompatible functions that I’m used to when moving between PLSQL/TSQL/Db2?
I mean, there’s no
select *
, for a start.Ew
Indeed. It's okay though, the same behaviour can be trivially achieved with this simple function:
Which I'm sure you'll agree is much more enterprise.
Oh man that code is gross. I guess they went with a proprietary sql build in an attempt to lock people in?
Haha yep. I can't imagine anyone's seriously using that code, and actually there's a lot to be said for specifying the fields in your queries rather then just getting everything (cos things can change), but not having
select *
is just ridiculously hostile to new users just trying to get a feel for the data.But that's very Salesforce. They've redesigned SQL so it's "better".
Imagine that attitude applied to an entire platform. It's not bad, per se - it's pretty consistent, stable and mature. But it's certainly spiky and difficult to use compared to other ecosystems.