Book Review: DuckDB in Action
- March 05, 2025
- 2241 Unique Views
- 2 min read
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
Don’t Forget to Share This Post!
Technologist focusing on cloud-native technologies, DevOps, CI/CD pipelines, and system observability. His focus revolves around creating technical content, delivering talks, and engaging with developer communities to promote the adoption of modern software practices. With a strong background in software, he has worked extensively with the JVM, applying his expertise across various industries. In addition to his technical work, he is the author of several books and regularly shares insights through his blog and open-source contributions.
Comments (0)
No comments yet. Be the first.