LOG Writing - sheet 2 of 2
Notes from production.
MAY 10, 2026AI ENGINEERING · 10 MINAPR 16, 2026AI ENGINEERING · 9 MINAPR 05, 2026AI INTEGRATION · 12 MIN
How /search and /ask Work: Local Hybrid RAG with ChromaDB + SQLite FTS5
Semantic search misses exact IDs; keyword search misses concepts. Merging ChromaDB and SQLite FTS5 with weighted scoring across an 18,000-email mailbox.
The 3-Tier Memory System That Cut My AI Coding Context by 96%
Agents fail at onboarding, not code generation. A map first, a subsystem second, raw source last - and the context cost of a large codebase drops sharply.
From Inbox to Character: Creating a Private, Local AI Email Agent
18,000 emails, a Llama model on a consumer laptop GPU, and a Telegram bot. Search, summaries, and drafts without sending anything to a cloud provider.