russellromney/honker

24th April 2026 - Link Blog russellromney/honker (via) "Postgres NOTIFY/LISTEN semantics" for SQLite, implemented as a Rust SQLite extension and various language bindings to help make use of it. The design of this looks very solid. It lets you write Python code for queues that looks like this: import honker db = honker.open("app.db") emails = db.queue("emails") emails.enqueue({"to": "alice@example.com"}) # Consume (in a worker process) async for job in emails.claim("worker-1"): send(job.payload) job.ack() And Kafka-style durable streams like this: stream = db.stream("user-events") with db.transaction() as tx: tx.execute("UPDATE users SET name=? WHERE id=?", [name, uid]) stream.publish({"user_id": uid, "change": "name"}, tx=tx) async for event in stream.subscribe(consumer="dashboard"): await push_to_browser(event) It also adds 20+ custom SQL functions including these two: SELECT notify('orders', '{"id":42}'); SELECT honker_stream_read_since('orders', 0, 1000); The extension requires WAL mode, and workers can poll the .db-wal file with a stat call every 1ms to…