+ 1

Difference between MySQL and Postgresql

What is the difference between MySQL and Postgresql?

1st May 2021, 7:02 AM
Nfamara Ceesay
Nfamara Ceesay - avatar
3 Answers
+ 9
• PostgreSQL is an Object Relational Database Management System (ORDBMS) whereas MySQL is a community driven DBMS system. • PostgreSQL support modern applications feature like JSON, XML etc. while MySQL only supports JSON. • PostgreSQL performs well when executing complex queries whereas MySQL performs well in OLAP & OLTP systems. • PostgreSQL is complete ACID compliant while MySQL is only ACID compliant when used with InnoDB and NDB. • PostgreSQL supports Materialized Views whereas MySQL doesn’t supports Materialized Views. Source: https://www.guru99.com/postgresql-vs-mysql-difference.html
1st May 2021, 7:07 AM
Fox
Fox - avatar
+ 5
I dislike the quality of this guru99 article. It is very superficial and sometimes even wrong. For example, last MySql also has support for XML. A much better article is this: https://www.postgresqltutorial.com/postgresql-vs-mysql/ From Bird's eye view, both are free and open source RDBMS systems, there is very minor difference in the SQL dialect, and they have very similar range of features. Mysql does not have full outer join and does not have materialized views, this much is true. Pgsql has additional data types such as array. So the majority of differences are in the advanced features and technological details, that are mostly irrelevant for the average developer.
1st May 2021, 9:16 AM
Tibor Santa
Tibor Santa - avatar
+ 1
Thank you Fox and Tibor Santa for your answers
1st May 2021, 11:44 AM
Nfamara Ceesay
Nfamara Ceesay - avatar