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'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're sure to bet on PostgreSQL instead.
Turns out Postgres Is Enough: <a href="https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f06dbb" rel="nofollow">https://gist.github.com/cpursley/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/devops experience.<p>Managed Postgres on Google Cloud is a fantastic product (I'm sure other cloud's offerings are also similarly good). Backups, replication, point-in-time recovery, managed updates, plus quick & easy system & query insight tooling. All for less than £1/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've never regretted going with postgres whenever I choose it.
From their methodology page (<a href="https://db-engines.com/en/ranking_definition" rel="nofollow">https://db-engines.com/en/ranking_definition</a>), it seems they use:<p>- Number of search results for each DB's name<p>- Google Trends<p>- Mentions in Stack Overflow etc.<p>- Mentions in Tweets<p>- Mentions in people's LinkedIn profile<p>Probably gives a vague idea of popularity of the system, but the measure is otherwise pretty useless.
It's a bit strange that SQLite went up only 1 place on the ranking (to the 10th).<p>There's a lot of new articles of how to improve its performance and I love that I don'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'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've preferred postgres. Even though I couldn't tell you on a technical level what exactly makes it better.
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://db-engines.com/en/ranking" rel="nofollow">https://db-engines.com/en/ranking</a>
I was surprised to see such a big jump in ClickHouse (up 7 places). Now it'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've ever talked to who used it was trying to get off it or complaining they'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://db-engines.com/en/ranking" rel="nofollow">https://db-engines.com/en/ranking</a>