Hacker News new | ask | show | jobs
by arjn 4828 days ago
We use both in our production and staging environment. I've been using both for the last 3 years (5 years for MySql). My opinion at this time is that in 80% of cases MySQL is easier to setup, use and manage.
1 comments

Only if 80% of the use cases are extremely simple use cases, with no need for multiple indexes per table, complex queries, common table expressions, user defined datatypes, window functions, asynchronous queries, or a strict stance on undefined behaviors, etc.

The problem I see is that simple use cases gradually become slightly-less-simple use cases. And the pain of switching is 1000x the pain of taking a few extra steps up front and using a better database.

I doubt all the stuff you listed is used even in 1% of cases, except multiple indexes and strict stance. And MySQL supports both.
All the stuff, sure. But I have yet to find a scenario that doesn't involve at least one of them.