Databases
PRAGMA data_version: SQLite's Global Commit Counter as a Cross-Process Polling Primitive
`PRAGMA data_version` is a {{SQLite}} primitive that returns a monotonically increasing integer bumped on every commit and every WAL checkpoint, visible across processes sharing the same database file — making it a cheap, correct foundation for sub-millisecond change-detection polling.
Task Queues on SQLite vs Postgres: Landscape Comparison (2026)
Survey of durable task-queue libraries that live inside a database file or table — {{Honker}}, {{Huey}}, {{LiteQueue}}, {{liteq}}, {{BlockQueue}}, {{River}}, {{Oban}}, and {{pg-boss}} — comparing notify/listen support, cron, ORM compatibility, and language reach.
Keep the Queue in the Same Database as Your Business Writes
Enqueueing background jobs in the same database transaction as the business write that triggers them eliminates an entire class of "notification sent, row not committed" bugs that arise when the queue lives in a separate datastore like {{Redis}} or {{SQS}}.
Honker: SQLite Extension for NOTIFY/LISTEN, Task Queues, and Cron in One .db File
Honker is an Apache 2.0 {{SQLite}} loadable extension by Russell Romney that adds Postgres-style {{NOTIFY}}/{{LISTEN}}, durable task queues, event streams, named locks, and a leader-elected {{cron}} scheduler to any SQLite database file, with bindings for eight languages.