---
title: "This Month in the DuckDB Ecosystem: March 2023"
canonical: "https://motherduck.com/blog/duckdb-ecosystem-newsletter-four/"
related:
  - title: "DuckDB Ecosystem Newsletter – March 2026"
    url: "https://motherduck.com/blog/duckdb-ecosystem-newsletter-march-2026/"
  - title: "DuckDB's Agent Moment with Jordan Tigani | MotherDuck | MotherDuck"
    url: "https://motherduck.com/videos/duckdb-agent-moment-jordan-tigani/"
  - title: "Release notes | MotherDuck Docs"
    url: "https://motherduck.com/docs/about-motherduck/release-notes/"
gated_asset:
  title: "MotherDuck Postgres Integration"
  url: "https://motherduck.com/product/postgres-integration/"
---

# This Month in the DuckDB Ecosystem: March 2023

## Hey, friend 👋

Hi, I'm [Marcos](https://marcosortiz.carrd.co/)! I'm a data engineer by day at Riot Games (via X-Team). By night, I create newsletters for a few topics I'm passionate about: helping folks [find data digs](http://interestingdatagigs.substack.com/) and [AWS graviton](https://awsgravitonweekly.com/). After getting involved in the DuckDB community, I saw a great opportunity to partner with the MotherDuck team to share all the amazing things happening in the DuckDB ecosystem. 

We hope you enjoy!

-Marcos

Feedback: [duckdbnews@motherduck.com](mailto:duckdbnews@motherduck.com)

In this issue, we wanted to share some of the excellent resources that came out in the second half of February and the first half of March. Enjoy


<style type="text/css">
.row {
  display: flex;
  flex-direction:column;   
  margin-bottom: 10px;
}

.rowreverse {
  flex-direction:column-reverse;
}

@media screen and (min-width: 600px) {
  .row {
    flex-direction: row;
  }
.columnTextLeft h3 {
  margin-left: 0px !important;
  margin-right: 20px !important;
}

.columnTextRight h3 {
  margin-left: 20px !important;
}

.columnTextLeft p {
  margin-left: 0px !important;
  margin-right: 20px !important;
}

.columnTextRight p {
  margin-left: 20px !important;
}  
}

.columnPic {
  flex: 30%;
}


.columnText {
  flex: 70%;
}

.columnText h3 {
  margin-top: 0px !important;
}


</style>

## Featured Community Member

<div class="row">
  <div class="columnPic"><img src="https://motherduck-com-web-prod.s3.amazonaws.com/assets/img/thumbnail_elliana_may_d61d1ae9ef.jpg?updated_at=2023-03-23T18:11:51.856Z"></img></div>
  <div class="columnText columnTextRight"><h3>Elliana May</h3>
<p>Elliana is a Sr Software Engineer at Bankwest in Australia, a contributor to DuckDB and a part-time contractor for DuckDB Labs. She's done a lot of work to improve DevEx and exception handling within DuckDB. 

She's also building a [SQLAlchemy driver](https://github.com/Mause/duckdb_engine) for DuckDB, allowing you to use their ORM in Python.                      
                                                                      
You can find her on Twitter [@Mause_me](https://twitter.com/Mause_me) and on [GitHub](https://github.com/Mause).

[Learn more about Elliana](https://mause.me/)</p></div> 
</div>

## Top 10 DuckDB Links this Month

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://motherduck.com/blog/why-everybody-hates-databases/">1. The Surprising Birth Of DuckDB ft. Co-creator Hannes Mühleisen</a></h3><p>

In this first Quack Chat episode, [Mehdi](https://www.linkedin.com/in/mehd-io/) has interviewed [Hannes](https://www.linkedin.com/in/hfmuehleisen/), CEO of DuckDB  Labs and co-creator of DuckDB in Brussels during DuckCon.</p></div>
</div>

<iframe width="640" height="385" src="https://www.youtube.com/embed/kpOvgY_ykTE" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen style="margin-bottom: 15px">
</iframe>

<div class="row rowreverse">
  <div class="columnText columnTextLeft"><h3><a href="https://duckdb.org/2023/02/24/jupysql.html">2. JupySQL Plotting with DuckDB</a></h3><p>This blog post demonstrated a powerful approach for plotting large datasets powered using JupySQL and DuckDB. If you need to visualize large datasets, DuckDB offers unmatched simplicity and flexibility!</p></div>
</div>

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://duckdb.org/2023/03/03/json.html">3. Shredding Deeply Nested JSON, One Vector at a Time</a></h3><p>The fantastic team at Duck Labs just recently improved DuckDB’s JSON extension so JSON files can be directly queried as if they were tables.</p></div>
</div>

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://medium.com/@nabil.servais/serverless-spatial-analysis-with-duckdb-and-aws-lambda-part-1-making-it-work-e2664295624b">4. Serverless Spatial Analysis with DuckDB and AWS Lambda — Part 1 “Making it work”</a></h3><p>Nabil Servais shared a very simple and straightforward way to make spatial analysis with AWS Lambda and DuckDB.

If you're interested in DuckDB geospatial analysis, you'll also want to check out an  [excellent](https://tech.marksblogg.com/duckdb-geospatial-gis.html) article by [Mark Litwintschik](https://twitter.com/marklit82).</p></div>
</div>

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://carlineng.com/?postid=malloy-tpcds#blog">5. Exploring the TPC-DS Benchmark Queries with Malloy</a></h3><p>Carlin Eng just published a terrific blog post where he gave an overview of the TPC-DS dataset, with the queries translated to DuckDB.</p></div>
</div>
<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://dev.to/adriens/from-api-to-scheduled-offline-copies-with-kaggle-duckdb-an">
6. From API to scheduled offline copies with DuckDB on Kaggle</a></h3><p>Adrien Sales maintains a list of software end-of-life dates and wants to keep a local copy of the data used to publish the website. Kaggle provides a great notebook interface, so Adrien built a solution on top it and shared more in this article!</p></div>
</div>

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://medium.com/clarityai-engineering/unit-testing-sql-queries-with-duckdb-23743fd22435">7. Unit testing SQL queries with DuckDB</a></h3><p>Coste Virgile showed a very interesting approach to unit testing using SQL.</p></div>
</div>

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://medium.com/@octavianzarzu/build-and-deploy-apps-with-duckdb-and-streamlit-in-under-one-hour-852cd31cccce">8. Build and deploy apps with DuckDB and Streamlit in under one hour</a></h3><p>Octavian Zarzu showed us how to build a streaming application with the help of DuckDB and Streamlit.</p></div>
</div>

<img src="https://motherduck-com-web-prod.s3.amazonaws.com/assets/img/streamlit_e59c3b3e77.jpg" />
<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://pdet-blog.github.io/2023/02/25/yahoofinance.html">9. Scrooge: Analyzing Yahoo Financial Data In DuckDB</a></h3><p>
   
  DuckDB contributor Pedro Holanda (past [featured community member](https://motherduck.com/blog/duckdb-ecosystem-newsletter-three/) and [speaker](https://www.youtube.com/watch?v=2i2nyodhGkk)) explains here how to use Scrooge, is a third-party DuckDB extension focusing on financial data analysis</p></div>
</div>

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://airbyte.com/blog/pandas-2-0-ecosystem-arrow-polars-duckdb">10. Pandas 2.0 and its Ecosystem (Arrow, Polars, DuckDB)</a></h3><p>
  
  In this article, [Simon Späti](https://twitter.com/sspaeti/) takes a closer look to Pandas 2.0 and how is its integration with the whole Python ecosystem, especially Arrow, Polars, and DuckDB.</p></div>
</div>

<div class="row">
   <div class="columnText columnTextLeft"><h3><a href="https://tobilg.com/using-duckdb-to-repartition-parquet-data-in-s3">11. Using DuckDB to repartition parquet data in S3</a></h3><p>Tobias Müller showed a possible serverless solution using DuckDB to repartition data that is stored in S3 as parquet files, without limitations imposed by certain AWS services.</p></div>
</div>

*[Okay, we fooled you; we have more than 10 links this week!!]*

## Upcoming Online Events
[Benn Stancil of Mode and Jordan Tigani of MotherDuck discuss state of Big Data (Online)](https://events.mode.com/webinar/post-big-data-era) (Wed, April 19, 2023, 10:00AM PDT)

Doing analysis in a post big data era? Benn and Jordan will discuss how the industry is trying to navigate making faster decisions with a higher impact using smaller datasets.

## Upcoming In-Person Events
[QCon London](https://qconlondon.com/), next week, is a software development conference featuring some of the brightest minds across software. Hannes Mühleisen, co-creator of DuckDB, will present on ["In-Process Analytical Data Management with DuckDB."](https://qconlondon.com/presentation/mar2023/process-analytical-data-management-duckdb)

[Data Council Austin](https://www.datacouncil.ai/austin)(also next week) will feature three days of technical talks on analytics, data engineering, data science and AI. Nicholas Ursa, co-founder and software engineer at MotherDuck, will speak about how ["Data Warehouses are Gilded Cages. What Comes Next?"](https://www.datacouncil.ai/talks/data-warehouses-are-gilded-cages-what-comes-next?hsLang=en)  MotherDuck CEO Jordan Tigani is also giving one of the keynotes this year on how [Big Data is Dead](https://www.datacouncil.ai/talks/big-data-is-dead), based on his blog post that took the internet by storm. While not directly on the topic of DuckDB, some of his ideas in the talk are inspired by it.

[Data Quality Camp Happy Hour Austin](https://www.linkedin.com/events/dataqualitycamphappyhour7039307673908965376/about/) will also take the night before Data Council. This event has many featured guests who are prominent in the data community, including:

* [Apoorva Pandhi](https://www.linkedin.com/in/apoorva-pandhi/) - Managing Director, Zetta Ventures
* [Chad Sanderson](https://www.linkedin.com/in/chad-sanderson/) - Chief Operator, Data Quality Camp
* [Mikiko Bazeley](https://www.linkedin.com/in/mikikobazeley/) - Head of MLOps, Featureform
* [Ben Rogajon](https://www.linkedin.com/in/benjaminrogojan/) - Founder, Seattle Data Guy
* [Matt Housley](https://www.linkedin.com/in/housleymatthew/) - Co-Founder & CTO, Ternary Data
* [Juan Sequeda](https://www.linkedin.com/in/juansequeda/) - Principal Scientist & Head of AI Lab, data.world
* [Ryan Boyd](https://www.linkedin.com/in/ryguyrg/) - Co-Founder, MotherDuck
* [Mark Freeman](https://www.linkedin.com/in/mafreeman2/) - Founder, On the Mark Data
 
[Let's Talk Data San Francisco](https://www.meetup.com/lets-talk-data-sf/events/292111441/) on 3 April will feature two talks around [Why is DuckDB all the rage in the Data Community? ](https://www.meetup.com/lets-talk-data-sf/events/292111441/)with Ryan Boyd (MotherDuck co-founder) and Vino Duraisami (Developer Advocate at lakeFS).

[Modern Data Stack Conference](https://www.moderndatastackconference.com/) 
(MDS Con) by Fivetran at the beginning of April will feature leaders in the industry such as DJ Patil, George Fraser, Tristan Handy,  Ali Ghodsi, renowned analyst Sanjeev Mohan and Data Council founder Pete Soderling. Ryan Boyd, co-founder at MotherDuck, will be on a panel with Gabi Steele (CEO, Preql) and Chetan Sharma (CEO, Eppo).

[Utah Data Engineering Meetup Salt Lake City](https://www.meetup.com/utah-data-engineering-meetup/events/292396661/) (UDEM) is organized by Joe Reis and Matt Housley of [O'Reilly fame](https://www.oreilly.com/library/view/fundamentals-of-data/9781098108298/).  At this meetup on April 19th, Ryan Boyd, co-founder at MotherDuck, will give an introduction to the open source DuckDB project, talk about how it’s used and some of the attributes which have made it take the internet by storm.

## Subscribe to the Newsletter
Find something interesting in this newsletter?

Share with your friends and let them know they can [subscribe](https://motherduck.com/#stay-in-touch).