---
title: "This Month in the DuckDB Ecosystem: February 2023"
canonical: "https://motherduck.com/blog/duckdb-ecosystem-newsletter-three/"
related:
  - title: "This Month in the DuckDB Ecosystem: November 2023"
    url: "https://motherduck.com/blog/duckdb-ecosystem-newsletter-november-2023/"
  - title: "Release notes | MotherDuck Docs"
    url: "https://motherduck.com/docs/about-motherduck/release-notes/"
  - title: "DuckDB 1.5 is Faster and Easier than Ever"
    url: "https://motherduck.com/blog/DuckDB-1.5-features-I-am-excited-about/"
gated_asset:
  title: "MotherDuck Postgres Integration"
  url: "https://motherduck.com/product/postgres-integration/"
---

# This Month in the DuckDB Ecosystem: February 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.

In this issue, we wanted to share the incredible talks from the DuckCon 2023, and many articles that were out in the second half of January and the first days of February. As each month goes by, a lot more great content is being published in the DuckDB ecosystem, so we've had to make some difficult choices for the featured community member and top links.

We hope you enjoy!

-Marcos

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

Tweet great links to us with #DuckDBMonthly

<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://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/Imported%20sitepage%20images/37849236ea9ab2feb2d2ee71f30a9351f15765e83a9792bcd7f8677dfbc9c460.jpg?width=320&upscale=true&name=37849236ea9ab2feb2d2ee71f30a9351f15765e83a9792bcd7f8677dfbc9c460.jpg"></img></div>
  <div class="columnText columnTextRight"><h3>Pedro Holanda</h3>
<p>Pedro is a Post-Doc based in Amsterdam and a member of the Database Architecture group at CWI and currently as working as Chief of Operations at DuckDB Labs. 

You can find him on Twitter [@holanda_pe](https://twitter.com/holanda_pe)

[Learn more about Pedro](https://pdet.github.io/)</p></div> 
</div>

## New DuckDB Release: 0.7.0

<div class="row rowreverse">
  <div class="columnText columnTextLeft"><p>The DuckDB team <a href="https://duckdb.org/2023/02/13/announcing-duckdb-070.html">recently announced DuckDB 0.7.0</a>!  This new release introduces JSON ingestion through read_json, partitioned Parquet and CSV export, attaching multiple DuckDB databases in the same instance, SQLite storage backend,  UPSERTs, LATERAL and POSITIONAL joins, improved Python APIs, better compression and more.  The DuckDB community has clearly been heads down coding!

[Download and Install 0.7.0](https://duckdb.org/docs/installation/index)</p></div>
  <div class="columnPic"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/Imported%20sitepage%20images/labrador_duck.png?width=320&upscale=true&name=labrador_duck.png" /></div>
</div>
  
## Top 10 DuckDB Links this Month

<div class="row">
  <div class="columnPic"><a href="https://www.youtube.com/playlist?list=PLIYcNkSjh-0wxBKPBuL6W1njhI31LwIRZ"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/Imported%20sitepage%20images/maxresdefault.jpg?width=320&upscale=true&name=maxresdefault.jpg" /></a></div>
  <div class="columnText columnTextRight"><h3><a href="https://www.youtube.com/playlist?list=PLIYcNkSjh-0wxBKPBuL6W1njhI31LwIRZ">DuckCon Brussels 2023: Talks by DuckDB Creators, MotherDuck, LakeFS, Hopsworks, Fluvio</a></h3>

  DuckCon this year had an exciting mix of talks from the core DuckDB team and the community. Catch them all on the playlist above.

Want to learn how to build DuckDB Extensions?  In their talk, Pedro and Sam teased the audience about the power of DuckDB Extensions and what you can achieve with them easily by cloning their example project.
  
  </div>
</div>


<div class="row rowreverse">
  <div class="columnText columnTextLeft"><h3><a href="https://www.youtube.com/watch?v=-rCZQHXSunc&list=PLIYcNkSjh-0ztvwoAp3GeW8HNSUSk_q3K&index=15">DuckDB: Bringing Analytical SQL directly to your Python shell</a></h3><p>In this talk at FOSDEM 2023, Pedro talks about how DuckDB fits perfectly inside the Python ecosystem and makes a cool demo at the end of the talk using DuckDB, Pandas, and PySpark.</p></div>
   <div class="columnPic"><a href="https://www.youtube.com/watch?v=-rCZQHXSunc&list=PLIYcNkSjh-0ztvwoAp3GeW8HNSUSk_q3K&index=15"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image10.jpg?width=320&upscale=true&name=image10.jpg" /></a></div>
</div>

<div class="row">
   <div class="columnPic"><a href="https://www.youtube.com/watch?v=rYbSu9wvQmk"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image3.jpg?width=320&upscale=true&name=image3.jpg" /></a></div>
   <div class="columnText columnTextRight"><h3><a href="https://www.youtube.com/watch?v=rYbSu9wvQmk">PyIceberg 0.2.1: Iceberg ❤️ PyArrow & DuckDB</a></h3><p>In this video, Tabular’s team demonstrated the new features of <a href="https://py.iceberg.apache.org/">PyIceberg 0.2.1</a>. If you prefer the article, here is the <a href="https://tabular.medium.com/pyiceberg-0-2-1-pyarrow-and-duckdb-79effbd1077f">complete write-up</a> on Medium.</p></div>
</div>

<div class="row rowreverse">
  <div class="columnText columnTextLeft"><h3><a href="https://motherduck.com/blog/solving-advent-code-duckdb-dbt/">Solving Advent Of Code With DuckDB And dbt</a></h3><p>A very interesting article from <a href="https://www.linkedin.com/in/grahamwetzler/">Graham Wetzler</a> about he used DuckDB and Python to solve some of the Advent of Code challenges.</p></div>
   <div class="columnPic"><a href="https://motherduck.com/blog/solving-advent-code-duckdb-dbt/"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image7.jpg?width=320&upscale=true&name=image7.jpg" /></a></div>
</div>

<div class="row">
   <div class="columnPic"><a href="https://www.vantage.sh/blog/querying-aws-cost-data-duckdb"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image4.png?width=320&upscale=true&name=image4.png" /></a></div>
   <div class="columnText columnTextRight"><h3><a href="https://www.vantage.sh/blog/querying-aws-cost-data-duckdb">Querying 1 Billion Rows of AWS Cost Data 100X Faster with DuckDB</a></h3><p>According to the Vantage’s team: from simple reads to complex writes and data ingestion they found that DuckDB was between 4X and 200X faster than Postgres for this use case.</p></div>
</div>

<div class="row rowreverse">
  <div class="columnText columnTextLeft"><h3><a href="https://www.youtube.com/watch?v=lT6JwbeuzCA">Command Line Data Visualization with DuckDB and YouPlot</a></h3><p>In this video, Mark Needham teaches us how to create data visualizations on the command line using YouPlot, DuckDB, and a bit of Pandas.</p></div>
   <div class="columnPic"><a href="https://www.youtube.com/watch?v=lT6JwbeuzCA"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image5.jpg?width=320&upscale=true&name=image5.jpg" /></a></div>
</div>

<div class="row">
   <div class="columnPic"><a href="https://pedram.substack.com/p/streaming-data-pipelines-with-striim"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image1.jpg?width=320&upscale=true&name=image1.jpg" /></a></div>
   <div class="columnText columnTextRight"><h3><a href="https://pedram.substack.com/p/streaming-data-pipelines-with-striim">Streaming Data Pipelines with Striim + DuckDB</a></h3><p>In this interesting article, Pedram Navid explains how to set up a streaming Data pipeline with the help of Striim (an enterprise-grade CDC platform) and DuckDB.</p></div>
</div>

<div class="row rowreverse">
  <div class="columnText columnTextLeft"><h3><a href="https://motherduck.com/blog/python-faker-duckdb-exploration/">Python Faker for DuckDB Fake Data Generation</a></h3><p>In this article, Ryan develops a simple way how to generate fake data with Python and upload it to DuckDB.</p></div>
   <div class="columnPic"><a href="https://motherduck.com/blog/python-faker-duckdb-exploration/"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image2.jpg?width=320&upscale=true&name=image2.jpg" /></a> </div>
</div>

<div class="row">
   <div class="columnPic"><a href="https://datastackshow.com/podcast/pragmatism-about-data-stacks-with-pedram-navid-of-west-marin-data/"><img src="https://22616816.fs1.hubspotusercontent-na1.net/hub/22616816/hubfs/image11.png?width=320&upscale=true&name=image11.png" /></a></div>
   <div class="columnText columnTextRight"><h3><a href="https://datastackshow.com/podcast/pragmatism-about-data-stacks-with-pedram-navid-of-west-marin-data/">Pragmatism About Data Stacks with Pedram Navid of West Marin Data</a></h3><p>The Data Stack Show, Eric and Kostas chat with Pedram Navid, Owner of West Marin Data and frequent contributor to substack. During the episode, Pedram discusses the modern data stack and its complexities, modern tooling, early-stage startups, and more.</p></div>
</div>

<h3><a href="https://duckdb.org/docs/sql/statements/insert#on-conflict-clause">DuckDB now supports ON CONFLICT clause on upserts</a></h3>
<p>Now available in the latest 0.7.0 release. Thanks to Alex Monahan for the <a href="https://twitter.com/__AlexMonahan__/status/1620435900235939841">tip on Twitter</a>.</p>

## Upcoming Events

[Data Council Austin](https://www.datacouncil.ai/austin) at the end of March 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)

[QCon London](https://qconlondon.com/), also at the end of March, 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)

[Modern Data Stack Conference](https://www.moderndatastackconference.com/) (MDS Con) by Fivetran at the beginning of April in San Francisco 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](https://www.moderndatastackconference.com/agenda) with Gabi Steele (CEO, Preql) and Chetan Sharma (CEO, Eppo).

## Subscribe to the Newsletter
You can [subscribe to the blog using RSS](https://motherduck.com/rss.xml), or elect to <a href="https://motherduck.com/#stay-in-touch">join our mailing list</a> for either the DuckDB Ecosystem Newsletter, MotherDuck News or both!