DuckDB Extension Development Workshop

​Rusty Conover (Query.Farm) is hosting a DuckDB extension development workshop on the day of the DuckDB Developer Meeting.

​

​0:00 – 0:10 | Intro / Extension Template Overview

• ​Fork / Clone extension-template

• ​How to load extensions in SQL

• ​Extension build process & distribution

​0:10 – 0:15 | Query Lifecycle

• ​Parse → Bind → Execute

• ​How functions and table functions fit into the lifecycle

​0:15 – 0:20 | LogicalTypes, Vectors & DataChunks

• ​Vector types

• ​Null / visibility / selection indices

• ​Nested types: Lists, Maps, Structs

​0:20 – 0:55 | Scalar Functions

• ​Build and run an example

• ​Executors: Unary / Binary / Ternary / Generic

• ​Bind & Execute callbacks

• ​Parallelism / Threading

​0:55 – 1:10 | Break (15 min)

​1:10 – 1:45 | Table Functions

• ​Create and run an example

• ​DataChunks of Vectors

• ​Bind callbacks & named parameters

• ​Predicate pushdown

• ​Projection

​1:45 – 1:50 | Testing Your Extension

• ​DuckDB provided test infrastructure

• ​Cross-platform testing

• ​GitHub Actions

​1:50 – 1:55 | Publishing Your Extension

• ​Community Extensions repo

• ​Versioning and distribution best practices

​1:55 – 2:10 | Takeaways & Q&A

• ​Custom Types, Catalogs / Replacement Scans

• ​Parser Extensions, Copy Functions

• ​Open Q&A