Mastering PostgreSQL 9.6

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.

Let me get started by creating a simple table:

MariaDB [test]> CREATE TABLE data (    id    integer NOT NULL,     data  numeric(4, 2) ); Query OK, 0 rows ...