Timeseries and ASOF Joins

Pairing up timeseries data when the timestamps don’t match exactly (in Pandas, Polars, DuckDB, Postgres & QuestDB)

DuckDB JIT Compiled UDFs with Numba

JIT compiling your vectorized UDFs with Numba. Plus pure SQL is plenty fast if you can figure out how to write it

Vectorized DuckDB UDFs with Rust and Python FFI

Implementing vectorized UDFs in Rust that you can use in DuckDB, with a little help from Arrow

Programmatically creating a DuckDB table from an Arrow schema

PyArrow lets you create an empty table. Use that instead of custom mappings to create a DuckDB schema.