Showdown: MySQL 8 vs. PostgreSQL 10

Now that MySQL 8 and PostgreSQL 10 are out, it’s a good time to revisit how the two major open source relational databases compete against each other.
Before these versions, the general perception has been that while Postgres is superior in feature sets and its pedigree, MySQL is more battle tested at scale with massive concurrent reads/writes.
But with the latest releases, the gap between the two has gotten significantly narrowed.
Feature Comparison
Let’s take a look at the “trendy” features that we all love to talk about.
Features
MySQL 8
PostgreSQL 10
Query & Analytics

Common Table Expressions (CTEs)
✔ New

Window Functions
✔ New

Data Types

JSON support
✔ Improved

GIS / SRS
✔ Improved

Full-text Search


Scalability

Logical Replication

✔ New
Semi-synchronous Replication

✔ New
Declarative Partitioning

✔ New
It used to be easy to say that


Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/JeBpJrn2A7s/

Original article

Comments are closed.

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑

%d bloggers like this: