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