This morning I came across this Leaving MySQL article. If there's one main point in this article, it would be what the author wrote:
MySQL is a pretty poor database, and you should strongly consider using Postgres instead.
In a footnote, the author specifically mentioned that using MariaDB wouldn't be any better.
I first learned about PostgreSQL because of Ruby on Rails. At that time, I encountered some issues with setting up MySQL, so I used PostgreSQL as the database. Since then, whenever I deal with databases, I always choose PostgreSQL.
Later on, I discovered some attractive features of PostgreSQL, such as support for JSON type (which I remember MySQL didn't have at that time), and its rich indexing options1. I even tried using PostGIS for practicing geospatial applications. Overall, PostgreSQL has always provided me with a great experience, so please continue to choose PostgreSQL.
