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
    link
    English
    21 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?

        • @[email protected]
          link
          fedilink
          English
          3
          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
            link
            English
            21 year ago

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

            • @[email protected]
              link
              fedilink
              English
              01 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.