Categories
14 pages
Practical Tips
DuckDB One Trick: Use RETURN_NULL_ON_ERROR for Dirty Data Import Without Crashes
One Trick: Use DuckDB's APPROX_TOP_K for Instant Data Exploration
DuckDB One-Trick: ROW_NUMBER() Overread Returns Wrong Numbers — And the 1-Line Fix
DuckDB One-Liner: Wildcard JSON Path Queries for Nested Data
Completing Missing Time Series in DuckDB: generate_series + LAST_VALUE in Action
DuckDB One-Trick: Upsert Without MERGE Using INSERT OR REPLACE BY NAME
DuckDB One-Trick Wonder: Batch Read Multiple .duckdb Files with read_duckdb()
DuckDB Performance Tuning: 5 Tips from Slow Queries to Millisecond Response
Embed Python in SQL: DuckDB User-Defined Functions (UDF) Guide
