4 ms·
> MySQL works fine if you chiefly interact with your DB through an ORM or using basic queries. I ran into an issue [1] with MariaDB a year and a half ago: 'SEL
by pg314 10y ago
> MySQL works fine if you chiefly interact with your DB through an ORM or using basic queries.
I ran into an issue [1] with MariaDB a year and a half ago: 'SELECT * FROM table' failed to return a large fraction of the rows of that table. Selecting them in a number of different queries with ranges of ids worked fine. Nothing fancy, no transactions, on an idle database. I might have been unlucky, but I will pick PostgreSQL over MySQL/MariaDB any day if I have the choice. Having had a cursory look at the MariaDB source code and a more in-depth look at the PostgreSQL source code confirms that preference.
[1] https://jira.mariadb.org/browse/MDEV-9347?page=com.atlassian.jira.plugin.system.issuetabpanels%3Achangehistory-tabpanel https://jira.mariadb.org/browse/MDEV-9347?page=com.atlassian...
- falcolas 10y agoMariaDB != MySQL They're protocol compatible, but MariaDB has been drifting away from the core storage engines and optimizer for some time. For good and ill (I think you hit the latter).