[j45]

I have used MySQL for far, far longer than Postgres. My brain still thinks in MySQL. I like it for pretty much everything first if I have my way.

MySQL is very capable until it isn’t.

I’m surprised how many of the hundreds of hours of tweaking that were needed in MySQL when reaching scaling issues aren’t.

I realize most people will try to pick the best, but there is none. MySQL is perfectly good to learn and use at the same time as Postgres.

Postgres can be more complex out of the box but some of the things it has are too hard to ignore.

While I can use the command line, I prefer to have something with good tooling to help create beginners. Postgres is behind here.

I decided to use Postgres for a project and it was too much of a headache compared to MySQL - it was new to me as well, until I reached a problem that it solved without issue and MySQL had tripped up at. In this case I was dealing with tens of millions of rows as a starting point.

Learning to do something the Postgres way compared to how my brain knows how to use MySQL has been helpful and slowly improving.