A quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
summary
DuckDB is a fast in‑process analytical SQL engine that reads nested CSV/Parquet from S3 or local disk, does projection pushdown and zone‑map skipping, and spills to SSD so big queries complete on a laptop. It exposes Python/R bindings, zero‑copy Arrow/pandas interchange, and extensions including PostGIS‑level geospatial and H3. Examples include querying a public restaurants API and building a small geospatial café lookup app that runs interactively and returns results instantly.
AI-written summary · about
chapters (6)
- 0:00Introduction to DuckDB
- 5:59Data engineering features
- 7:24Advanced querying and performance
- 11:21Practical application examples
- 12:08DuckDB for data science
- 24:18Conclusion
related talks
28mAnalyze data easily with duckdb - and the implications on data architectures
40mDuckDB: Harnessing in-process analytics for data science and beyond
01h 02mAnalytics for not-so-big data with DuckDB
30mDuckDB: Bringing analytical SQL directly to your Python shell
34mData Wrangling with DuckDB
27mIn Process Analytical Data Management with DuckDB
21mWhat can Postgres learn from DuckDB?
40mDuckDB beyond the notebook