Category: Engineering Notes
All the articles in the "Engineering Notes" category.
Concurrency in Local-First AI: Making SQLite Multi-Agent Safe
Updated: at 08:00 AMHow to fix SQLite database locks when multiple AI agents write to memory simultaneously, using WAL mode, threading.local, and application-layer RLocks.
Graph Traversal Without a Graph Database: BFS in Pure Python
Updated: at 07:00 AMWhy Neo4j is overkill for a personal AI agent's memory, and how to implement fast, multi-hop context retrieval using BFS in pure Python over SQLite.
Building a Deduplication Pipeline for Local Knowledge Graphs
Updated: at 06:00 AMWhy LLM extraction fails at knowledge graphs, and how a cascade of exact aliases, embeddings, and string fallback keeps local SQLite graphs clean.
Setting Up a Python Project Skeleton That Scales
Published: at 09:00 AMHow membox chose its libraries, organized its modules, and used typing.Protocol to keep the core dependency-free while staying testable and extensible.
Building a Local-First Memory Layer for AI Agents
Updated: at 08:00 AMA local-first memory layer for AI agents: SQLite WAL for durable triples plus an in-memory graph for retrieval. No server, no vector store, no graph database.