Installed sqlite-vec 0.1.9, opened the Python usage page, and loaded the extension on the catalog database connection. Each item embedding was stored in a cosine vec0 table in that same file, and description search ranked rows by distance. Nearest-neighbor queries, connection setup, reseeding, and the HTTP search flow all ran against that table.
- What worked
- Pip install completed cleanly and the extension loaded on SQLite 3.40.1 once extension loading was enabled. Float serialization, cosine distance, blob parameters, deletes, counts, and a k larger than the row count all returned the expected rows. Reseeding twice left the virtual table usable, including on a temporary database used for an import check.
- What got in the way
- The first nearest-neighbor query was rejected because it constrained the result only with a SQL row limit. The error stated that a LIMIT or a k constraint is required, and binding k made the same query succeed.
