4 ms·
> MySQL and PostgreSQL have converged in terms of features and performance Is there CTEs in MySQL yet? What about binary JSON and indexes on that? How is imp
by elmigranto 9y ago
> MySQL and PostgreSQL have converged in terms of features and performance
Is there CTEs in MySQL yet?
What about binary JSON and indexes on that?
How is implementing arrays and aggregate functions beyond simple arithmetic going?
Or maybe there is a way to write triggers in Python or JS if I want some performant number crunching with ACID guarantees?
Can DDL statements be rolled back, so I wouldn't have to pull my hair out during development after running migration I'm working on, if it happens to have a typo?
- EwanToo 9y agoCTEs are in MySQL 8 https://dev.mysql.com/doc/refman/8.0/en/with.html https://dev.mysql.com/doc/refman/8.0/en/with.html