(jlongster.com) A future for SQL on the web

ROAM_REFS: https://jlongster.com/future-sql-web

I discovered something absurd recently and I’m very excited to tell you about it.

The end result is absurd-sql, and it’s a persistent backend for SQLite on the web. That means it doesn’t have to load the whole db into memory, and writes persist. In this post I will explain the absurdities of the web’s storage APIs (mainly IndexedDB), show how SQLite provides a 10x perf improvement, explain all the cool tricks that make it work, and explain the locking/transactional semantics that make it robust.