4 ms·
I’m pretty sure it wouldn’t follow any; I can’t imagine any significant benefit (if you’re not chasing strict compatibility, general SQL should take you more th
by setr 7y ago
I’m pretty sure it wouldn’t follow any; I can’t imagine any significant benefit (if you’re not chasing strict compatibility, general SQL should take you more than far enough on the beginner-friendly front) and significant benefit from doing a custom SQL
- paxys 7y agoA benefit of following an established standard is that one can use this not just to write a new engine but also to build internal tooling (static analysis, linters, IDE tools etc.) for an existing one (e.g. MySQL).
- djhaskin987 7y agoWhat significant benefit
- davidjnelson 7y agoThings like late row lookups in mysql that are not an issue in postgres https://explainextended.com/2011/02/11/late-row-lookups-innodb/ https://explainextended.com/2011/02/11/late-row-lookups-inno...
- riffraff 7y agoaren't both executions (mysqls' and postgresqls') acceptable from an SQL point of view? I don't think the SQL standard mandates how the DBMS executes the query. In fact, I seem to remember that was on of the purposes of having an high level language.