What Is a Vector Database

Re:What Is a Vector Database by supriyo-biswas on Friday May 05, 2023 @07:12AM (#35827729)

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”`

[ Parent | on HN ]

Re:What Is a Vector Database by imaurer on Friday May 05, 2023 @08:57AM (#35828628)

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/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.

[ Parent | on HN ]