Could you point the vantages (disadvantages) of using PostgreSQL instead of MySQL?

Hi Experts

Could you point the vantages (disadvantages) of using PostgreSQL instead of MySQL?

Preferencialy based on your own conclusions.

Thanks in advance!
Eduardo FuerteDeveloper and AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
Well this depends...  
- on the database and project size (small projects do not differentiate between these two db engines)
- on the project type (PHP pages use MySQL preferably, PostgreSQL is better for e.g. Trac ticketing system)
- on required features
- on the customer preferences
- on the team members experience
- on the management decisions

You may read several comparisons, e.g. https://uk.godaddy.com/help/key-differences-between-mysql-vs-postgresql-12392
this is even better: https://www.2ndquadrant.com/en/postgresql/postgresql-vs-mysql/

but you may find much more:
https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems
https://www.quora.com/What-are-pros-and-cons-of-PostgreSQL-and-MySQL-With-respect-to-reliability-speed-scalability-and-features
etc.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Julian HansenCommented:
MySQL
- a lot of community support
- ACID compliant only if you use INNODB
- Drifted from SQL standard a bit
PostGres
- Not as much community support
- ACID Compliant
- More SQL compliant

It is highly dependent on project and personal preference which one you use. Both are readily available and easy to use with PHP, both are open source.

Check out what your project needs and then check which of the two DB's best support those requirements.
0
Eduardo FuerteDeveloper and AnalystAuthor Commented:
Thank you for replies!

A lot of material to study.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PostgreSQL

From novice to tech pro — start learning today.