news.ycombinator.comShow HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite@eddie · apr 28Save1 saveHonker 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.More onPostgreSQL64SQLite57Litestream4Honker1#developer-tools4831#software-engineering2204#open-source1645#database24RelatedHonker | HonkerHonker is a SQLite extension that provides durable queues, pub/sub, and task scheduling within the same database file, enabling atomic transactional enqueue without a separate broker like Redis.also on Honker, #database, SQLite, #open-source, #developer-toolsSQLite in Production with Built-In Litestream Replication – OpenRunOpenRun integrates Litestream to provide automatic SQLite database backup and restore on Docker, Podman, and Kubernetes without requiring app changes.also on Litestream, SQLite, #open-source, #developer-toolsSQLite for EverythingSQLite can replace many specialized systems—search, document store, queue, cache, vector DB, etc.—by serving as a single-file, zero‑maintenance database for applications.also on Litestream, SQLite, #open-source, #developer-toolsDo you even need a database?The article argues that for many small-scale, read-heavy, or single-user applications, flat files like JSON can outperform a full DBMS, but warns that scaling or adding write concurrency will force you to rebuild a database.also on #database, SQLite, PostgreSQL, #software-engineering, #developer-toolsHow Tailscale helped find the SQLite WAL-Reset bugTailscale engineers and SQLite developers collaborated to identify and fix a rare data race bug in SQLite's WAL checkpointing that caused months of database corruption in Tailscale's control plane.also on #database, SQLite, #open-source, #software-engineering, #developer-tools