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...

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...

duckdb.org

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...

DuckDB Node Neo Client

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

duckdb.org

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!

DuckDB@duckdb.org · 2y ago

DuckDB has a new Node.js client with more features and a more idiomatic API. Read the guest blog post by Jeff Raymakers (MotherDuck) for more details: duckdb.org/2024/12/18/d...

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.

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....

duckdb.org

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… 🤷‍♂️ 🤔 🙂

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-...

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

motherduck.com

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.