I'm All-In on Server-Side SQLite (2022)

Re:I'm All-In on Server-Side SQLite (2022) by Varriount on Friday September 22, 2023 @01:55PM (#37615326)

> 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.

[ Parent | on HN ]

Re:I'm All-In on Server-Side SQLite (2022) by erulabs on Friday September 22, 2023 @03:08PM (#37616318)

The 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/

[ Parent | on HN ]