Disclaimer: This post includes affiliate links; I may receive compensation if you purchase the book from the different links provided in this post. This review is about DuckDB in Action by JoMark Needham, Michael Hunger, and Michael Simons from Manning. The book was sent to me by Michael Simons. He asked for my feedback: I changed my reading schedule, took a few months, and here it is. Facts 10 chapters
288 pages
$33.59 (eBook) Note that MotherDuck, the company behind DuckDB, offers a free PDF copy. Chapters An introduction to DuckDB
Getting started with DuckDB
Executing SQL queries
Advanced aggregation and analysis of data
Exploring data without persistence
Integrating with the Python ecosystem
DuckDB in the cloud with MotherDuck
Building data pipelines with DuckDB
Building and deploying data apps
Performance considerations for large datasets
Conclusion The book takes a step-by-step approach, starting from the basics of DuckDB and SQL. Pros and Cons After the mandatory section about introducing DuckDB and installing it, the book explains SQL. At first, I admit I thought that the book was for newbies, as it explained things as simple as JOIN. However, the chapter afterwards explained Common Table Expressions and built complex queries upon them. I like how the authors describe DuckDB in its "natural environment", i.e., how it integrates into different ecosystems, such as Python's Pandas and Apache Spark. In addition, a complete appendix section focuses on DuckDB in Java. Finally, the authors dedicate a section to MotherDuck, a DuckDB cloud provider. Conclusion My thoughts on the book are a bit divided. On one side, it tries to explain DuckDB itself and its integration in different environments. On the other hand, it teaches regular and advanced SQL, which users of an SQL database product should know IMHO. The book can't decide between a Learn SQL with DuckDB approach and a DuckDB in Action one. The role of a book editor is to help authors make hard decisions. It feels as if this one didn't want to stop the authors' enthusiasm and couldn't bring themselves to rein them in. Don't get me wrong: the book is great and can teach you a lot, but it could have been better with more focus. Originally published on A Java Geek on November 2nd, 2024 Disclaimer: This post includes affiliate links; I may receive compensation if you purchase the book from the different links provided in this post. This review is about DuckDB in Action by JoMark Needham, Michael Hunger, and Michael Simons from Manning. DuckDB in Action The book was sent to me by Michael Simons . He asked for my feedback: I changed my reading schedule, took a few months, and here it is. Michael Simons Facts 10 chapters 288 pages $33.59 (eBook) 10 chapters 288 pages $33.59 (eBook) Note that MotherDuck, the company behind DuckDB, offers a free PDF copy . free PDF copy Chapters An introduction to DuckDB Getting started with DuckDB Executing SQL queries Advanced aggregation and analysis of data Exploring data without persistence Integrating with the Python ecosystem DuckDB in the cloud with MotherDuck Building data pipelines with DuckDB Building and deploying data apps Performance considerations for large datasets Conclusion An introduction to DuckDB Getting started with DuckDB Executing SQL queries Advanced aggregation and analysis of data Exploring data without persistence Integrating with the Python ecosystem DuckDB in the cloud with MotherDuck Building data pipelines with DuckDB Building and deploying data apps Performance considerations for large datasets Conclusion The book takes a step-by-step approach, starting from the basics of DuckDB and SQL. and Pros and Cons After the mandatory section about introducing DuckDB and installing it, the book explains SQL. At first, I admit I thought that the book was for newbies, as it explained things as simple as JOIN . However, the chapter afterwards explained Common Table Expressions and built complex queries upon them. JOIN I like how the authors describe DuckDB in its "natural environment", i.e. , how it integrates into different ecosystems, such as Python's Pandas and Apache Spark. In addition, a complete appendix section focuses on DuckDB in Java. Finally, the authors dedicate a section to MotherDuck, a DuckDB cloud provider. i.e. Conclusion My thoughts on the book are a bit divided. On one side, it tries to explain DuckDB itself and its integration in different environments. On the other hand, it teaches regular and advanced SQL, which users of an SQL database product should know IMHO. The book can't decide between a Learn SQL with DuckDB approach and a DuckDB in Action one. The role of a book editor is to help authors make hard decisions. It feels as if this one didn't want to stop the authors' enthusiasm and couldn't bring themselves to rein them in. Don't get me wrong: the book is great and can teach you a lot, but it could have been better with more focus. Originally published on A Java Geek on November 2nd, 2024 Originally published on A Java Geek on November 2nd, 2024 A Java Geek

DuckDB in Action: A Review

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

Object Creation: The Issues I Faced and the Patterns That Helped Me

109 Stories To Learn About Ocean

107 Stories To Learn About Whales

10 Ideas to Create a Daily Writing Habit

118 Stories To Learn About Nature

Object Creation: The Issues I Faced and the Patterns That Helped Me

109 Stories To Learn About Ocean

107 Stories To Learn About Whales

10 Ideas to Create a Daily Writing Habit

118 Stories To Learn About Nature

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps