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