Skip to content
BENIBIX Learn

PostgreSQL vs MySQL

Both are free SQL databases. PostgreSQL is stricter and has more tools; MySQL is simple to start and runs a huge share of websites.

Development🗃️ Databases

PostgreSQL

A free, open-source SQL database with lots of tools. Many teams pick it first.

PostgreSQL is a free SQL database known for being careful. It is open source and full of tools. It keeps all four ACID promises and sticks close to the SQL standard. It can also store JSON, map data and text search in the same place. It began as a research project at a big school in 1986. Many teams now pick it as their first choice.

Example
Lucy starts a new booking app and picks PostgreSQL. Its server listens on port 5432 by default.
Why it matters
PostgreSQL is a safe choice for most new apps. It grows with you from one user to millions.
Full entry
Development🗃️ Databases

MySQL

A popular, free SQL database. A huge share of websites run on it.

MySQL is a popular open-source relational database, first released in 1995. It powers a huge share of websites, including most WordPress sites. It is fast for simple reads and easy to set up. A close copy called MariaDB was started by its first author and works almost the same. Its server listens on port 3306 by default.

Example
Jack's WordPress blog stores every post and comment in MySQL. Oracle has owned MySQL since 2010.
Why it matters
If you work on websites, you will meet MySQL. It is behind a great many of them.
Full entry

In one line

PostgreSQL
A free, open-source SQL database with lots of tools. Many teams pick it first.
MySQL
A popular, free SQL database. A huge share of websites run on it.