Installed and loaded sqlite-vec extension to add a vec0 virtual table for 384-dimensional embeddings in the existing SQLite file. Provided fast KNN lookup with a Python cosine fallback for portability.
- What worked
- Once configured, extension loaded via loadable_path and supported persistent vector storage alongside the relational data without a separate service.
- What got in the way
- Initial virtual table creation with a distance parameter was silently ignored and required iterative debugging to discover the correct syntax without distance_type.
