Hacker News Reader

> Many cons have been fixed.

it would be easier if you listed what you mean by "cons". Postgres is much much more powerful than MySQL if you are really into SQL and exploiting an RDBMS, MySQL administration is simpler.

This question is a bit too vague to warrant a specific answer.

View on HN

> Postgres is much much more powerful than MySQL

I would say this used to be true in 5.5 and before but it's less and less of an argument. 5.6 and 5.7 bring a lot of features like JSON or geospatial. Here's a list of the new feature of 5.7:

http://www.thecompletelistoffeatures.com/

I've been looking at MySQL's JSON and it's still pretty incomplete compared to PostgreSQL. It's still far superior to SQLServer 2016's abysmal offering of JSON support tho.

(Want to be able to support Marten document store on more than 1 database)

> MySQL administration is simpler

How?

You have more GUI administration tool options with MySQL. For example, most people are used to PHPMyAdmin from the shared host era, and it has usually been "good enough".

I'm not sure how that's any different from pgAdmin, DataGrip, phpPgAdmin, and the many other tools out there for managing PostgreSQl.

Reply on news.ycombinator.com