Why concatenating chat transcripts doesn’t scale, and how I built a local-first, probabilistic long-term memory system on top of SQLite.

1 The comfortable lie about containersThere is a polite fiction in modern development that everyone accepts because it is convenient: we pretend Docker containers are fast and lightweight. And they are, if your reference point is provisioning bare metal in 2005. But as my tools needed to isolate workloads more frequently — and more dynamically — I started feeling the drag of depending on a giant external engine sitting between me and what I actually wanted.