Update: Has SQL Server already lost Mind Share?
In the comments on my previous post, Erdju made the suggestion that I add StackOverflow to my analysis – suggesting that the more SQL Server questions might be found there, changing the result of the analysis. Using the data.stackexchange.com site to analyse data as suggested by Nick Craver (instead of my own, mocked up version) I can now extract recent data for both sites.
This posts contains the updated result as well as a few additions to the previous post.
The query
I used the following query to dig out the data:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
/* Count of questions */ SELECT CreationMonth , SUM(MySQL) AS MySQL , SUM(MSSQL) AS MSSQL , SUM(PostGres) AS Postgres , SUM(Oracle) AS Oracle FROM ( SELECT CAST(YEAR(CreationDate) AS VARCHAR) + '-' + RIGHT('00'+CAST(MONTH(CreationDate) AS VARCHAR) , 2) AS CreationMonth , CASE WHEN Tags LIKE '%mysql%' OR Tags LIKE '%my-sql%' THEN 1 ELSE 0 END AS MySQL , CASE WHEN Tags LIKE '%sql%server%' OR Tags LIKE '%mssql%' OR Tags LIKE '%SSAS%' OR Tags LIKE '%Azure%' THEN 1 ELSE 0 END AS MSSQL , CASE WHEN Tags LIKE '%postgre%' THEN 1 ELSE 0 END AS Postgres , CASE WHEN Tags LIKE '%Oracle%' OR Tags LIKE '%ORCL%' OR Tags LIKE '%sqlplus%' THEN 1 ELSE 0 END AS Oracle , Tags FROM Posts WHERE YEAR(CreationDate) >= 2011 AND PostTypeId = 1 /* Question */ ) AS C GROUP BY CreationMonth ORDER BY CreationMonth |
Result
The result is pretty impressive:
When taking StackOverflow into account, MySQL is a clear winner.
SQL Server people, any additional suggestions that might save your world view?