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.

  • NOT_RICK@lemmy.world
    link
    fedilink
    English
    arrow-up
    2
    ·
    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
          4
          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
            2
            ·
            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
              1
              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.