What is going on with SQL Server there? I moved from MySQL to SQL Server and there's been a handful of gotchas but for the most part it's been an incredibly simple transition -- SQL Server is as close to MySQL as Postgres is in terms of query language, I should think, certainly closer than Redshift or Vertica are -- but the pairwise comparison doesn't bear it out. The author also talks about SQL Server distinct from MySQL or Postgres, which he kinda lumps together. It's rather baffling to me.
So this is analyzing Mode's users queries to make some conclusions about what's best for analysts. How do we know Mode users are representative of a typical analyst for any given SQL variant? Perhaps their Vertica users have complex data and the queries are thus more complex, and the MySQL users are dealing with something more straightforward so use simpler queries. This doesn't necessarily mean that MySQL is better for every analyst just because certain Mode users wrote simpler queries.
As others mentioned this seems like advertising or something. Maybe some VP somewhere will look at this and go "oh man we gotta use a better database, and oh look, let's buy some Mode licenses because I like dashboards."
7 comments
[ 3.1 ms ] story [ 22.1 ms ] threadAs others mentioned this seems like advertising or something. Maybe some VP somewhere will look at this and go "oh man we gotta use a better database, and oh look, let's buy some Mode licenses because I like dashboards."