- Both MySQL and PostgreSQL are the most popular Open Source DBMS offered nowadays. They both grant a
great set of features and rich functionality. Excellent end-user support and reliable data management
tools are available for MySQL and PostgreSQL.
- For web solutions MySQL is easier to use with just about the right functionality. Extra features of
PostgreSQL may be confusing and unnecessarily complicated.
- On the contrary, PostgreSQL is more suitable for a complex database system. Using of subqueries, unions,
triggers and consistent procedures is essential for such databases development. This functionality is
hard to write in MySQL.
PostgreSQL has many useful data types. Geographic and geometric data types, native UUIDs, arrays,
hstore, and native JSON as of 9.2. are supportes
PostgreSQL has more advanced stored procedures (functions).
Actually it is difficult to determine objectively which database is likely to be better suited for a given
application. Choosing the right database depends directly on your needs and the features you expect to use.