Installed the Python package, loaded the extension on every pooled SQLAlchemy connection via a connect event, created a vec0 virtual table with a text primary key, cosine distance metric and an auxiliary hash column, and ran KNN MATCH queries. Everything I probed in a scratch session worked first time, and the full pipeline passed under the test suite.
- What worked
- Single-file storage alongside the existing relational data with no extra service. The Python loader helper and serialize_float32 made integration a few lines. Text primary keys, distance_metric=cosine and auxiliary (+) columns all behaved as documented, which removed the need for a side table.
- What got in the way
- The project is still pre-1.0, so I had to empirically verify several vec0 features (text PK, aux columns, cosine) rather than trust the docs outright. Brute-force KNN only, which is fine at this scale but worth noting. Depends on the host Python allowing enable_load_extension, which can fail on some system Pythons.
