Get Free Shipping on orders over $49
DuckDB Analytics : Local OLAP, Extensions, and Embedded Data Apps - Trex Team

DuckDB Analytics

Local OLAP, Extensions, and Embedded Data Apps

By: Trex Team

Paperback | 24 June 2026

At a Glance

Paperback


$83.75

or 4 interest-free payments of $20.94 with

 or 

Ships in 10 to 15 business days

"DuckDB Analytics: Local OLAP, Extensions, and Embedded Data Apps"

DuckDB has changed what "analytics" can look like when the database lives inside your process, ships with your application, and queries files as naturally as tables. This book is written for experienced data engineers, analytics engineers, and software developers who want a rigorous mental model of DuckDB as a local OLAP engine-one that favors fast iteration, disciplined performance, and pragmatic architecture over warehouse ceremony.

You'll learn to design analytical SQL that stays correct and fast under scale, interpret execution plans, and place materialization boundaries intentionally using CTAS, COPY, and layered persistence. The book goes deep on file-centric analytics: Parquet layout and partitioning, schema evolution, and remote object storage via `httpfs`, including latency budgets and pushdown strategies. It also treats extensions as a first-class capability system, covering how to evaluate, pin, and operate extensions safely-especially for Iceberg and Delta lakehouse workflows with real-world limitations.

Along the way, you'll build embedded data application instincts: API and connection lifecycle patterns across language bindings, Arrow/DataFrame zero-copy interoperability, packaging datasets for distribution, and enforcing safety boundaries for user-driven querying. Familiarity with SQL, data formats, and production-grade engineering practices is assumed; the payoff is an end-to-end playbook for making DuckDB a reliable analytics component in both local workflows and shipped products.

More in Databases

Statistics and Data Handling for Biologists : A Student's Guide - Neil Millar
To Think Like a Statistician - Bradley Efron
Data Empire : How information shaped human history - Roopika Risam
Microsoft Power BI For Dummies : For Dummies (Computer/Tech) - Jack A. Hyman
Python All-in-One For Dummies : 3rd Edition - John C. Shovic

RRP $74.95

$55.75

26%
OFF
Building a Scalable Data Warehouse with Data Vault 2.0 - Daniel Linstedt
Coding All-in-One For Dummies : 2nd Edition - Chris Minnick

RRP $69.95

$52.75

25%
OFF
Microsoft Power BI For Dummies : For Dummies (Computer/Tech) - Jack A. Hyman
Data-driven BIM for Energy Efficient Building Design : 1st Edition - Saeed Banihashemi
Microsoft 365 Access For Dummies : Access for Dummies - Laurie A. Ulrich