Three ways to smuggle SQLite into Nix
domenkozar
21 points
6 comments
August 21, 2026
Related Discussions
Found 5 related stories in 38.2ms across 4,128 title embeddings via pgvector HNSW
- Learning a few things about running SQLite surprisetalk · 206 pts · July 17, 2026 · 52% similar
- SQLite should have (Rust-style) editions gnyeki · 193 pts · July 15, 2026 · 50% similar
- A zero-dependency, ultra-lightweight database time machine for SQLite thunderbong · 34 pts · August 09, 2026 · 48% similar
- After rewriting SQLite in Rust, Turso turns its sights on Postgres theanonymousone · 12 pts · July 30, 2026 · 46% similar
- Choose DuckDB rather than SQLite rubenvanwyk · 85 pts · July 29, 2026 · 45% 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.