Hacker News new | ask | show | jobs
by radicality 1626 days ago
Could you comment on why you recommend Postgres (vs say mysql)? I know mysql well but haven’t had much exposure to Postgres.
1 comments
sam_lowry_ 1626 days ago
Postgres implements the SQL standards however awful they are.

MySQL is a bunch of different engines that share a meaningful subset of SQL.

Somehow, Postgres got more popular lately, probably because it makes migrating from Oracle easier.

link
hu3 1626 days ago
just a nitpick: MySQL comes with the same default engine (InnoDB) for at least 10 years now. It is recommended by docs and it is what everyone uses unless they go out of their way to install some very specialized storage engine.

In my years of consulting I have yet to see someone not using just InnoDB in MySQL.

link
f311a 1626 days ago
Yeah, MySQL is well known for weird behavior when it comes to SQL queries that don’t follow SQL standards.
link