SQLite in Wasm... why and how?

on YouTube ↗15m

" summary

Shows how the SQLite C engine compiled to WebAssembly provides four JavaScript-facing APIs (C-like, object-oriented, message-based webworker, and promise wrappers) to run full SQL in the browser. Demonstrations load the Chinook database and run joins, window functions and group-by queries in about 5–80 ms; persistence can use localStorage/sessionStorage (~5 MB) or the Origin Private File System (up to ~60% of disk) via webworkers for nonblocking, near-native performance, and user-defined functions require compiling into Wasm.

AI-written summary · about

" chapters (10)

1. 0:00Introduction
2. 0:21What is SQLite
3. 1:47SQLite in Wasm benefits
4. 2:50SQLite in Wasm history
5. 3:33SQLite in Wasm API
6. 4:56Web Workers and persistence
7. 5:57Ideal use cases
8. 7:03Live demo
9. 9:55Browser APIs key
10. 13:46Q&A

" related talks

• 36mSQLite in Wasm: A Glimpse into the Future of Shared LibrariesCarl Sverre · WasmCon 2023
• 32mWebAssembly functions for your SQLite-compatible databasePiotr Sarna · Wasm I/O 2023
• 09mFun with SQLite and Wasi-LibcJesús González Martí · Cloud Native Wasm Day Europe 2023
• 30mHow WebAssembly is changing the Web and what it means for AngularBoyan Mihaylov · ngVikings 2018
• 29mBuild Database Driven Applications in WasmMichael Yuan · Wasm I/O 2023
• 21mHit the Ground Running with WebAssemblyRobert Aboukhalil · OpenJS World 2021
• 01h 00mBlazor, .NET 6, and WebAssemblySteve Sanderson · NDC Oslo 2021
• 50mWebAssembly and the Future of the JVM EcosystemAndrea Peruffo · JNation 2026