6 ms·

I am bullish Pgvector because I am “postgres for everything guy”. Current concerns are the scaling and recall performance. The author is looking at product qu

I am bullish Pgvector because I am “postgres for everything guy”. Current concerns are the scaling and recall performance. The author is looking at product quantization along with other ideas: https://github.com/pgvector/pgvector/issues/27 https://github.com/pgvector/pgvector/issues/27 More details on product quantization: https://mccormickml.com/2017/10/13/product-quantizer-tutorial-part-1/ https://mccormickml.com/2017/10/13/product-quantizer-tutoria... A nice repo that tracks the ANN relative performance of different indexes: https://mccormickml.com/2017/10/13/product-quantizer-tutorial-part-1/ https://mccormickml.com/2017/10/13/product-quantizer-tutoria... Also shoutout to Weaviate because they have great docs, are open source and have very informative YouTube channel. https://weaviate.io/ https://weaviate.io/

mritchie712 3y ago
Yep, we're (https://www.definite.app/ https://www.definite.app/) using pgvector and I was initially concerned about scaling, but it doesn't seem it will be a problem for our use case. I definitely wouldn't use it if I was building a feature for Slack, but works for us!
- overview 3y ago
  At a glance, your product seems like a fit for my team. However, your landing page doesn’t give specifics. What exactly does it do?
  - mritchie712 3y ago
    Yes, working on that landing page right now (currently it's pretty week)! We're building an AI data analyst. You can ask questions of your database and get answers immediately. We also auto generate entire dashboards based on common patterns (e.g. a "Sales Dashboard", "Marketing Dashboard", "Finance / Burn" etc.). If you want to give it a try (there's a demo database embedded in the app), you can use it here: https://ui.definite.app/ https://ui.definite.app/
KyeRussell 3y ago
Amen. After suffering through many years of people telling me to use document databases when I was much better served with—at most—Postgres with a jsonb field, I feel vindicated enough to feel justified in doing my due diligence before going off the beaten track. Not that document databases don’t have their place, but…MongoDB is webscale and all that.
- akiselev 3y ago
  Obligatory Youtube video for historical purposes: https://www.youtube.com/watch?v=b2F-DItXtZs https://www.youtube.com/watch?v=b2F-DItXtZs
videlov 3y ago
Over the past couple of days I tried 11 different vector databases, in order to evaluate and decide which one we'd choose for our use case. I ended up choosing Weaviate specifically because of the nice docs, but beyond that, time will tell.
- mmaia 3y ago
  I would love to read more about your experience. We need more content with feature, peformance, and architecture comparisons. Currently, there's a lot of developer evangelism hype in the space.
- bobvanluijt 3y ago
  Thanks, that's nice feedback
- technics256 3y ago
  Curious if you tried Vespa?
- dunefox 3y ago
  Any thoughts on Milvus?
- canadiantim 3y ago
  Have you tried cozodb? Newest kid on the block, looks very promising
supriyo-biswas 3y ago
Can you search both by an equality comparison and a vector search in weaviate? I’d like to do something along the lines of `SELECT * FROM table t WHERE cosine_dist(:my_embedding, t.doc_embedding) < :x AND some_column = “XYZ”`
- imaurer 3y ago
  Well Weaviate is graphql and it has filtering and hybrid search which is a great feature that pg can’t fully support because it doesn’t have bm25 https://weaviate.io/developers/weaviate/api/graphql/filters https://weaviate.io/developers/weaviate/api/graphql/filters https://weaviate.io/blog/hybrid-search-explained https://weaviate.io/blog/hybrid-search-explained I have a ChatGPT session where I have asked it to do a hybrid search using filtering, pg fts and vector search. Looks reasonable just need to test it and write it up somewhere.

mritchie712 3y ago

Yep, we're (https://www.definite.app/ https://www.definite.app/) using pgvector and I was initially concerned about scaling, but it doesn't seem it will be a problem for our use case. I definitely wouldn't use it if I was building a feature for Slack, but works for us!

overview 3y ago
At a glance, your product seems like a fit for my team. However, your landing page doesn’t give specifics. What exactly does it do?
- mritchie712 3y ago
  Yes, working on that landing page right now (currently it's pretty week)! We're building an AI data analyst. You can ask questions of your database and get answers immediately. We also auto generate entire dashboards based on common patterns (e.g. a "Sales Dashboard", "Marketing Dashboard", "Finance / Burn" etc.). If you want to give it a try (there's a demo database embedded in the app), you can use it here: https://ui.definite.app/ https://ui.definite.app/

KyeRussell 3y ago

Amen. After suffering through many years of people telling me to use document databases when I was much better served with—at most—Postgres with a jsonb field, I feel vindicated enough to feel justified in doing my due diligence before going off the beaten track. Not that document databases don’t have their place, but…MongoDB is webscale and all that.

akiselev 3y ago
Obligatory Youtube video for historical purposes: https://www.youtube.com/watch?v=b2F-DItXtZs https://www.youtube.com/watch?v=b2F-DItXtZs

videlov 3y ago

Over the past couple of days I tried 11 different vector databases, in order to evaluate and decide which one we'd choose for our use case. I ended up choosing Weaviate specifically because of the nice docs, but beyond that, time will tell.

mmaia 3y ago
I would love to read more about your experience. We need more content with feature, peformance, and architecture comparisons. Currently, there's a lot of developer evangelism hype in the space.
bobvanluijt 3y ago
Thanks, that's nice feedback
technics256 3y ago
Curious if you tried Vespa?
dunefox 3y ago
Any thoughts on Milvus?
canadiantim 3y ago
Have you tried cozodb? Newest kid on the block, looks very promising

supriyo-biswas 3y ago

Can you search both by an equality comparison and a vector search in weaviate? I’d like to do something along the lines of `SELECT * FROM table t WHERE cosine_dist(:my_embedding, t.doc_embedding) < :x AND some_column = “XYZ”`

imaurer 3y ago
Well Weaviate is graphql and it has filtering and hybrid search which is a great feature that pg can’t fully support because it doesn’t have bm25 https://weaviate.io/developers/weaviate/api/graphql/filters https://weaviate.io/developers/weaviate/api/graphql/filters https://weaviate.io/blog/hybrid-search-explained https://weaviate.io/blog/hybrid-search-explained I have a ChatGPT session where I have asked it to do a hybrid search using filtering, pg fts and vector search. Looks reasonable just need to test it and write it up somewhere.