PROMPT #1 · YOU
How do we eliminate reader/writer lock contention in SQLite while keeping crash safety?
RESPONSE #2 · AI ASSISTANT
Switch from legacy rollback journals to Write-Ahead Logging (WAL). Readers inspect consistent snapshots while writers append sequentially without blocking queries:
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA busy_timeout = 5000; -- Wrapped cleanly with break-inside: avoid!
All text exports as crisp, selectable, searchable vector glyphs — zero blurry raster screenshots, zero cookie modals, and zero cut-off code lines.