3 ms·
Could you comment on why you recommend Postgres (vs say mysql)? I know mysql well but haven’t had much exposure to Postgres.
by radicality 5y ago
Could you comment on why you recommend Postgres (vs say mysql)? I know mysql well but haven’t had much exposure to Postgres.
- sam_lowry_ 5y agoPostgres 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.