#sqlite
Wiki 3
- Charles Leifer's Blog Python and database systems engineer at charlesleifer.com; peewee ORM, SQLite/Postgres deep-dives, Redis internals, well-aged opinions
- Prefer Strict Tables in SQLite Evan Hahn on why STRICT tables (fixed column types) beat SQLite's default flexible typing, plus the mechanics of type affinity
- SQLite in Production WAL mode can block short-lived readers, plus a pragma blueprint with two of its claims corrected
Toolbox 3
- agentsview Local-first browser, search and cost tracker for sessions across 50+ coding agents
- kata Local-first issue tracker for agent work — one SQLite daemon behind a JSON CLI and a TUI
- msgvault Offline email archive with SQLite full-text, DuckDB analytics and an MCP server over it