Difference between MySQL and Postgresql

Question

What is the difference between MySQL and Postgresql?

Answer 1

• 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

Answer 2

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.

Answer 3

Thank you Fox and Tibor Santa for your answers