> JSON support, ability to query it MySQL 5.7 has this, and MySQL 8 improves on it further. Note that MariaDB's implementation is substantially different than

> JSON support, ability to query it MySQL 5.7 has this, and MySQL 8 improves on it further. Note that MariaDB's implementation is substantially different than MySQL's here. > consistent behaviour This one's a bit vague :) But generally using strict sql_mode and innodb_strict_mode go a long way towards alleviating this common complaint. > online backups Online physical backups can be created with Percona's xtrabackup, which is open source. Or for online logical backups, there's always mysqldump, or third-party concurrent options like mydumper. > real spatial extensions, timescale extensions Yeah these ones I definitely see Postgres having a substantial edge, if they're important to your application or workload.