PostgreSQL is the Database Management System of the Year 2024

I so badly wish we could change a big Windows business application to use PostgreSQL rather than Microsoft SQL Server just because of the licensing costs. SQL Server is a fantastic product, but restricted to 128GB RAM and a few CPU cores or you have to start paying so much, that not even our biggest customers can justify it.<p>Migration isn&#x27;t easy, as this venerable application uses ADO.NET Datasets with TableAdapters and plenty of stored procedures. The syntax is almost compatible though. But not enough unfortunately.<p>For our next product, we&#x27;re sure to bet on PostgreSQL instead.

Turns out Postgres Is Enough: <a href="https:&#x2F;&#x2F;gist.github.com&#x2F;cpursley&#x2F;c8fb81fe8a7e5df038158bdfe0f06dbb" rel="nofollow">https:&#x2F;&#x2F;gist.github.com&#x2F;cpursley&#x2F;c8fb81fe8a7e5df038158bdfe0f...</a><p>(Gist contains a bunch of Postgres ecosystems things, if anything is missing, please let me know)

After coming back to coding after ~10-15 years away, databases are IMHO the most improved element of the dev&#x2F;devops experience.<p>Managed Postgres on Google Cloud is a fantastic product (I&#x27;m sure other cloud&#x27;s offerings are also similarly good). Backups, replication, point-in-time recovery, managed updates, plus quick &amp; easy system &amp; query insight tooling. All for less than £1&#x2F;day.

I wish someone that has resources to invest into making the replication in PostgreSQL seamless, easy to configure and easy to change masters without anything like pgbounce and friends.<p>Otherwise, PostgreSQL is fantastic.

The methodology and general concept of this is a bit silly IMO, but that being said I&#x27;ve never regretted going with postgres whenever I choose it.

From their methodology page (<a href="https:&#x2F;&#x2F;db-engines.com&#x2F;en&#x2F;ranking_definition" rel="nofollow">https:&#x2F;&#x2F;db-engines.com&#x2F;en&#x2F;ranking_definition</a>), it seems they use:<p>- Number of search results for each DB&#x27;s name<p>- Google Trends<p>- Mentions in Stack Overflow etc.<p>- Mentions in Tweets<p>- Mentions in people&#x27;s LinkedIn profile<p>Probably gives a vague idea of popularity of the system, but the measure is otherwise pretty useless.

It&#x27;s a bit strange that SQLite went up only 1 place on the ranking (to the 10th).<p>There&#x27;s a lot of new articles of how to improve its performance and I love that I don&#x27;t have to care about the n+1 problem so much.<p>It is now the default production database for Rails for a good reason.

I don&#x27;t know anything about db-engines.com but I have literally been hearing nothing but good things in regards to postgres for 20 years now. My very first job the boss told me a story of how they helped a client who was throwing hardware at their mysql DB by migrating them to postgres. Ever since I&#x27;ve preferred postgres. Even though I couldn&#x27;t tell you on a technical level what exactly makes it better.

Obviously there&#x27;s some level of subjectiveness here, but how many years could they realistically have gotten his award?

I wonder how they came to this conclusion given that the ranking page shows otherwise, with Oracle first, having a score of 1258.76 over PostreSQL at 4th place having a score of 663.41.<p><a href="https:&#x2F;&#x2F;db-engines.com&#x2F;en&#x2F;ranking" rel="nofollow">https:&#x2F;&#x2F;db-engines.com&#x2F;en&#x2F;ranking</a>

I was surprised to see such a big jump in ClickHouse (up 7 places). Now it&#x27;s higher than Spark but lower than Hive and HBase (they were trendy around the first half of 2010x).

How is Oracle in the top spot? Everyone I&#x27;ve ever talked to who used it was trying to get off it or complaining they&#x27;re only on it because of regulatory capture.<p>Also, where is ValKey?

Confused why their ranking has postgres at 4 then?<p><a href="https:&#x2F;&#x2F;db-engines.com&#x2F;en&#x2F;ranking" rel="nofollow">https:&#x2F;&#x2F;db-engines.com&#x2F;en&#x2F;ranking</a>

Deserved, Postgres is enough for 95% of normal use cases

db-engines.com is the Website of the Year 1994