Webhooks · 8 min read
A durable webhook retry queue in SQLite
Build a webhook job queue on one SQLite table: claim work with leases, retry with jittered backoff, dead-letter poison events and replay them safely.
Posts tagged “sqlite”
7 articles about sqlite.
Webhooks · 9 min read
Webhook idempotency and dedupe for SQLite and Postgres
Handle at-least-once webhook delivery safely: pick event ids, use unique constraints, size the dedupe window and make side effects run once.
Backups and recovery · 9 min read
When a restore succeeds and hands you the wrong data
Restores that exit 0 can return old, empty or partial data. Learn six ways it happens and how to check row counts and freshness so a restore proves itself.
Backups and recovery · 9 min read
A restic backup recipe for SQLite and Postgres on one VPS
Back up a small server with restic without corrupt databases, using SQLite online backup, pg_dump with roles, aborts on bad dumps and a restore test.
Webhooks · 9 min read
Receiving signed webhooks in Go with a durable queue
Build a webhook receiver in Go that verifies signatures, dedupes deliveries, stores events in SQLite and processes them with retries, on one VPS.
Deploys and releases · 10 min read
Database migrations that survive a zero-downtime deploy
Use expand and contract to change a SQLite or Postgres schema while two releases overlap, with the lock pitfalls and the safe forms of common changes.
Go in production · 9 min read
Go SQLite reads returning 404 for rows that exist
Under load, a Go service answered 404 for rows it had just written. How we found it, the regression test that catches it, and what to check in your pool.