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.

  • ShunkW@lemmy.world
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    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.

      • ShunkW@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        arrow-down
        1
        ·
        1 year ago

        Which one is the question. They have multiple different ones with no feature parity. Looking for documentation? Go fuck yourself and download this 60 page pdf. Also it hasn’t been updated in a while and we won’t tell you about breaking changes. Sorry for the late reply, Lemmy didn’t tell me about your reply till just a few minutes ago lol

    • NOT_RICK@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 year ago

      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?

          • dan@lemm.ee
            link
            fedilink
            English
            arrow-up
            0
            arrow-down
            1
            ·
            edit-2
            1 year ago

            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.

            • NOT_RICK@lemmy.world
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 year ago

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

              • dan@lemm.ee
                link
                fedilink
                English
                arrow-up
                0
                arrow-down
                1
                ·
                1 year 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.