Ask HN: It's 2023, how do you choose between MySQL and Postgres?
There is almost no good reason to choose MySQL over PostgreSQL for any operational reason, I did a deep dive many moons ago (before major improvements in performance to postgres) and people were <i>saying</i> that MySQL was faster. I found that not to be true and the differences have only gained even more favour towards postgres.<p>also, I assume you mean MariaDB as MySQL is owned by Oracle and I would greatly implore anyone and everyone to avoid Oracle as if it has herpes.<p>There are a lot of historic problems with MySQL accepting invalid data, committing data even when there are constraint issues, and having very poor transactional isolation, I am not sure if these have improved.<p>Truthfully, the <i>only</i> benefits you gain from using MariaDB or MySQL are:<p>* Memory tables<p>* Having inconsistent replicas (which can be useful when you want your downstream to have less data than your upstream and you know it won’t get updated.)