I recently discovered something absurd, and I’m excited to share it with you. It’s called absurd-sql, a persistent backend for SQLite on the web. This solves the issues with the slow and limited storage APIs like IndexedDB. With absurd-sql, you can use SQLite on the web, providing a 10x performance improvement compared to IndexedDB. It works by intercepting read and write requests from SQLite and fetching and persisting them into IndexedDB. This allows for efficient operations without loading the entire database into memory. The only downside is the need to download a 1MB WebAssembly file. Overall, it’s a game-changer for web developers.
https://jlongster.com/future-sql-web