Handling data in MySQL and MariaDB

As you might imagine, and as you might have noticed already, I am far from unbiased when it comes to databases. However, I don't want to turn this into blind MySQL/MariaDB bashing. My goal is really to show you why MySQL and MariaDB can be such a pain in the long run. I am biased for a reason and I really want to point out why this is the case. All the things you are going to see are deeply scary and have serious implications on the migration process in general. I have pointed out already that MySQL is somewhat special, and this section will try to prove my point.

Again, the following examples assume that you are using a version of MySQL/MariaDB that does not have strict mode on, which was the case when ...

Get Mastering PostgreSQL 10 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.