Max Gabrielsson
[Max Gabrielsson](https://github.com/Maxxen) is a Junior Software engineer at DuckDB labs but he has already made some impressive waves! He’s the creator of the official [spatial DuckDB extension](https://github.com/duckdblabs/duckdb_spatial). While it’s still WIP, it’s much more welcome for any geo data processing. You can read more about this one [here](https://duckdb.org/2023/04/28/spatial.html). [Learn more about Max here](https://www.linkedin.com/in/max-gabrielsson-22459a156/) ## Top DuckDB Links this Month ### [DuckDB: run SQL queries on 50,000+ datasets on the Hugging Face Hub](https://huggingface.co/blog/hub-duckdb)  The Hugging Face team just announced the integration with DuckDB, which means that now you can use the simplicity of SQL on 50k+ datasets on its Hub. ### [Correlated Subqueries in SQL](https://duckdb.org/2023/05/26/correlated-subqueries-in-sql.html) This new feature from DuckDB will allow building more readable and easier-to-maintain complex queries. ### [Shredding deeply nested JSON, one vector at a time by Laurens Kuiper - DuckDB Labs](https://www.youtube.com/watch?v=7MtJZqBdYTI) In this video, Laurens shows how to work with deeply nested JSON data in DuckDB ### [What's the hype behind DuckDB?](https://blog.mattpalmer.io/p/whats-the-hype-behind-duckdb) [Matt Palmer](https://www.linkedin.com/in/matt-palmer/) shares a very interesting perspective in this post on why DuckDB is so popular these days. ### [DuckDB + Dagster](https://docs.dagster.io/integrations/duckdb) The Dagster team just released a tutorial to show how to combine DuckDB I/O Manager and Dagster’s Software-Defined Assets. If you use Dagster in production today, you will benefit a lot from this seamless integration here ### [Cross-filtering 10 Million Entries with FalconVis + DuckDB](https://observablehq.com/@cmudig/falcon-vis-10m) Researchers from the CMU Data Interaction Group just shared this notebook on Observable where they combined the power of FalconVIS and DuckDB to cross-filter 10 Million rows. ### [My (very) personal data warehouse — Fitbit activity analysis with DuckDB](https://simonaubury.com/posts/202306_duckdb_fitbit/)  In this post, [Simon Aubury](https://www.linkedin.com/in/simonaubury/) analyzed its own Fitbit activity with the help of DuckDB and Seaborn ### [clickhouse-local vs DuckDB on Two Billion Rows of Costs](https://www.vantage.sh/blog/clickhouse-local-vs-duckdb)  The Vantage team shared an insightful comparison between clickhouse-local and DuckDB. The post is worth a read because it highlights a very important point on why people are selecting DuckDB for more and more projects: developer productivity with DuckDB is just awesome ### [DuckDB: Generate dummy data with user-defined functions (UDFs)](https://www.markhneedham.com/blog/2023/06/02/duckdb-dummy-data-user-defined-functions/)  [Mark Needham](https://www.linkedin.com/in/markhneedham/) (a regular person in this newsletter) wrote about how to use the potential of UDFs on DuckDB to generate dummy data. If you are a visual person, you can watch the video Mark did explaining the same thing [here](https://www.youtube.com/watch?v=EVLDg-RNjoc). ### [Graph components with DuckDB](https://maxhalford.github.io/blog/graph-components-duckdb/) [Max Halford](https://www.linkedin.com/in/maxhalford/) show a simple way to work with graphs with Python and DuckDB ### [Music Stats with DuckDB](https://arturdryomov.dev/posts/music-stats-with-duckdb/) [Arthur Dryomov](https://www.linkedin.com/in/arturdryomov/) wrote about how to analyze music data with DuckDB ### [Using DuckDB to query beneficial ownership data in Parquet files](https://www.openownership.org/en/blog/using-duckdb-to-query-beneficial-ownership-data-in-parquet-files/) In this post, [Stephen Abbott Pugh](https://www.linkedin.com/in/stephendabbott/) explains in great detail how DuckDB could be the perfect tool to work with the [Beneficial Ownership Data Standard](https://standard.openownership.org/en/0.2.0/) (BODS) ## Upcoming events ### DuckCon in San Francisco - 29th June “DuckCon,” the DuckDB user group, will be held for the first time outside of Europe in [San Francisco Museum of Modern Art (SFMOMA)](https://www.sfmoma.org/), in the Phyllis Wattis Theater. In this edition, there will be talks from DuckDB creators [Hannes Mühleisen](https://hannes.muehleisen.org/) and [Mark Raasveldt](https://mytherin.github.io/) about the current state of DuckDB and future plans. It will also talks from data industry notables [Lloyd Tabb](https://twitter.com/lloydtabb) (of Looker and Malloy fame) and [Josh Wills](https://github.com/jwills) (creator of dbt-duckdb). The full agenda is available [here](https://duckdb.org/2023/04/28/duckcon3.html). [Grab your ticket here](https://www.eventbrite.com/e/duckcon-san-francisco-tickets-618906505017?discount=duckconpreregisteredlatebird), as there is limited space! ### MotherDuck Party in San Francisco - 29th June Following DuckCon, MotherDuck will host a party celebrating ducks at 111 Minna (located very close to SFMOMA). DuckCon attendees are cordially invited to attend to eat, drink, listen to music and play games (skeeball!). MotherDuck’s Chief Duck Herder will also demo the latest work bringing DuckDB to the cloud. [Register now](https://www.eventbrite.com/e/motherducking-party-after-duckcon-and-dataai-summit-san-francisco-tickets-586172165727) before they run out of space! ### Data + AI Summit - 28th and 29th June DuckDB co-creator Hannes will be giving a [keynote](https://register.dataaisummit.com/flow/db/dais2023/sessioncatalog23/page/sessioncatalog?search=%22Hannes%20M%C3%BChleisen%22) at this 10-track data conference hosted by Databricks. Additionally, Ryan Boyd (co-founder at MotherDuck) will be delivering a technical session: [If A Duck Quacks In The Forest And Everyone Hears, Should You Care?](https://register.dataaisummit.com/flow/db/dais2023/sessioncatalog23/page/sessioncatalog?search=Boyd)