4 ms·
Materialized views, common table expressions, outer joins, are all missing in mysql and essential. The Postgresql's stored procedure language blows mysql out of
by danmg 7y ago
Materialized views, common table expressions, outer joins, are all missing in mysql and essential. The Postgresql's stored procedure language blows mysql out of the water, and it's possible to use different language backends.
SQLite has json extensions. You need to select them at compile time though, so you can't just assume they'll be there by default.
- evanelias 7y agoMySQL has supported left/right outer joins for as long as I can remember, and I've been using it continuously since 2003. MySQL doesn't support full outer join, but it's rarely needed, and you can often get a similar result using a UNION. (Clunky, I'll admit... but I'd say the same thing about Postgres recommending against use of NOT IN, which is a common construct and more readable than an anti-join.) CTEs were added in MySQL 8.0 (~1.5 years ago). Agreed on the other points.
- anarazel 7y ago> . but I'd say the same thing about Postgres recommending against use of NOT IN, which is a common construct and more readable than an anti-join. The recommendation against that is due to the semantics defined in the standard. If there is any NULL in the list matched against, the entire a NOT IN (...) expression also has to evaluate to NULL. Which is extremely confusing to most people (and has some consequences in how efficient things can be executed).