Show HN: DuckDB community extension for prefiltered HNSW using ACORN-1

Contribute to cigrainger/duckdb-hnsw-acorn development by creating an account on GitHub.
90 points by cigrainger 211 days ago github.com 6 comments
Summary not yet generated for this article.

Original Text

Hey folks! As someone doing hybrid search daily and wishing I could have a pgvector-like experience but with actual prefiltered approximate nearest neighbours, I decided to just take a punt on implementing ACORN on a fork of the DuckDB VSS extension. I had to make some changes to (vendored) usearch that I'm thinking of submitting upstream. But this does the business. Approximate nearest neighbours with WHERE prefiltering.

Edit: Just to clarify, this has been accepted into the community extensions repo. So you can use it like:

```

INSTALL hnsw_acorn FROM community;

LOAD hnsw_acorn;

```

Comments (6 of ) ⌛

Loading more comments... ⌛
Scroll down to load more comments
No comments available.
Type to search HN and engineering blog articles
Press Escape to close  |  ↑↓ to navigate  |  Enter to open