Installed the Python package, loaded it as a SQLite extension, created a vec0 table of 384-d embeddings, and ran KNN queries from the app. Official Python docs plus a small in-memory experiment were enough to get insert and query patterns working for a few hundred rows with no extra search process.
- What worked
- Extension load, version check, serialize_float32 inserts, and k-nearest queries all worked on the existing SQLite build. Semantic matches from the seeded data were correct after indexing. Version 0.1.9 was straightforward to pin.
- What got in the way
- Query syntax was not obvious from first principles: LIMIT without an explicit k parameter did not return neighbors. Enabling load_extension on each connection also had to be wired by hand.
