Theme

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

· English· HackerNews

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 URL: https://news.ycombinator.com/item?id=47512891 Points: 29 # Comments: 1

原文链接: HackerNews

1 min · 102w
Home
Browse next
Keep exploring from this story
View this source View this language on the homepage Search related topics

More in this language

Pinduoduo operator PDD’s profit slides as Chinese firm cites higher reinvestment
南华早报 · 2026-03-25
Middle powers are taking up the mantle of multilateral leadership
南华早报 · 2026-03-25
Paul Chan Tells Bloomberg Quality Listings Are Key
Bloomberg · 2026-03-25
HK’s Hui: Family Office Wealth Must Serve the Community
Bloomberg · 2026-03-25
Brookfield, La Caisse Agree a C$9 Billion Takeover of Boralex
Bloomberg · 2026-03-25

More from this source

Goodbye to Sora
English · 2026-03-24
Show HN: AI Roundtable – Let 200 models debate your question
English · 2026-03-24
Show HN: I took back Video.js after 16 years and we rewrote it to be 88% smaller
English · 2026-03-24
Show HN: ProofShot – Give AI coding agents eyes to verify the UI they build
English · 2026-03-24
FCC updates covered list to include foreign-made consumer routers
English · 2026-03-23

Recently read