Tag: sqlite

Agent Memory Without a Vector DB

Give a local LLM agent long-term memory with Markdown files or SQLite FTS5. Working code, token math, and the point where you finally need embeddings.

SQLite Replication: Litestream and rqlite

Compare Litestream's continuous backup with rqlite's Raft replication for distributed SQLite. Learn when each fits your self-hosted setup.

SQLite for Self-Hosted Apps

Why SQLite is the secret weapon for self-hosted apps. WAL mode, concurrency limits, and when to actually leave it behind for Postgres.

Durable Objects: Stateful Serverless

Cloudflare Durable Objects solve the one thing serverless can't: coordination. Storage API, WebSocket hibernation, gotchas, and a working rate limiter build.

Postgres vs SQLite for Home Lab Apps

SQLite is brilliant until you need concurrent writes, replication, or online migrations. Here's the actual line where Postgres earns its keep.