3 ms·
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 g
by sam_lowry_ 5y 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.
- hu3 5y agojust 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.
- f311a 5y agoYeah, MySQL is well known for weird behavior when it comes to SQL queries that don’t follow SQL standards.