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 FuerteAsked:
Who is Participating?
 
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
 
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 FuerteAuthor Commented:
Thank you for replies!

A lot of material to study.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.