DuckDB Extension Development Workshop – Part 1
summary
Hands-on build of a DuckDB extension that registers a scalar function computing Easter dates, using the official extension template and a CMake/Ninja build flow to produce a shared library or static debug binary. The function uses DuckDB’s vectorized model and a unary executor to run the year→date conversion across 2048-row chunks (standard_vector_size), and the repo includes SQLUnit tests that run against the debug build to prove correctness.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 8:54Scalar function step by step
- 16:26Vectorized execution
- 21:21Registering functions
- 27:24Executors for functions
- 30:44Extension documentation
- 35:55Testing with SQLUnit
- 38:27Summary
related talks
18mDuckDB Extensions
33mDuckDB – Overview and latest developments
28mState of the Duck
05mAnnouncing DuckDB Support for Delta Lake and a DuckDB Extension to Unity Catalog
24mDeveloping DB Extensions in Python: Examples for SQLite, DuckDB & PostgreSQL
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
15mGet Your Ducks in a Row with Databases
23mState of the Duck