by m_st on 1/14/25, 1:19 PM
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.
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.
For our next product, we're sure to bet on PostgreSQL instead.
by cpursley on 1/14/25, 2:06 PM
by jasoncartwright on 1/14/25, 1:59 PM
After coming back to coding after ~10-15 years away, databases are IMHO the most improved element of the dev/devops experience.
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.
by ExoticPearTree on 1/14/25, 12:53 PM
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.
Otherwise, PostgreSQL is fantastic.
by nttdocomo on 1/14/25, 12:53 PM
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.
by paxys on 1/14/25, 3:01 PM
From their methodology page (
https://db-engines.com/en/ranking_definition), it seems they use:
- Number of search results for each DB's name
- Google Trends
- Mentions in Stack Overflow etc.
- Mentions in Tweets
- Mentions in people's LinkedIn profile
Probably gives a vague idea of popularity of the system, but the measure is otherwise pretty useless.
by xiphias2 on 1/14/25, 4:58 PM
It's a bit strange that SQLite went up only 1 place on the ranking (to the 10th).
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.
It is now the default production database for Rails for a good reason.
by INTPenis on 1/14/25, 5:37 PM
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.
by mhartz on 1/14/25, 2:14 PM
Obviously there's some level of subjectiveness here, but how many years could they realistically have gotten his award?
by pjmlp on 1/14/25, 2:52 PM
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.
https://db-engines.com/en/ranking
by AsianOtter on 1/14/25, 8:24 PM
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).
by paulryanrogers on 1/14/25, 11:31 PM
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.
Also, where is ValKey?
by zild3d on 1/14/25, 1:37 PM
by giovanni_or2 on 1/14/25, 2:57 PM
Deserved, Postgres is enough for 95% of normal use cases
by t14000 on 1/15/25, 8:04 AM
db-engines.com is the Website of the Year 1994