Alternative vector store to ChromaDB?

[metazool]

Been wondering about alternative vector stores - we picked Chroma because it looked very simple API-wise, sqlite-based and there were lots of examples for integrating it with LangChain in the LLM evaluation projects.

Postgres has a vector store. I saw a sqlite extension in the datasette ecology that might fit here. If we want to make more use of it (e.g. if we extend the (Luigi) pipeline to extract image embeddings and use them for classification, we might as well store them for reuse). Very receptive to suggestions as to what that might be

[metazool]

https://github.com/pgvector/pgvector - Postgres vectors with pgvector
https://til.simonwillison.net/sqlite/sqlite-vec - SQLite vectors with sqlite-vec