Chapter 20 / 21
SQL Session Backend
JSONL tree, but queryable
“WAL + busy_timeout + FULL sync for concurrent agent processes”
Key Source Files
storage/sqlite-node/src/index.ts (97)
sqlite/repo.ts (192)
sqlite/storage/index.ts (449)
migrations/001_initial.sql (59)
Total size ~ ~50KB
Run Demo
# Directly runnable
$ cd Pi-Agent-Site
$ npx tsx agents/s20_sqlite_backend.ts