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.
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.