Postgres pioneer credits Oracle with helping his database take over the world

INTERVIEW Oracle inadvertently helped turn PostgreSQL into the database technology now backed by Microsoft, AWS, and Google, according to Postgres creator Michael Stonebraker.

Speaking to The Register earlier this month, UC Berkeley professor emeritus Stonebraker said Oracle's decision to retain MySQL after buying Sun Microsystems helped propel PostgreSQL toward dominance, at least among systems that use or support its wire protocol.

PostgreSQL was launched 30 years ago this summer, adding SQL support to Stonebraker's earlier Postgres system, first proposed in 1986.

After slowly gaining popularity, PostgreSQL has seen its usage explode in the last five years.

It became the most popular choice of database among developers in 2023, according to the Stack Overflow survey.

Beyond the popular DBMS itself, vendors including the cloud hyperscalers, CockroachDB, and YugabyteDB offer database services with varying degrees of PostgreSQL compatibility.

Microsoft, for example, has contributed to PostgreSQL and launched its own distributed PostgreSQL database service designed to rival other hyperscaler systems and third-party RDBMSes.

Stonebraker reckons PostgreSQL is in the process of taking over the world.

"By PostgreSQL, I mean a database system that's compatible with the wire format, and so that's lots and lots of systems.

All the elephants – Microsoft, Google, and Amazon – have all bet the ranch on the PostgreSQL wire format." Meanwhile, rival system MySQL is "vanishing as a competitor," Stonebraker said.

Oracle acquired MySQL in 2010 as part of its purchase of Sun Microsystems, which had bought MySQL AB just two years earlier.

MySQL won early fans among the second generation of online companies, including Facebook, Google, Twitter, and Uber.

Although Oracle's custodianship of MySQL had been viewed as relatively open, concerns have grown over the past couple of years about Big Red's willingness to invest in the database.

In September last year, Oracle made "widespread layoffs" across its core MySQL development team.