DuckDB 1.5 is both faster and easier to use! JSON analysis can be up to 100x faster thanks to the VARIANT type and JSON shredding. Real-world queries are faster, including both basic and complex queries. Writes to Azure are supported, and checkpoint concurrency is dramatically improved.

MotherDuck's platform is a resource for parents and caregivers, offering insights into child development, parenting techniques, and family wellness. Through articles, expert interviews, and parenting tips, MotherDuck offers insights into fostering healthy relationships, supporting children's emotional well-being, and navigating parenthood challenges. Readers can learn about positive parenting strategies, age-appropriate activities, and family bonding experiences to create a nurturing and supportive environment for their children.

MotherDuck

DuckDB 1.5 brings major performance improvements and new features. The new VARIANT type enables automatic JSON shredding for 10-100x faster semi-structured data queries. Min/max queries are 6-18x faster via statistics-based optimization, complex joins now leverage hash joins more broadly, and Top-N-by-group queries can be up to 70x faster. Common Subplan Elimination speeds up complex CTEs. New capabilities include reading entire folders of DuckDB files, writing to Azure Blob and ADLSv2 storage, non-blocking checkpointing with parallel WAL files (17% TPC-H throughput boost), and DuckLake 0.4 with macros and sorted tables.

DuckDB 1.5 is Faster and Easier than Ever

Basic Min / Max Queries are 6 - 18x Faster

Don’t Repeat Yourself, but for the Database…