MOTHERDUCK BLOG

DuckDB, MotherDuck, Data Engineering and Data Analytics

Search and filter

Search and filter

Topic

Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDB

2025/12/03 - Simon Späti

Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDB

Speed up slow dashboards without adding new infrastructure. Learn how DuckDB's caching extensions can drop query times from minutes to seconds.

Branch, Test, Deploy: A Git-Inspired Approach for Data

2025/11/24 - Simon Späti

Branch, Test, Deploy: A Git-Inspired Approach for Data

This article explores how to bring Git style workflows like branching, testing, and deploying to your data stack. Learn how concepts like zero copy cloning and metadata pointers can finally give you isolated test environments.

Subscribe to MotherDuck Blog

Blog subscription card section illustration
Small Data SF 2025: the Recap!

2025/11/14 - Garrett O'Brien

Small Data SF 2025: the Recap!

Dive into a recap of the world's hottest efficiency-themed data conference, Small Data SF!

DuckDB Ecosystem: November 2025

2025/11/12 - Simon Späti

DuckDB Ecosystem: November 2025

DuckDB Monthly #35: DuckDB extensions, DuckLake, DataFrame, and more!

4 Senior Data Engineers Answer 10 Top Reddit Questions

2025/10/30 - Simon Späti

4 Senior Data Engineers Answer 10 Top Reddit Questions

A great panel answering the most voted/commented data questions on Reddit

Faster Ducks

2025/10/28 - Jordan Tigani

Faster Ducks

Benchmarks, efficiency, and how MotherDuck just got nearly 20% faster.

DuckDB 1.4.1 and DuckLake 0.3 Land in MotherDuck: New SQL Syntax, Iceberg Interoperability, and Performance Gains

2025/10/09 - Alex Monahan, Garrett O'Brien

DuckDB 1.4.1 and DuckLake 0.3 Land in MotherDuck: New SQL Syntax, Iceberg Interoperability, and Performance Gains

MotherDuck now supports DuckDB 1.4.1 and DuckLake 0.3, with new SQL syntax, faster sorting, Iceberg interoperability, and more. Read on for the highlights from these major releases.

Why Python Developers Need DuckDB (And Not Just Another DataFrame Library)

2025/10/08 - Mehdi Ouazza

Why Python Developers Need DuckDB (And Not Just Another DataFrame Library)

Understand why a database is much more than just a dataframe library

DuckDB Ecosystem: October 2025

2025/10/07 - Simon Späti

DuckDB Ecosystem: October 2025

DuckDB Monthly #34: DuckDB 1.4.0 LTS, 100× Spark benchmarks, official Docker image and more!

DuckDB Ecosystem: September 2025

2025/09/09 - Simon Späti

DuckDB Ecosystem: September 2025

DuckDB Monthly #33: DuckDB 58× faster spatial joins, pg_duckdb 1.0, and 79% Snowflake cost savings

PAINLESS GEOSPATIAL ANALYTICS USING MOTHERDUCK’S NATIVE INTEGRATION WITH GALILEO.WORLD

2025/09/09 - Patrick Garcia

PAINLESS GEOSPATIAL ANALYTICS USING MOTHERDUCK’S NATIVE INTEGRATION WITH GALILEO.WORLD

Discover how Galileo.world is revolutionizing geospatial analysis. Say goodbye to slow performance and complex setups. Analyze and visualize big data right in your browser.

Announcing Pg_duckdb Version 1.0

2025/09/03 - Jelte Fennema-Nio, Jacob Matson

Announcing Pg_duckdb Version 1.0

PostgreSQL gets a DuckDB-flavored power-up for faster analytical queries without ever leaving Postgres.

DuckDB × cognee: Run SQL Analytics Right Beside Your Graph-Native RAG

2025/08/29 - Vasilije Markovic

DuckDB × cognee: Run SQL Analytics Right Beside Your Graph-Native RAG

SQL analytics and graph-native retrieval together, eliminating the trade-off between fast analytics and one-off RAG retrievals.

Nine Keyboard Shortcuts for SQL Flow State

2025/08/22 - Jacob Matson

Nine Keyboard Shortcuts for SQL Flow State

Tired of clicking? Master 9 essential SQL keyboard shortcuts to achieve a true flow state and make your data analysis faster and more joyful. Learn to run queries, comment, format, and even use AI without leaving your keyboard.

Why Semantic Layers Matter — and How to Build One with DuckDB

2025/08/19 - Simon Späti

Why Semantic Layers Matter — and How to Build One with DuckDB

Learn what a semantic layer is, why it matters, and how to build a simple one with DuckDB and Ibis using just YAML and Python

When Spark Meets DuckLake: Tooling You Know, Simplicity You Need

2025/08/11 - Mehdi Ouazza

When Spark Meets DuckLake: Tooling You Know, Simplicity You Need

Learn how to combine Apache Spark’s scale with DuckLake’s simplicity to build a lakehouse with ACID, time travel, and schema evolution