RSSAmplifier

Blog

DB Quacks — Row by Row

Interactive SQL + DuckDB tutorials and dev notes.

dbquacks.comRSS feed ↗4 posts

Latest posts

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.