Technology

74585 readers

3881 users here now

This is a most excellent place for technology news and articles.

Our Rules

Follow the lemmy.world rules.
Only tech related news or articles.
Be excellent to each other!
Mod approved content bots can post up to 10 articles per day.
Threads asking for personal tech support may be deleted.
Politics threads may be removed.
No memes allowed as posts, OK to post as comments.
Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
Check for duplicates before posting, duplicates may be removed
Accounts 7 days and younger will have their posts automatically removed.

Approved Bots

founded 2 years ago

MODERATORS

[email protected]

Salesforce raises prices for the first time in 7 years – stock rises (www.crmrank.com)

submitted 2 years ago by [email protected] to c/[email protected]

15 comments fedilink hide all child comments

Salesforce, the leading provider of software for customer relations management, announced that it will implement a price increase for some of its cloud and marketing tools starting in August.

The company’s decision to raise prices, the first in seven years, was met with a positive market response as its shares surged nearly 4% during early trading on Tuesday.

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 24 points 2 years ago (9 children)

I fucking hate Salesforce. I have to integrate with it via API. Why they chose to create a shittier version of SQL is so annoying.

[–] [email protected] 2 points 2 years ago (5 children)

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?

[–] [email protected] 2 points 2 years ago* (last edited 2 years ago) (1 children)

I mean, there’s no select *, for a start.

[–] [email protected] 1 points 2 years ago (1 children)

[–] [email protected] 3 points 2 years ago* (last edited 2 years ago) (1 children)

Indeed. It's okay though, the same behaviour can be trivially achieved with this simple function:

String table = 'table_name';
String query_string = 'SELECT ';
List<String> table_list = new List<String>();
table_list.add(table);

Set<String> table_rows = schema.describeSObjects(table_list)[0].fields.getMap().keyset();
for(String row : table_rows){
    query_string += row + ',';
}
query_string = query_string.removeEnd(','); //remove trailing comma
query_string += ' FROM ' + table;

Database.query(query_string);

Which I'm sure you'll agree is much more enterprise.

[–] [email protected] 2 points 2 years ago (1 children)

Oh man that code is gross. I guess they went with a proprietary sql build in an attempt to lock people in?

[–] [email protected] 0 points 2 years ago

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.

load more comments (3 replies)

load more comments (6 replies)