* Posts by dbdemon

3 publicly visible posts • joined 11 Jun 2018

Latest MySQL release is underwhelming, say some DB experts

dbdemon

An observation

This database-related news article does not actually mention PostgreSQL. Just saying.

Let's take a look at Oracle's love and hate relationship with open source software

dbdemon

"Am I missing something?"

In a word - yes. Both MySQL and especially MariaDB have come a long way since the early days you talk about. Indeed, so has Postgres, but Postgres is still a "one connection = one process" database, and of course you still has all the fun of vacuuming. And Postgres also doesn't replicate DDL statements, which is a bit ridiculous.

Don't read this, Oracle... It's the rise of the open-source data strategies

dbdemon

Stored procedures

"PostgreSQL, in particular, has made it relatively straightforward to migrate things like stored procedures from Oracle to PostgreSQL."

Wait, wait ...! PostgreSQL doesn't even *have* stored procedures! (But it will in the upcoming version 11.) I think the author actually means MariaDB which has implemented a subset of PL/SQL in its most recent version, 10.3. MariaDB now also supports a lot of other features found in Oracle, such as sequences.

Full details here:

https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-103/

Also: "Widen that aperture a bit and you get MariaDB, a fork of MySQL, in the 15th spot."

That should read "13th spot"! Check it out:

https://db-engines.com/en/ranking

Just saying :)