In this blog post, I’ll look at a
comparison of PostgreSQL and MySQL.
I came across a post from Hans-Juergen Schoenig,
a Postgres consultant at Cybertec. In it, he dismissed MySQL and showed Postgres as better.
While his post ignores most of the reasons why MySQL is better, I
will focus on where his post is less than accurate. Testing for
MySQL was done with Percona Server 5.7, defaults.
Mr. Schoenig complains that MySQL changes data types
automatically. He claims inserting 1234.5678 into a numeric(4, 2)
column on Postgres produces an error, and that MySQL just rounds
the number to fit. In my testing I found this to be a false
mysql> CREATE TABLE data (
-> id integer NOT NULL, …[Read more]