Antony Courtney
@antony.bsky.social
SF-based SW dev working at intersection of UI, Programming Languages and Data. Founding Engineer at MotherDuck. Toddler dad.
Reposted by Antony Courtney
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
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
January 10, 2025 at 2:31 PM
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
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...
Reposted by Antony Courtney
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.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
December 18, 2024 at 10:00 PM
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.org/2024/12/18/d...
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!
If you use DuckDB from node.js, give this a try!
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...
December 18, 2024 at 8:50 PM
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!
If you use DuckDB from node.js, give this a try!
Reposted by Antony Courtney
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
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
November 22, 2024 at 1:55 PM
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
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.
Reposted by Antony Courtney
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
What other dataframe features should come to SQL?
Snippet is courtesy of @antony.bsky.social!
duckdbsnippets.com/snippets/204...
#databs
Label columns based on source table | DuckDB Snippets
Commonly, tables that are joined together have overlapping column names. This snippet will rename all columns to have a prefix based on the source table.
No more duplicate names!
This is similar to ...
duckdbsnippets.com
November 22, 2024 at 12:23 AM
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
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… 🤷♂️ 🤔 🙂
But until I was enlightened by reading about it today, it never once occurred to me that the suffix referred to this social network… 🤷♂️ 🤔 🙂
November 21, 2024 at 2:49 AM
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… 🤷♂️ 🤔 🙂
But until I was enlightened by reading about it today, it never once occurred to me that the suffix referred to this social network… 🤷♂️ 🤔 🙂
Reposted by Antony Courtney
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-...
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
November 19, 2024 at 7:16 PM
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-...
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-...
Reposted by Antony Courtney
just put on my apple glasses and oh man
June 5, 2023 at 7:23 PM
just put on my apple glasses and oh man
Reposted by Antony Courtney
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”
April 30, 2023 at 6:02 PM
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.
April 30, 2023 at 10:16 PM
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.
April 23, 2023 at 1:15 PM
First Bluesky post. Obligatory selfie from my undergrad alma mater which I’m visiting for just a day.