Back to index
OtherArticles of ten to thirty minutes, full books over several days·Free, including two published books

MotherDuck Learn and DuckDB Resources

4.0

Giving away two commercially published technical books is a more generous act of education than most vendor academies manage with a hundred videos, and the writing is good.

What We Liked

  • Two full published books, the Manning DuckDB guide and the O'Reilly DuckLake book, free
  • The articles teach analytical engineering concepts, not just product features
  • DuckDB itself is genuinely free open source with nothing held back
  • Refreshingly honest about when you do not need a distributed warehouse

What Could Be Better

  • This is a content library, not a sequenced curriculum or certification
  • The single-node argument is made persuasively enough to be slightly one-sided
  • DuckLake is very new and the enthusiasm outpaces production evidence
  • MotherDuck the commercial product is woven through material framed as education

Detailed review

There is a spectrum in vendor education that runs from a gated PDF called an ebook that turns out to be eleven pages of marketing, all the way to genuinely useful published work given away. MotherDuck is at the good end. The Manning book on DuckDB and the O'Reilly book on DuckLake are real technical books, commissioned, edited and published by the two most credible technical publishers, and MotherDuck gives them away. If you accept that giving away a two hundred page professionally edited book costs a company more than producing forty videos of someone clicking through a product, the generosity here is not in doubt.

The DuckDB material matters because DuckDB matters. It is an in-process analytical database, SQLite's shape with a columnar analytical engine inside, and it has quietly changed what a single machine can do with data. A laptop with sixteen gigabytes of memory can run analytical queries over tens of gigabytes of Parquet in seconds, with no cluster, no cloud account and no infrastructure. For an enormous proportion of the analytics work that gets done, that is sufficient, and the industry spent a decade assuming otherwise.

MotherDuck's articles make this argument well and back it with numbers. The educational content is better than the category norm because it teaches concepts rather than features. Columnar versus row storage and why analytical queries care. Vectorised execution.

OLAP versus OLTP as a real architectural distinction rather than a pair of acronyms. Why Parquet's structure allows predicate pushdown and what that saves you. When a distributed system genuinely earns its operational cost and when it is cargo cult architecture inherited from a blog post about a company with a thousand times your data volume. Someone who reads through this comes away understanding analytical database design, and that knowledge applies to Snowflake, BigQuery and ClickHouse just as much as to DuckDB.

The commercial position is worth stating plainly. DuckDB is an independent open source project under the DuckDB Foundation, not a MotherDuck product. MotherDuck is a company built by people close to that project, selling a managed service that adds cloud storage, sharing and collaboration to DuckDB, with a hybrid execution model that can split work between your laptop and their servers. That hybrid idea is genuinely clever.

It also means that education framed around DuckDB naturally flows toward MotherDuck, and the boundary is not always signposted as clearly as it might be. The articles are not dishonest about it, but a reader should know which parts are about an open project they can use forever and which parts are about a commercial service. My two substantive reservations. First, the single-node argument is correct and slightly overplayed.

DuckDB is transformative for a great deal of work and it is not a replacement for a warehouse serving three hundred concurrent BI users against continuously updated data. The material tends to make the case for small data more enthusiastically than it makes the case against, which is understandable and still a bias to read past. Second, DuckLake is very new. It is an interesting take on open table formats, using a database to hold catalogue metadata rather than a pile of JSON manifest files, and the argument is well made.

But Iceberg and Delta have years of production deployment behind them and DuckLake does not, and an O'Reilly book gives a new format an air of establishment it has not yet earned. That is not a reason to avoid the book, which is informative about table formats generally, only a reason to read it as an argument rather than a settled account. Four point zero. Genuine generosity, genuinely good writing, and a commercial interest that is present but not concealed.

[ final ]

The verdict.

Take the free books. They are real books by real authors that you would otherwise pay for, and the DuckDB one is the best single resource on a tool that deserves to be in every analyst's kit.