News for hackers. Stuff that matters.
Re:Postgres 11 – A First Look by evanelias on Saturday September 22, 2018 @12:05PM (#18046521)
> 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.

There are no comments on this comment yet.