Antony Courtney
@antony.bsky.social
SF-based SW dev working at intersection of UI, Programming Languages and Data. Founding Engineer at MotherDuck. Toddler dad.
D'oh! I should have tagged @jephly.bsky.social in my post!
December 18, 2024 at 10:59 PM
D'oh! I should have tagged @jephly.bsky.social in my post!
My favorite use case for this: bsky.app/profile/a13x...
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
December 9, 2024 at 3:39 PM
My favorite use case for this: bsky.app/profile/a13x...
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.
November 8, 2024 at 3:12 PM
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.