SQL for Google Sheets with DuckDB

DuckDB is winning largely because of developer experience. This tiny article from Daniel Palma shares how to access a Google Sheet from DuckDB in one line of code.

Monte Carlo simulations talk

Monte Carlo simulations do repeated random sampling to determine the probability of a complex result. James McNeil recently gave a talk to the Dublin DuckDB Meetup on doing these simulations with DuckDB.

Multi-Database support in DuckDB

Want to join DuckDB tables with tables in Postgres, SQLite, and MySQL? You can! And you can even copy data between databases easily in single SQL statements. Learn more from Mark Raasveldt on the DuckDB blog.

ERPL DuckDB Extension for SAP data

DuckDB has definitely reached the enterprise!  Simon Müller has released a DuckDB extension for using SAP Data in your workloads.

Excel support for Parquet files (via DuckDB)

From the same author as the SAP extension, we have a post on how to use Parquet data in the world’s most ubiquitous “database” using DuckDB.

Streamlit, IBIS, DuckDB and more

Want to power a dashboard deployed as an app on Streamlit? Cody Peterson of Voltron Data shows us how in this great step-by-step tutorial.

Dplyr and DucKDB

Dplyr provides a grammar for data transformation that’s higher level than SQL and consistent across data sources.  Data Scientist Bilikisu Olatunji dives into how to use Dplyr with DuckDB in R.

Quack & Code on WASM DuckDB

One of the most exciting reasons to use DuckDB is that it runs anywhere, including inside the modern web browser using web assembly (WASM). Previous featured community member Christophe Blefari quacks and codes WASM with MotherDuck’s Mehdi Ouazza in this episode.

Small Data, Big Impact talk on MLOps Community

Do you like to drink stale coffee? Demetrios Brinkmann brings on Hannes Mühleisen and Jordan Tigani to talk about this question, building an empathetic developer experience, open source business models and more.

CIDR paper on Hybrid Query Processing

One of the most popular pages on the MotherDuck website focuses on the hybrid system architecture. Peter Boncz, Visiting Researcher at MotherDuck and database luminary, corralled the MotherDuck team to dive into the details in this peer-reviewed article recently presented at the CIDR conference.

DuckDB: the Rising Star in the Big Data landscape

Mihai discussed why DuckDB has been popular recently and why, you should care about it in case you haven’t already ;-)

Upcoming Events

SQL IDE Safari: Harlequin in your terminal

31 January 2024 | Online 🌐

This latest episode of Quack and Code stars Ted Conbeer who built an amazing SQL IDE that runs in your terminal.

DuckCon #4 by DuckDB Labs and Foundation

2 February 2024 | Amsterdam, Netherlands 🇳🇱

The event will begin with a talk by DuckDB's creators, Hannes Mühleisen and Mark Raasveldt, discussing DuckDB's current state and the upcoming release of version 1.0, followed by presentations from two DuckDB users. Additionally, there will be a series of lightning talks from the DuckDB community.

Chill Data Summmit

06 February 2024 | Online 🌐

Ryan Boyd of MotherDuck will give a talk on "Data infrastructure through the lens of scale, performance and usability," and will demo how Iceberg works in DuckDB for accessing data in your lakehouse.

DataTune conference

9 March 2024 | Nashville, USA 🇺🇸

David Neal will speak about “Hybrid Queries: the Future of Data Analytics”