DuckDB community extension for prefiltered HNSW using ACORN-1

Hacker News

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; ```

Visit product View on Hacker NewsMar 25, 2026

Share card

Actual performance

90points

5comments

Made the leaderboard

Launch Intel predictions

Analyze your own launch →

Product HuntOn track for Day 1 leaderboard · Strong signals: using · Missing: mac, agents, macos

81%81% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Indie HackersFits the IH revenue-focused audience · Missing: supports, reddit linkedin, podcasting

61%61% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

Hacker NewsStrong engagement from HN community · Strong signals: ide, io · Missing: https docs, excited, just released

59%59% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive

49%49% predicted probability of success on AppSumo, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Missing: mobile apps, ios, personal

40%40% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

15%15% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

1%1% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

DuckDB HTTP API Server in a Community Extension58%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

DuckDB HTTP API Server in a Community Extension

Hacker News4

I built the DuckDB extension template with Nix and the Zig C compiler69%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

I built the DuckDB extension template with Nix and the Zig C compiler

Hacker News3

QuackHouse, Database in the browser, using WASM and DuckDB63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

QuackHouse, Database in the browser, using WASM and DuckDB

Hacker News7

Build your own metaverse community using Creatospace47%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Build your own metaverse community using Creatospace

Hacker News1

DuckDB Playground (running using WASM)64%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

DuckDB Playground (running using WASM)

Hacker News4

Kù

Kùzu: An Embeddable GDBMS like DuckDB/SQLite from UWaterloo68%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Kùzu: An Embeddable GDBMS like DuckDB/SQLite from UWaterloo

Hacker News42

Apache DataFusion Support for DuckDB's DuckLake47%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Apache DataFusion Support for DuckDB's DuckLake

Hacker News1

DuckDB BM25 Client43%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

DuckDB BM25 Client

Hacker News3

VAERS DuckDB Database64%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

VAERS DuckDB Database

Hacker News3

Open-source, browser-local data exploration using DuckDB-WASM and PRQL79%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Open-source, browser-local data exploration using DuckDB-WASM and PRQL

Hacker News227

Browse all products Analyze your launch