MySQL is still ahead operationally (no vacuum, group replication, gh-ost, optimizer hints, etc.). I would choose it unless one of the Postgres extensions is a killer fit for your project.
Ask HN: It's 2023, how do you choose between MySQL and Postgres?
21–30 of 366 posts
Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#22By choosing SQLite. No server process and a single file per DB which I can put wherever I like.
SQLite is great for its scope - but not in the same class as a full-fledged RDBMS.
Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#23The difference is not significant enough to matter for most projects, esp just starting out. Hence, I mostly choose Postgres, since I don't like Oracle as a company very much.
[deleted]
Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#24[dead]
Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#25Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#26PostgreSQL every time, unless you have a specific reason, or as already pointed out, you're sure you don't just need SQLite.
PSQL in my experience has vastly better tooling, community, and is ahead of the curve tech wise. Same with extensions availability. Or perhaps you need to move away from it to say CockroachDB, or similar which is much easier.
Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#27[deleted]
Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#28Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#29The only instance where I'd choose mysql over postgres is if your database needs are very simple, but you need to be able to scale hard, and your devops aren't skilled enough to manage an advanced postgres setup.
Re: Ask HN: It's 2023, how do you choose between MySQL and Postgres?
#30If Postgres was that much better than MySQL then you would expect to see exact reasons on why to pick it. Every comment so far has not listed any reason.
If you're doing any sort of spatial logic (e.g. mapping), you'll want to use PostGIS.