flâneur

Leaving MySQL | Hacker News

news.ycombinator.com · 10,378 words · saved by 1 readers

> More jarring were the people who insisted everything was OK (it seems most MySQL users and developers don't really use other databases) I only have anecdata of my usages of MySQL and Postgres but I swear people that cut their teeth on MySQL and have never used Postgres just don't know what they are missing. Yes Postgres can be slower out of the box and yes Postgres has worse connection handling that usually requires a pooler but the actual engine and it's performance makes it worth it in my opinion. Logical Replication is the big one. MySQL has had logical (and "mixed") replication for a decade (or more?). PostgreSQL has gotten built-in logical replication only recently, and it's still very annoying. It doesn't replicate schema change statements, so those have to be applied independently by some external system, and of course it's not going to be timed exactly right so replication will get stuck. And somehow for very lightly active applications generating just a few MB of writes per

> MySQL is a pretty poor database, and you should strongly consider using Postgres instead. Wow, right on the chin with that one. > More jarring were the people who insisted everything was OK (it seems most MySQL users and developers don't really use other databases) I only have anecdata of my usages of MySQL and Postgres but I swear people that cut their teeth on MySQL and have never used Postgres just don't know what they are missing. Yes Postgres can be slower out of the box and yes Postgres has worse connection handling that usually requires a pooler but the actual engine and it's…

related reading