Motivation
DuckDb appears to be sufficiently performant, especially for larger datasets: https://github.com/schuemie/OhdsiVocabVectorStore/blob/benchmark/benchmark_results.csv
It certainly surpasses the performance of sqlite-vec and could be a good contender regarding low-effort setups running locally.
Pitch
https://duckdb.org/2024/05/03/vector-similarity-search-vss
Implement it as a backend following our architectural guidelines.
Alternatives
No response
Additional context
No response
Motivation
DuckDb appears to be sufficiently performant, especially for larger datasets: https://github.com/schuemie/OhdsiVocabVectorStore/blob/benchmark/benchmark_results.csv
It certainly surpasses the performance of
sqlite-vecand could be a good contender regarding low-effort setups running locally.Pitch
https://duckdb.org/2024/05/03/vector-similarity-search-vss
Implement it as a backend following our architectural guidelines.
Alternatives
No response
Additional context
No response