Antony Courtney

Vertical Stacking as the Relational Model Intended: UNION ALL BY NAME DuckDB allows vertical stacking of datasets by column name rather than position. This allows DuckDB to read files with schemas that evolve over time and finally aligns SQL with Codd's relational model...

New blog post by @a13x.bsky.social:

Vertical Stacking as the Relational Model Intended: UNION ALL BY NAME

Alex takes us on a journey that includes a 1969 Ford Mustang, the not-too-successful SQL keyword "CORRESPONDING", and some cool DuckDB features.

Read more at duckdb.org/2025/01/10/u...

DuckDB Node Neo Client The new DuckDB Node client, “Neo”, provides a powerful and friendly way to use your favorite database

DuckDB's Node client got a huge makeover! I've gotten to watch my colleague Jeff work on it and it's been a masterclass in how to nail the ergonomics. Give it a spin ~

duckdb.org/2024/12/18/d...

D'oh! I should have tagged @jephly.bsky.social in my post!

DuckDb Node Neo is a much improved API for DuckDB for TypeScript and JavaScript. This is some excellent work by my MotherDuck colleague Jeff Raymakers, done in close collab with the fine folks at DuckDB Labs.
If you use DuckDB from node.js, give this a try!

My favorite use case for this: bsky.app/profile/a13x...

Runtime-Extensible SQL Parsers Using PEG Despite their central role in processing queries, parsers have not received any noticeable attention in the data systems space. State-of-the art systems are content with ancient old parser generators....

New blog post by @hannes.muehleisen.org and @markraasveldt.bsky.social:

Runtime-Extensible SQL Parsers Using PEG
duckdb.org/2024/11/22/r...

This post discusses how parsers in DBMSs could be re-designed using Parser Expression Grammars for extensibility and improved error reporting.

No more duplicate column names when joining! Prefix every column with the name of its source table super easily in @duckdb.org and @motherduck.com!

What other dataframe features should come to SQL?

Snippet is courtesy of @antony.bsky.social!

duckdbsnippets.com/snippets/204...

#databs

I have been happily following #databs for a few weeks.
But until I was enlightened by reading about it today, it never once occurred to me that the suffix referred to this social network… 🤷‍♂️ 🤔 🙂

How to Extract Analytics from Bluesky, the New Open Social Network - MotherDuck Blog Discover how to build data pipelines to get insights from Bluesky | Reading time: 9 min read

When there's an open social network with open data, what can you do?
Well, obviously, you can quack.
Check the latest blog from @ssp.sh to know how to get these butterflies into ducks.
motherduck.com/blog/how-to-...

It’s hard to overstate what a barren wasteland the NYC coffee situation was before about 2010. Back then there were only a handful of tiny 3rd wave shops hidden in the East Village and Williamsburg.

just put on my apple glasses and oh man

I just want a place to poast and roast without a) nazis and b) the New York Times writing an editorial about it like “aoc said nazis are bad. Is she wrong? We went on a diner date with harlan crow’s PR guy to find out”

I love being a dad with one exception: the almost infathomable frequency of sickness. Just got home from a biz trip and my wife and daughter both have flu+fever. We were all sick last month. Don’t think we’ve had 2 straight months all being healthy since starting daycare.

First Bluesky post. Obligatory selfie from my undergrad alma mater which I’m visiting for just a day.