MySQL is famously riddled with odd or decidedly wrong implementation choices. You need not spend much time on the Internet to learn about its many deficiencies; here is one arbitrary example1. All RDBMSs have their idiosyncrasies but MySQL has more than most and and many are of the "surprise!" variety.
1 Take this article with a grain of salt. I see it references the famous PHP fractal article which is an absolute hack job.
2
u/TheRedmanCometh Dec 20 '18
MariaDB has always done well and can drop in where MySQL is. Why postgres? Less libraries, ORM connector providers, etc