mysql or postgresql? Which is better for an Internet-facing application

submitted by

Hey, Threadiverse! I'm looking for informed opinions on database choices.

I can stand up an Internet-facing application and have it use either MySQL or PostgreSQL. Which is the better choice, and why do you think so?

Thanks!

63

Back to main discussion

PostgreSQL is the more feature rich, but if you don't care about all those features like saving and searching in json structures, Geo data structures and a to of other stuff because you have a simple APO then MySQL is good enough, maybe even SQLite.

 reply
12

Its query planner is also much, much more powerful. Like it's not even close.

There's hardly any good reason to use MySQL today. Postgres is easier and nicer to work with, with a strong community backing it.

SQLite is completely different from both and has entirely different usecases.

 reply
3