The latest DB-Engines Database Rankings are available, and it shows that Microsoft continues to gain ground on Oracle/MySQL:

I’ve been following the DB-Engines ranking for a few years and would encourage you to do the same. The rankings are not an exact science. You can read for yourself how they are calculated. One thing to note here is the selection bias in how they collect their data. The rankings show a clear preference for systems that have a lot of engagement online. It doesn’t talk about revenue, the number of installations, or if the engagement online is negative or positive.

That means a system like DB2 or even the artist formerly known as Sybase doesn’t have as much engagement online as MySQL. DB2 and SAP are ranked lower than the newer, hipster data platforms. But if you were to find a way to factor in things like revenue or licensing you might find those systems ranked a bit higher. Still, despite all of that, I do find some value in the overall trends.

It might also be interesting to note the number of exposed database platforms on the internet. A quick search of Shodan would show that PostgreSQL leads the way with Mongo DB being a distant second place:

I do wish the rankings would include the popularity of a system installed in an unsecured manner by default. But I digress…

One of the things I like most at the DB-Engines report is that it lists both relational (RDBMS) and non-relational (NoSQL) platforms. Even better, it offers a breakdown of all the systems, allowing for us to see the variety in the NoSQL world – document, graph, key-value, time series, object oriented, etc. This helps point out the deep variety of data platforms that exist for users. This also explains why it can be frustrating for a company to decide on one platform (say, SQL Server) only to find that a year later they need a piece of functionality that is best served by something else (say, a document store).

This also explains why we have systems listed as “multi-store”, such as Azure Cosmos Database. I’ve briefly written about Cosmos DB and I’ll share more thoughts on Cosmos DB in my next newsletter. But for now, I wanted to show you that the DB-Engines rankings also offer a trend page. Here is the latest trend for multi-store systems:

Notice the recent spike for Azure Cosmos DB correlates nicely to the official launch announcement this past April. This is due to the rankings weighted towards product mentions online. But Cosmos DB (nee DocumentDB) has been rising for a while now. Cosmos DB is the 2nd ranked multi-store system. I would wager it will be the top system by the end of the year. Maybe even the end of Q3.

Bookmark the DB-Engine page for reference. It’s not perfect, but it is a nice guide as to how database systems are trending in the market.