asg017 / sqlite-vss

A SQLite extension for efficient vector search, based on Faiss!
MIT License
1.71k stars 62 forks source link

Configurable metric types for vector comparison (inner product, L1, L2 etc) #6

Closed asg017 closed 1 year ago

asg017 commented 1 year ago

Currently defaults to L2. Should be configurable for each index like so:

create virtual table articles using vss0(
  headline_embeddings(1024) metric_type=L1,
  description_embeddings(1024) metric_type=INNER_PRODUCT
);

https://faiss.ai/cpp_api/file/MetricType_8h.html#_CPPv4N5faiss10MetricTypeE