Row by Row
Interactive SQL + DuckDB tutorials, dev notes, and releases.
-
Shaping the Roster: SQL's Core Clauses, the DuckDB Way
Who scored highest? Which team came out ahead? How many games did each duck play? We've got a database full of ducks — let's learn the SQL to ask.
-
Looking Through the WINDOW: OVER, Frames, and Ranking in DuckDB
How does each duck stack up against its team, its rivals, and its own past? Let's learn window functions to answer them — without collapsing a single row.
-
Welcome to Row by Row
Meet the new interactive SQL blog that turns every code block into a runnable DuckDB query.
-
Two Ducks, One Database: A Hands-On Tour of Quack
One DuckDB serves, another attaches over HTTP, and a single statement plans across both. The end of one-writer-at-a-time.