Bah, don’t mind me — I’m just being opinionated :).

In some only slightly-informed recesses of my mind, I will always think of MariaDB as … off. I’m betting MariaDB still auto-casts between integer and character values, treats "s" as a string value and auto-infers GROUP BY arguments. That makes MariaDB-compatible SQL incompatible with other SQL servers. (Why is that bad? Because it means you can’t even shop around to see which SQL server is best for you.) And MariaDB often doesn’t tell you about your SQL errors: it just calculates something else instead, which you then take to be true…. Oh, and does MySQL let you ROLLBACK schema changes yet?

Apparently some of these oddities are options now. But the defaults are still wrong.

There are three learning curves when switching from MySQL to Postgres:

Mostly, you just need to tame your muscle memory. If you’re starting a new project, you won’t regret trying Postgres.

(I often switch back to MariaDB just to see whether my opinion of it changes. It never does.)

--

--

Journalist, ex software engineer

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Adam Hooper

Adam Hooper

Journalist, ex software engineer