|
|
|
|
|
by __newmoon__
987 days ago
|
|
Postgres with PGVector is the best database, plus vectors. All of the "Vector DBs" suffer horribly when trying to do basic things. Want to include any field that matches a field in an array of keys? Easy in SQL. Requires an entire song and dance in Pinecone or Weaviate. After implementing Chroma, Weaviate, Pinecone, Sqlite with HNSW indices and Qdrant-- I'm not impressed. Postgres is measurably faster since so much relies on pre-filtering, joins, etc. |
|