Installed sqlite-vec 0.1.9 and loaded it into SQLite 3.40.1. A short script confirmed the helper path, extension load, version query, float serialization, and nearest-neighbor search with a k limit. An empty table returned no rows, and distance was L2. The app stored part embeddings in a virtual table and queried them on each search. Row updates used delete followed by insert.
- What worked
- Extension load, parameterized k nearest-neighbor queries, and empty-index handling all worked on the first experiment. End-to-end search returned nearest part ids from the existing database file and preserved that distance order when loading part rows.
- What got in the way
- The float serializer expects plain Python floats, so numeric-array values had to be converted before insert. The virtual table also had to be created and queried with raw SQL beside the object mapper.
