3 ms·

Is there anything PostgreSQL can't do? Incidentally at work I find myself repeatedly having fun with MariaDB fans. They got started with something and never co

Is there anything PostgreSQL can't do? Incidentally at work I find myself repeatedly having fun with MariaDB fans. They got started with something and never considered the alternative. Some of the responses to "yeah but what can it do that MySQL can't?" * Parser errors instead of undefined behaviour (e.g. MySQL allows you to query non-aggregate functions that are not in the group by clause) * Boolean type * Window functions (MySQL has just caught up here) * Functions/stored procedures/other languages (MySQL has some of this but on PostgreSQL it is nice) * Less gotchas WRT transaction integrity * Extensions! I'm sure you guys can fill in the rest better than I can. I'm really interested in the possibility of using CitusDB in our project but I just can't get enough information suitable for small-medium enterprise.

setr 6y ago
Regarding MySQL -- check constraints were parsed and accepted without error/warning until v8.0.16. An act so offensive to the sensibilities that I personally consider it enough of a reason to write off the database entirely. It's just fucking rude
- Tostino 6y ago
  First time I played with MySQL I was bit by this when I was writing a personal app that was supposed to work with MySQL and Postgres. Thought all my schema was fine, then ended up running into a whole bunch of bugs my check constraints were supposed to prevent when using MySQL. I just dropped support for MySQL after that.
- tyingq 6y ago
  I wonder if this feature request might get attention soon: https://bugs.mysql.com/bug.php?id=12654 https://bugs.mysql.com/bug.php?id=12654
redis_mlc 6y ago
Note: Most of the comments in the parent are out of date. There's nothing wrong with using Mariadb/MySQL - Google and Facebook have made trillions of dollars using them. In addition, there's an implication that MySQL has to have all the features of Postgres, which isn't true. I still prefer the grant and replication features of MySQL over Postgres.
ramraj07 6y ago
Partitioning/clustering data apparently

setr 6y ago

Regarding MySQL -- check constraints were parsed and accepted without error/warning until v8.0.16. An act so offensive to the sensibilities that I personally consider it enough of a reason to write off the database entirely. It's just fucking rude

Tostino 6y ago
First time I played with MySQL I was bit by this when I was writing a personal app that was supposed to work with MySQL and Postgres. Thought all my schema was fine, then ended up running into a whole bunch of bugs my check constraints were supposed to prevent when using MySQL. I just dropped support for MySQL after that.
tyingq 6y ago
I wonder if this feature request might get attention soon: https://bugs.mysql.com/bug.php?id=12654 https://bugs.mysql.com/bug.php?id=12654

redis_mlc 6y ago

Note: Most of the comments in the parent are out of date. There's nothing wrong with using Mariadb/MySQL - Google and Facebook have made trillions of dollars using them. In addition, there's an implication that MySQL has to have all the features of Postgres, which isn't true. I still prefer the grant and replication features of MySQL over Postgres.

ramraj07 6y ago

Partitioning/clustering data apparently