4 ms·
> It's the awful queries that do in memory sorting or make temporary tables for no reason or read-after-write, etc. Are there any viable alternatives though? I
by Varriount 3y ago
> It's the awful queries that do in memory sorting or make temporary tables for no reason or read-after-write, etc.
Are there any viable alternatives though? I often wonder what an SQL-like language built from the ground up would look like.
- erulabs 3y agoThe alternative is to write good queries! Alternatively, a better query planner that has a more liberal approach to "I know what you want, not what you're asking for". A great article on this re: Planetscale's approach is at https://vitess.io/blog/2021-11-02-why-write-new-planner/ https://vitess.io/blog/2021-11-02-why-write-new-planner/