Database Management: MySQL or PostgreSQL?

PostgreSQL. Too bad WP doesn't support it natively

PostgresSQL no contest

There used to be a difference in features between the two, but I think that difference has almost disappeared now. both have evolved a lot. I tend to use PostgreSQL, because Redshift is also PostgreSQL-based.

They are both powerful and scalable, but they have different strengths and weaknesses. MySQL is generally considered to be easier to learn and use than PostgreSQL. It is also more widely used, which means that there is more documentation and support available. However, MySQL is not as scalable as PostgreSQL and it does not support as many features. PostgreSQL is more complex than MySQL, but it is also more powerful and scalable. It supports a wider range of features. PostgreSQL is also more secure than MySQL.

Postgres is a very easy first choice for pretty much any project of any size. (if you're lucky enough to hit massive scale then migrating will be a nice problem to have 😉)

In have worked with many databases like SQL Server, Oracle, Postgres, etc. I liked Postgres the most because of its features. In my opinion, Postgres has some advantages over MySQL: Postgres can handle better concurrency (create indexes in a non-blocking way, supports parallel query plans that can use multiple CPUs/cores, can create partial indexes), it supports a number of advanced data types not available in MySQL (geometric/GIS, network address types, JSONB which can be indexed, native UUID, timezone-aware timestamps), you can also add your own datatypes, operators, and index types. PostgreSQL adhere to SQL standards more rigorously than MySQL Postgres is a truly open-source and community driven.