3 ms·
I happened to be talking about this with a couple of friends just moments ago. Their opinion basically amounted to this: * MySQL is a really awful database. It
by mcv 10y ago
I happened to be talking about this with a couple of friends just moments ago. Their opinion basically amounted to this:
* MySQL is a really awful database. It's usable only for small hobby projects, like a simple Wordpress site or so. For serious datasets, it's a horror. Complex queries on large amounts of data are just broken. Many features don't work or work incorrectly. The design is fundamentally flawed.
* Use PostgreSQL instead.
* If you absolutely have to use MySQL, use MariaDB instead. It's a fork that fixed some of the issues.
* Still better use PostgreSQL. Or even Oracle or SQL Server. They're fine, MySQL is not.
- 6t6t6t6 10y agoIt could be interesting to ask them what are they basing their opinion on and if they can enumerate all the advantages of one database over the other. > use MariaDB instead. It's a fork that fixed some of the issues. Which ones exactly? ;)
- mcv 10y agoCheck their changelog, but one example I've heard is that a simple 15 minutes upgrade to MariaDB improved performance for a particular query by a factor 5.