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; ```
In plain words
HNSW_ACORN is a DuckDB community extension that enables approximate nearest neighbor searches with WHERE clause prefiltering. Built as an enhancement to DuckDB's Vector Search Support extension, it implements the ACORN algorithm to combine hybrid search capabilities similar to pgvector but with efficient prefiltered approximate nearest neighbor queries. The extension is installable from DuckDB's community extensions repository and integrates modifications to the underlying usearch library.
written from the facts on this page · September 2026
More life & fun this month
the category →- TL
Life & fun · 10d ago · louisabraham.github.io
Photosynthesis fires two of your iPhone
Life & fun · 28d ago · photosynthesis.camera
SoloUno▲310Take control of hair pulling, nail biting & skin picking
Life & fun · 28d ago · solouno.io
Scroll through all 43,252,003,274,489,856,000 reachable Rubik's Cube permutations.
Life & fun · 26d ago · everycube.alen.is
Hi HN, I built Eigendrum, a web tool that solves the 2D wave equation for arbitrary shapes so you can hear what they sound like as drums. How it works: * Solves -∇²u = λu using finite element analysis (Kφ = λMφ) on a triangle mesh. * Validated to <0.1% error against closed-form solutions for circles (Bessel zeros) and rectangles. * Sound model factors in strike location, Rayleigh damping, and mallet width. * Includes Kac drums I & II to demonstrate identical sound spectra from different geometries. * No frameworks, build steps, or dependencies. Repo and tests:…
Life & fun · 27d ago · baselashraf81.github.io
Launched alongside, March 2026
the whole month →
Switch from ChatGPT to Claude with import memory feature
AI · Mar 2026 · claude.com
