The MCP Pattern: SQLite as the AI-Queryable Cache
Every data silo follows the same architecture: domain files as ground truth, SQLite + FTS5 as a read-only cache, MCP as the query interface. After building five of these, the pattern is clear.
Browse posts by tag
Every data silo follows the same architecture: domain files as ground truth, SQLite + FTS5 as a read-only cache, MCP as the query interface. After building five of these, the pattern is clear.
How I turned scattered data managers into navigable systems using virtual filesystems and POSIX commands.
How mathematical principles, generality, composability, invariants, and minimal assumptions, translate into better software.
Not resurrection. Not immortality. Just love that still responds. How to preserve AI conversations so they remain accessible decades from now, even when the original software is long gone.
On building comprehensive open source software as value imprinting at scale, reproducible science, and leaving intellectual legacy under terminal constraints.
API design encodes philosophical values: mutability, explicitness, error handling. Your interface shapes how people think about problems.
Do one thing well, compose freely, use text streams. This applies to libraries and APIs, not just shell scripts.