[HN Gopher] Show HN: DuckDB community extension for prefiltered ...
       ___________________________________________________________________
        
       Show HN: DuckDB community extension for prefiltered HNSW using
       ACORN-1
        
       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;  ```
        
       Author : cigrainger
       Score  : 84 points
       Date   : 2026-03-25 03:28 UTC (19 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | esafak wrote:
       | Please upstream it.
        
       | wolfgangK wrote:
       | Nice ! My most pressing request for VSS would be efficient binary
       | vectors : is this on the table ?
        
         | cigrainger wrote:
         | I haven't given binary vectors a lot of thought, but I'm
         | exploring RaBitQ[1].
         | 
         | [1] https://arxiv.org/abs/2405.12497
        
       | swaminarayan wrote:
       | Does your method work better than standard ANN when filters are
       | very strict--and how does it affect speed vs accuracy?
        
       | jarpineh wrote:
       | As an aside, there's now Lance data format support in DuckDB
       | through their extension. It has Lance's vector search support
       | available among other things:
       | 
       | https://github.com/lance-format/lance-duckdb/tree/main?tab=r...
       | 
       | I just noticed this, and your post, and haven't yet checked
       | neither (sorry). I'm however doing some vector search
       | benchmarking soon, with DuckDB's options alongside others. So
       | your work caught my attention here.
        
       ___________________________________________________________________
       (page generated 2026-03-25 23:02 UTC)