I’ve been using Postgres in a Phoenix application for the last couple of years and I’m looking for reasons to try MySQL in a new project. Mainly because I’m getting tired of some Postgres particularities, like not being able to properly / easily reorder table columns among other things.
I’ve toyed around with MySQL in another project in the past, but unfortunately, the project was very limited in scope, so I didn’t have the chance to stress the MyXQL driver enough.
This new project I’m working on will have to deal with a large dataset (I’m currently testing a basic setup with 80k+ rows of curated content), geolocation, and a lot more reading than writing.
I started using Postgres but I’m looking into MySQL 8 because it seems it’s a viable contender nowadays. Also, I’m looking into the ease of use factor, since MySQL is still one of the most well-known databases.
I’m assuming that since Postgres is the default database in a new Phoenix application it is preferred over MySQL by the core team. But I’m not sure if this is a matter of preference or support/ maturity.
So, I’d like to hear from you: Do you have a real use case of MySQL over Postgres? Are you working on a MySQL project right now? What are you missing from Postgres, any gotchas? And so on…