Practical Applications for DuckDB (with Simon Aubury & Ned Letcher)

Thanks to Kris Jenkins and his awesome YouTube channel Developer Voices, we had an insightful discussion with the book authors! They dive into how DuckDB simplifies data wrangling, enhances edge processing, and integrates smoothly with programming languages like R and Python, all through an engaging discussion.

Ibis Dropping Pandas Support - DuckDB is the Default

Ibis is a portable Python dataframe that enables you to write your pipeline and use different engines like DuckDB, Polars, DataFusion, or PySpark. They used to support Pandas but are dropping support as of version 10.0. As they mentioned: "There is no feature gap between the `pandas` backend and our default DuckDB backend, and DuckDB is _much_ more performant."

PostgreSQL in Line for DuckDB-Shaped Boost in Analytics Arena

A big release this month was the official open source Postgres extension for DuckDB where multiple companies will partner (including MotherDuck) together to provide the best analytical experience, directly in Postgres! While it's still in an experimental state, this is a big project that will get significant resources and attention, stay tuned! You can also read our blog about this release.

Modern GIS with DuckDB

Geospatial analysis always seemed like a niche in data that was hard to access. The reason for this is that the toolkit and knowledge were significantly different from what you commonly do. Thanks to DuckDB, that's not the case anymore. I tried to wrap up a getting started video about how to create your first heatmap using open EV charging spot data.

Letsql, a Multi-Engine Supporting DuckDB

Letsql is another multi-engine framework, like Ibis but much younger. The blog linked above discusses their caching feature for upstream source data. This allows you to cache the results of a SQL query in a dataframe for rapid iteration. It's great to see multiple tools adopting the strategy to avoid cloud dependency while developing and significantly improve the overall developer experience.

DuckDB Tricks

Gabor from DuckDB Labs shows us some kung fu SQL, or rather, some underrated functions through this pragmatic blog. For instance, did you know that in the CLI the `.schema` command will show all of the SQL statements used to define the schema of the database?!

Ibis + DuckDB Geospatial: A Match Made on Earth

The annual SciPy Conference is a gathering where participants from various sectors showcase projects, learn from experts, and collaborate on Scientific Python development. In this talk, Naty Clementi from Voltron Data explains how you can leverage Ibis and DuckDB for geospatial work.

How to Bootstrap a Data Warehouse with DuckDB

A couple of MotherDuckers were at SciPy for a SQL workshop and also to present! In this talk, Guen from our ecosystem team delivered a pragmatic talk to demonstrate how you can bootstrap a data warehouse with DuckDB and MotherDuck. No sales fluff, just a straightforward project for you to get started here.

Why Do People Like DuckDB

The subreddit data engineering is a popular and insightful place to learn about others' experience with data tools (if you omit the troll comment here and there ;-). This thread shows how people are currently using DuckDB. A lot of comments compared their experience with SQLite, Pandas, and others.

How DuckDB Function Chaining Works

Mark Needham shows us in this video how to make your long SQL script more readable using DuckDB function chaining with the `.` operator. It's again something I haven't seen many people using but really useful to make your code cleaner!

Upcoming Events

dbt Data Modeling Challenge

9 September - online

Paradime, Hex, and MotherDuck have joined forces to bring data professionals worldwide a one-of-a-kind competition with some sweet prizes. Showcase your dbt, analytics, and SQL prowess on a global stage for a panel of esteemed judges!

Data Engineering for AI/ML

12 September - online

Small Data SF

24 September, San Francisco, CA, USA

Small data and AI is more powerful than you think. Data and AI that was once "Big" can now be handled by a single machine. Join MotherDuck, Ollama, Turso, and Cloudfare in San Francisco.