Having had to migrate a messy legacy system from old MySQL to modern MariaDB, I can confidently say that I never wish to work ever again with anything MySQL related. Postgres is much more boring than MySQL, and that's a good thing.

Edit: in case you're curious, part of the reason why I found it so difficult was because of MySQL's take on UTF-8 support.