The Durable Queue You Already Own: Exactly-Once Effects From SQLite, Zero Infrastructure
Build a crash-proof job queue on SQLite: leases, idempotent enqueue, retry backoff, dead-letters. Tested: 4 SIGKILLed workers, 0 lost jobs, 5,673 jobs/s.
Tag · 34 articles
Build a crash-proof job queue on SQLite: leases, idempotent enqueue, retry backoff, dead-letters. Tested: 4 SIGKILLed workers, 0 lost jobs, 5,673 jobs/s.
Cron fails silently: missed runs, DST skips, exit-0 lies, restart wipeouts. A tested stdlib-only harness adds locks, deadlines, run ledger, and a dead-man's switch.
SPF, DKIM and DMARC are now mandatory for bulk senders. A tested Python auditor that reads DNS directly and finds real misconfigurations.
WireGuard + HAProxy geo egress pool on cheap VPSes, instead of $5.88/GB residential proxies. Tested configs, tested asyncio router, real per-GB math.
A tested authenticated session pool for login-wall scraping — EWMA health scoring, challenge quarantine, auto-replenishment. Python, SQLite, zero API keys.
Build a parked-domain lander with pricing, lead capture, and per-domain tracking on Cloudflare Workers' free tier. Tested code, real commission math.
A proxy pool that scores every IP by EWMA block-rate, quarantines burned IPs, and steers traffic to healthy ones. Tested Python, SQLite, zero API keys.
Webhook handlers silently drop events on every deploy. A tested SQLite inbox turns the provider's 3-day retry loop into your free queue.
A kill-window test, a SIGKILL disaster drill, and a Litestream restore: I deleted a live SQLite DB mid-write and got 298 of 300 rows back. Full runbook.
Guaranteed express services miss their commitment ~9% of the time. Build the audit script that catches every refund before the 15-day window closes.
X's Creator Revenue Sharing died Sept 7, 2026. Original Content Rewards still pays — here's the eligibility math, a working topic-to-post pipeline, and what survives the originality screen.
One Python screener checks old flights against EU261, UK261, APPR, US DOT and ANAC 400, picks the fattest payout and drafts the claim email.