Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).

A long-time MySQL user explains why they now recommend PostgreSQL for new projects. The post acknowledges that many historical PostgreSQL weaknesses (VACUUM complexity, DDL operations, replication) have become less relevant in the managed cloud era. It then details concrete application-level advantages PostgreSQL still holds:

#database

#sql

#postgresql

#mysql

#pgvector

Mar 17•17m read time•From dev.to

Table of contents

What used to be considered disadvantages of PostgreSQL has become much less significant Even so, PostgreSQL is stronger for application implementation First, the things MySQL 8 added and narrowed the gap on ON CONFLICT DO NOTHING is not a replacement for INSERT IGNORE RETURNING is very powerful VALUES helps in real implementation Being able to bring window functions into update processing is powerful Partial indexes are a clear feature difference Foreign keys are much better in PostgreSQL In MySQL, you cannot do vector operations Character sets and collations are still more complicated in MySQL Summary