Hacker News Reader

I would add transactional DDL - rollback of schema changes helps a lot if something breaks in the middle of migration.

I like the array field as well

Which JSON features were lacking in Maria/MySQL?

Binary JSON (JSONB/BSON)

All of them? PostgreSQL has kinda left everyone else in the dust in regards to JSON support.

I'm aware there is Json support in MySQL. But my point is that it's primitive when you compare feature sets of MySQL and PostgreSQL for json.

PL/v8

Converting JSON collections to/from relations

It used to be all of them, but now it is indexing which is missing from MySQL.

Has anyone used virtual columns with MySQL for a direct json-index substitute?

Ah yes. Common table expressions, my most loved feature from the 1999 SQL specification. Has MariaDB added support for them yet?

Yes. Non-recursive CTEs in July 2016, and recursive CTEs in September 2016.

What about MySQL? Has that improvement been implemented there, too?