For the basic user just doing CRUD stuff, is there any important difference these days?
PostgreSQL offers a lot more data types and index types out of the box. And if that isn't enough, there are more available as extensions. Also data types differ in implementation. For example a boolean in MySQL is implemented as tinyint. Ans you can write the whole tinyint range into a boolean in MySQL. PostgreSQL takes exactly three values: NULL, true, false. And not to speak about broken backups in MySQL due to design failures of their implementation.
Обсуждают сегодня