Three ways to smuggle SQLite into Nix
domenkozar
21 points
6 comments
August 21, 2026
Related Discussions
Found 5 related stories in 59.8ms across 6,054 title embeddings via pgvector HNSW
- A Syncthing and SQLite Gotcha ibobev · 18 pts · August 24, 2026 · 57% similar
- Learning a few things about running SQLite surprisetalk · 206 pts · July 17, 2026 · 52% similar
- Any Nix package, live in your browser haswell · 13 pts · September 06, 2026 · 52% similar
- Any Nix package, live in the browser domenkozar · 41 pts · September 06, 2026 · 51% similar
- SQLite should have (Rust-style) editions gnyeki · 193 pts · July 15, 2026 · 50% similar
Discussion Highlights (5 comments)
ghthor
The WASM extension me like. Would be great to get that into mainline.
kevincox
It seems that you could just compile the data into the WASM blob. Then use a more optimized query engine than sqlite. This should be very fast to compile (most of the WASM is just a byte buffer, the code is just a few binary searches and some result encoding). The downside is that you need to recompile to update the repo, but I don't think that should be particularly expensive.
lsb
If this much JSON could fit in a microcontroller’s memory (7.5MB in text), and it’s a performance issue, maybe it’s worth upgrading the JSON parser?
setheron
(author) If you have questions, happy to try and answer some.
Naru41
Just convert it to a binary data structure suitable for this purpose and use the old-fashioned bsearch. It's so simple that you wouldn't even need SQLite.