DuckDB
8 posts from the Query.Farm blog tagged DuckDB.
ADBC in the browser: use your existing drivers
Use native ADBC drivers from WebAssembly with Grainlift. Connect PostgreSQL to Haybarn or Cupola in the browser while keeping drivers and credentials on the server.
Your Cloudflare data, in DuckDB
Query Cloudflare's Durable Objects, D1, and Analytics Engine from your browser, the Haybarn/DuckDB command line, or Python through Grainlift and ADBC.
Bringing HTTP’s caching rules to DuckDB functions with VGI
A data service can tell DuckDB how long an answer is safe to reuse, so repeated queries can skip another API call. Our benchmarks show when that saves time—and when caching costs more than it saves.
Call an API From Every Row in DuckDB, Without the Loop
A table function turns an API call into rows in your database. A LATERAL join lets every row on the left call it — and VGI makes those calls in batches.
A SQL WHERE Clause for Taste
I pointed DuckDB at Hacker News and at Jev, TypeSafe's decision model, and asked it to score 500 stories against one sentence about what I like. It took 17 seconds and cost less than a penny.
DuckDB VARIANT and Arrow: What Works Today
Direct VARIANT interchange with Arrow is merged into DuckDB's 2.0 development branch. See what works, what still needs a release, and the remaining limits across C++, Python, Go, Rust, and Java.
DuckDB 2.0 Pushes Whole Queries Through ADBC—10–11× Faster on PostgreSQL
Query Farm's adbc_scanner uses DuckDB 2.0 whole-query pushdown to run supported queries entirely in PostgreSQL. In our benchmark, it was 10–11× faster.
The Foundation owns the IP. DuckLabs ships the release.
The IP is safe under the DuckDB Foundation, but the Foundation doesn't cut releases — DuckLabs does. What the AWS acquisition changes for people who build on DuckDB, and what Query Farm is doing about it.