DealForge autonomously sources, scores, and writes investment memos on venture deals. Stop manually hunting.
1,180+ deals tracked · 22 AI investment memos · Updated daily
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.<p>Edit: Just to clarify, this has been accepted into the community extensions repo. So you can use it like:<p>```<p>INSTALL hnsw_acorn FROM community;<p>LOAD hnsw_acorn;<p>```
This project addresses a critical technical gap in the DuckDB ecosystem by enabling high-performance prefiltered vector search, a key requirement for modern RAG applications. While the technical innovation and community acceptance are strong, it currently exists as a feature/extension rather than a standalone business, presenting significant monetization and competitive risks.