3 ms·
We're using Postgres with the pg_vector extension for basically all of our projects. We know and love Postgres, it has a big track record, the extension is supp
by danielbln 3y ago
We're using Postgres with the pg_vector extension for basically all of our projects. We know and love Postgres, it has a big track record, the extension is supported on all major managed cloud offerings, no new tooling needed, pg_vector supports HNSW indices for performance as well.
Once in a whole supabase slips into a project, but that's basically just Postgres with some bells and whistles on top.
I got nothing bad to say about Pinecone, We aviate, Chroma etc. but when it comes to dbs, I like to go with the devil I know.
- andre-z 3y agoYou should use whatever works best for you unless you face some limitations. The issue is that vector databases are not databases but search engines. It is ACID vs BASE. A few thoughts on this https://qdrant.tech/articles/dedicated-service/ https://qdrant.tech/articles/dedicated-service/