SQLite for Everything

kept by ninaw aug 19

SQLite can replace many specialized systems—search, document store, queue, cache, vector DB, etc.—by serving as a single-file, zero‑maintenance database for applications.

Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite
Honker brings Postgres NOTIFY/LISTEN semantics to SQLite by polling the WAL file, enabling cross-process push-style event delivery with single-digit millisecond latency without a broker.
also on Litestream, SQLite, #open-source, #developer-tools
Will Turso Be The Better SQLite? (with Glauber Costa) - YouTube
Turso, a serverless SQLite-compatible database, aims to improve concurrency and distributed performance over standard SQLite while maintaining compatibility.
also on Turso, SQLite, #open-source, #developer-tools
The Design & Implementation of Sprites
Fly.io built Sprites, disposable Linux VMs that create in seconds by ditching containers, using S3-backed storage with NVMe caching, and running orchestration inside each VM.
also on Litestream, #developer-tools
lobste.rs is now running on SQLite
Lobsters successfully moved from MariaDB to SQLite, cutting CPU and memory use, halving VPS costs, and keeping the site responsive after migration.
also on SQLite, #performance, #open-source, #developer-tools
Three ways to smuggle SQLite into Nix
The author demonstrates four methods—exec, importNative, giant Nix file, and WASM—to embed SQLite queries in Nix, comparing their speed and resource usage.
also on SQLite, #performance, #developer-tools