Re:Postgres 11 – A First Look
by petre on Saturday September 22, 2018 @01:14AM
(#18044579)
JSON support, ability to query it, JSONB support, real spatial extensions, timescale extensions, consistent behaviour, online backups. We now have to migrate from MySQL to Postgres because of these features. Instead of MySQL 8 we will be probably usng Pg 11. Now we are using MariaDB.
[ Parent
| on HN ]
> 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.