7 ms·
> 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 SQ
by camus2 10y ago
> 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.
- mickeyben 10y ago> 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/ http://www.thecompletelistoffeatures.com/
- philliphaydon 10y agoI'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)
- floatboth 10y ago> MySQL administration is simpler How?
- egeozcan 10y agoYou 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".
- philliphaydon 10y agoI'm not sure how that's any different from pgAdmin, DataGrip, phpPgAdmin, and the many other tools out there for managing PostgreSQl.