DuckCon #6
who it's for
data engineers, analytics engineers, database engineers, backend engineers, data scientists, platform engineers, security engineers
topics
DuckDB over Apache Arrow Flight; Ibis with GeoParquet; SQL/PGQ property-graph layer; document full-text search in DuckDB; DuckDB WebAssembly in browser; query orchestration from SQL files (yato); auto-generated metrics via LLMs; real-time finance data extraction; TPCH single-node benchmarks; Delta Lake (Rust) predicate pushdown; Grafana DuckDB integration security risks; dynamic data masking pipelines with DuckDB
| title | author | length |
|---|---|---|
| Welcome and opening remarks | Hannes Mühleisen, Mark Raasveldt | 15m |
Conference opens with the first live stream of DuckCon, announces Slido QR for audience questions, and lists concrete product metrics: 32 million extension… | ||
| Airport for DuckDB: Letting DuckDB take Apache Arrow Flights | Rusty Conover | 16m |
Extension exposes DuckDB to Apache Arrow Flight servers over gRPC, enabling selects, inserts, updates, deletes, catalog-registered tables, table-in/out… | ||
| Ibis, DuckDB, and GeoParquet: Making geospatial analytics fast, simple, and Pythonic | Naty Clementi | 21m |
Connected an Ibis session to DuckDB, reading Amsterdam OpenStreetMap GeoParquet from S3, filtering 50+ geospatial formats into a geometry column. Create a… | ||
| Unlocking graph analytics in DuckDB with SQL/PGQ | Daniel ten Wolde | 06m |
Creates a SQL/PGQ property-graph layer on top of per-label tables and translates graph patterns into relational plans so DuckDB executes them natively. Claims… | ||
| Stock data analysis with | Ryan Hamilton | 19m |
A Java SQL client called Q Studio loads a 6GB NYSE CSV and runs analysis locally by embedding DuckDB, ingesting about 68 million rows and returning pivots and… | ||
| zoekeend: A seach engine for information retrieval experiments based on | Djoerd Hiemstra | 07m |
Toolchain: DuckDB with the drb full text extension, small Python experiment scripts and CF import. Claim: storing indexes in DuckDB lets experiments run with… | ||
| Introducing a SQL-based metrics layer powered by | Mike Driscoll | 18m |
Loads a GitHub commits parquet file into a DuckDB-powered local dev environment, auto-generates a metrics model of about ten measures (total commits, merge… | ||
| powering real time finance data extraction | Adam Cooke | 05m |
CloudSLP is a syncing query engine built on DuckDB that pulls transactional data from many bank accounts (average person 2–4 accounts, businesses ~5) into a… | ||
| yato — orchestrate your queries with no pain | Christophe Blefari | 06m |
Small Python package that runs a folder of SQL files and materializes tables in a local DuckDB in dependency order by matching SQL globs, producing a working… | ||
| How NOT to use DuckDB: How we introduced a CVSS 9.9 vulnerability into | Sam Jewell | 07m |
Grafana integrates DuckDB via the CLI and ships it behind a feature flag, which enables dot commands (shell/system) and file readers like read_blob inside SQL… | ||
| Dump the Ducktape: Unblocking data pipelines at scale in healthcare using | Tony Zeljkovic | 05m |
Describes a production data-protection pipeline that implements dynamic data masking across 10,000 tables and 100,000 columns, wiring DBT artifacts and… | ||
| nothing matches | ||