SQLite in Practice (5): Who Am I? Where Am I?
From error codes and retention policies to audit logs—make your queue operable.
sqliteobservabilitydata-governancejob-queue
Z. Yuan10 min read
SQLite in Practice (4): Why Is My Query So Slow?
Use the right indexes so `ORDER BY ... LIMIT` can stop after the top 100.
sqliteindexperformanceleaderboardquery-plan
Z. Yuan6 min read
SQLite in Practice (3): Save Your Workers
Automatically reclaim stuck tasks—don’t let your queue turn into a graveyard.
sqlitejob-queuereliabilityheartbeat
Z. Yuan6 min read
SQLite in Practice (2): Atomic Claims
Making sure two workers can’t claim the same job is harder than you think.
sqlitejob-queuetransactionsconcurrency
Z. Yuan4 min read
SQLite in Practice (1): The Database Is Locked Again!
Use WAL and busy_timeout to bring lock contention in multi-worker setups down to an acceptable level.
sqlitewalbusy-timeoutconcurrencyjob-queue
Z. Yuan6 min read
A First Look at SQLite (2): The CLI, Indexes, and PRAGMA
Taming SQLite: from schema inspection to query plans.
sqlitesqlclitransactionspragmasindex
Z. Yuan5 min read