In my opinion, both Postgres and MySQL have their places. While I chose Postgres for most of my projects, some 3rd party software just work better with MySQL be

In my opinion, both Postgres and MySQL have their places. While I chose Postgres for most of my projects, some 3rd party software just work better with MySQL because they are written for MySQL first, then ported to Postgres. For example, Hive Metastore still experiences some edge-case bugs when running with Postgres. I would not choose MariaDB for any new projects though, since it's no longer 100% compatible with MySQL, yet I don't see it bringing any game-changing advantage.