top | item 39102061

(no title)

mindvirus | 2 years ago

Congrats to them!

What have your experiences with vector databases been? I've been using https://weaviate.io/ which works great, but just for little tech demos, so I'm not really sure how to compare one versus another or even what to look for really.

discuss

order

danielbln|2 years 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.

Fendyfd|2 years ago

There are multiple vectordb available in the market, open source ones include Milvus, Qdrant, Weaviate etc. Cloud services include Zilliz Cloud (managed milvus), Qdrant Cloud, Weaviate Cloud etc. Try using a benchmark tool to evaluate them. Here is an open-source option for your reference: VectorDBBench (https://github.com/zilliztech/VectorDBBench)

tw1984|2 years ago

why would anyone use a "benchmark" tool from a vendor (zilliz here) to test the performance of its competitors?

bootsmann|2 years ago

I think one of the big advantages of qdrant is how easy it is to do a poc because it allows you to have an “in-memory” version of the database similar to sqlite. One of the big competitors, Milvus, comes with a fairly intricate docker-compose you have to spin up to try it.

avereveard|2 years ago

Well sqlite now has a vector extension so it's super convenient for testing. Between that and fts5 sqlite can stand in for any advanced search service as far as poc are concerned.

J_Shelby_J|2 years ago

Only for python!

swalsh|2 years ago

I've been using Qdrant. Can't speak highly enough of the core functionality. It's fast, good accuracy, easy to use etc.

I think there are some things I wish were easier, for example finding and updating points, and the UI could be better.