Fuck Postgres long live MySQL
https://eng.uber.com/mysql-migratio...

For just half of what you said, you deserve to be lynched right here.

@AlexDeLarge what about MariaDB?

@Artemix I think the best features of PostgreSQL have to do with flexibility. It's a pleasure to code on it. You can use aggregate functions as window functions, you can have recursive queries, easy joins (with using and natural), easy-to-write custom aggregate functions, the ability to use any procedural language (plpgsql, pypg or something, js even), clear error messages, easy type conversion, easy regexp, etc.

There are a ton of things that can be done better, faster in postgresql (like MySQL style partial indexes, MSSQL style CHAR and BIT types that are efficient on memory and speed for small sizes, better clustering, more JSON functions to make working with it easier), but it's still so much better than MySQL, which loses on all of these cases except for the syntax and ease of use of partial indexes.