MotherDuck's Avatar

MotherDuck

@motherduck.com

Making analytics fun, frictionless and ducking awesome with an unorthodox data warehouse for the post big data era based on @duckdb.org in collab with DuckDB Labs

568
Followers
92
Following
114
Posts
30.10.2024
Joined
Posts Following

Latest posts by MotherDuck @motherduck.com

Post image

of course! he’s so adorable. some day you’ll have to visit the big one at a different event!

06.03.2026 20:47 👍 0 🔁 0 💬 0 📌 0

love it!!

30.01.2026 21:06 👍 1 🔁 0 💬 0 📌 0
Preview
Support for R/RLang | Feature Requests | MotherDuck Support the R language across common platforms at parity with DuckDB. R is used extensively by statsticians, scientists and data scientists for statistics,

yes in the future. unfortunately can’t say how far in the future.

please upvote at the link below. I’ve also shared your post with our team internally.

motherduck.canny.io/feature-requ...

11.12.2025 00:43 👍 3 🔁 0 💬 1 📌 0

ugh, sorry. you’ll want to pin versions. we roll out new versions as quickly as possible but there will usually be a lag (even if only a day or two) because we need to test new versions before rolling them out.

11.12.2025 00:30 👍 2 🔁 0 💬 0 📌 0
Baby Shark Dance | #babyshark Most Viewed Video | Animal Songs | PINKFONG Songs for Children
Baby Shark Dance | #babyshark Most Viewed Video | Animal Songs | PINKFONG Songs for Children YouTube video by Baby Shark - Pinkfong Kids’ Songs & Stories

youtu.be/XqZsoesa55w

02.10.2025 13:44 👍 1 🔁 0 💬 0 📌 0
Future Data Systems Seminar Schedule (Fall 2025)

Future Data Systems Seminar Schedule (Fall 2025)

Fall 2025 Seminar Schedule:
Sep 22: Apache Iceberg
Sep 29: Apache Hudi
Oct 06: @motherduck.com
Oct 13: SpiralDB Vortex
Oct 27: @singlestore.com
Nov 03: @deltalakeoss.bsky.social
Nov 10: Mooncake
Nov 17: @firebolthq.bsky.social
Nov 24: @xtdb.com
Dec 01: Apache Polaris

17.09.2025 23:14 👍 18 🔁 5 💬 1 📌 2

and thanks for your continued support of MotherDuck!! ❤️🦆

14.09.2025 18:32 👍 0 🔁 0 💬 0 📌 0
Preview
extensions now fail to install -- incorrect urls? · Issue #1517 · duckdb/duckdb-r In the past 24 hours or so we've started seeing duckdb repeatedly fail to install extensions: (e.g. https://github.com/cboettig/duckdbfs/actions/runs/17686503736, https://github.com/eco4cast/neon4c...

Looks like this is a known issue and will be resolved in the next few days by the R client maintainer.

Let us know if you’re not able to get a resolution there.

github.com/duckdb/duckd...

14.09.2025 18:31 👍 1 🔁 0 💬 2 📌 0

Just use @motherduck.com instead

12.09.2025 20:36 👍 8 🔁 3 💬 2 📌 0

delighted to support you and CMU!

07.09.2025 17:24 👍 0 🔁 0 💬 0 📌 0

I've been leading the data infrastructure efforts at my job (I used to work as a Data Engineer in big tech) and the stack we've landed on is so enjoyable to work with.

@dagster.io - Orchestration
@duckdb.org - Database
@motherduck.com - Data Warehouse/storage
DBT - Data modeling

05.09.2025 15:00 👍 13 🔁 3 💬 3 📌 0
Preview
Why Semantic Layers Matter — and How to Build One with DuckDB - MotherDuck Blog 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 | Reading time: 21 min read

Why use a semantic layer? 🤔

@ssp.sh shows how to build the simplest one with just:
⚡ YAML for metrics
⚡ Python + DuckDB + Ibis to query 20M NYC taxi records

You'll understand when it's useful and when it's overkill

motherduck.com/blog/semanti...

19.08.2025 14:21 👍 4 🔁 0 💬 0 📌 0
Preview
DuckDB Ecosystem: August 2025 - MotherDuck Blog DuckDB Monthly #32: DuckDB hits 50.7% growth—vector search, WASM, and analytics take the spotlight | Reading time: 7 min read

The August DuckDB Ecosystem Newsletter is out!

Highlights:
• DuckDB grew 50.7% YoY (1.8M HN headlines analyzed)
• Claude + DuckDB = full Spotify analytics pipeline
• AI that debugs its own SQL
• Real-time news sentiment with DuckDB

motherduck.com/blog/duckdb-...

07.08.2025 13:12 👍 6 🔁 0 💬 0 📌 1
Preview
Summer Data Engineering Roadmap - MotherDuck Blog A comprehensive 3-week structured roadmap for learning data engineering fundamentals, from SQL and Git basics to advanced topics like streaming, data quality, and DevOps.RetryClaude can make mistakes....

motherduck.com/blog/summer-...

21.07.2025 15:33 👍 1 🔁 0 💬 0 📌 0
Post image

🚀 Just published a 3-week data engineering roadmap - perfect for summer learning!
📖 Week 1: SQL, Git & Linux basics
⚙️ Week 2: Python, cloud & data modeling
🔥 Week 3: Streaming, data quality & DevOps
Perfect for beginners or skill refreshers.
Consistency > speed!
👏 Thanks @ssp.sh

21.07.2025 15:33 👍 4 🔁 0 💬 1 📌 0
Why Your Postgres Analytics Are So Slow (And 3 Ways to Fix It)
Why Your Postgres Analytics Are So Slow (And 3 Ways to Fix It) YouTube video by MotherDuck

All roads lead to Rome, but there are 3 ways to get your Postgres analytics queries from painfully slow to lightning fast ⚡

Watch the latest video of @mehdio.com to understand 3 distinct paths to DuckDB integration, each with its own pros/cons👇

youtu.be/86V4wbFtuaY

18.07.2025 15:01 👍 3 🔁 0 💬 0 📌 0
Preview
Small Data 2025 – The San Francisco Event on Small, Local-First Data Save the date for Small Data 2025, the event where simplicity meets impact. Join industry leaders in exploring the joys of small, local-first data and the future of efficient computing.

Come join us for THE conference of the year!
🎫🦆 Early bird tix are live!
🎤 First round of speakers just dropped!
Join the builders doing more with less →
$295 until Aug 4: smalldatasf.com

17.07.2025 15:57 👍 4 🔁 1 💬 0 📌 1
Post image

🦆 NEW: Mega and Giga ducklings are here!

For when your data is too big, your queries too complex, and "fast enough" isn't fast enough.

Learn More: motherduck.com/blog/announc...

16.07.2025 16:05 👍 5 🔁 1 💬 0 📌 1
Preview
Teaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation - MotherDuck Blog Learn how to keep LLMs updated with llms.txt and Cursor's docs feature. | Reading time: 4 min read

Your AI thinks DuckDB is v0.10.2 😱
Current version? 1.3.2

Stop feeding your AI stale docs!
Quick fixes:
1️⃣ llms.txt files - copy fresh docs directly
2️⃣ Cursor's docs feature - auto-crawl documentation

📖 motherduck.com/blog/fix-outdated-llm-documentation-duckdb/

15.07.2025 19:27 👍 4 🔁 0 💬 0 📌 0
Preview
This Month in the DuckDB Ecosystem: July 2025 - MotherDuck Blog DuckDB Monthly #31: Kafka Integration, Browser-Based Analytics, and Lake Format Innovations | Reading time: 7 min read

🦆 DuckDB Ecosystem Newsletter is live!

🔥 YamlQL, Tributary Kafka extension, SQLRooms browser apps, DuckDB Wizard 🚀 DuckDB 1.3.0 with 100x perf gains, DuckLake, AWS/PostgreSQL integrations

👨‍💻 Community spotlight: Rusty Conover
motherduck.com/blog/duckdb-...

08.07.2025 15:14 👍 5 🔁 0 💬 0 📌 0
Preview
The Data Engineer Toolkit: Infrastructure, DevOps, and Beyond - MotherDuck Blog A comprehensive guide to advanced data engineering tools covering everything from SQL engines and orchestration platforms to DevOps, data quality, AI workflows, and the soft skills needed to build pro...

The toolkit explosion is real for data engineers.

One day you're optimizing SQL queries, the next debugging Kubernetes, then explaining to stakeholders why their dashboard is empty.

The secret? Infrastructure as Code + DevOps principles.

Read more by @ssp.sh : motherduck.com/blog/data-en...

03.07.2025 12:38 👍 6 🔁 2 💬 0 📌 0
Preview
MotherDuck Managed DuckLakes Now in Preview: Scale to Petabytes - MotherDuck Blog Preview support of MotherDuck includes both fully-managed DuckLake support and ability to bring your own bucket. Combined with MotherDuck's storage, you get both high-speed access to recent data and s...

MotherDuck now supports DuckLake! 🦆

New open table format for extreme scale with database-backed metadata.

Two options:
🚀 Fully managed
☁️ Bring your own bucket

Ready to dive in (the lake 🥁)?

CREATE DATABASE (TYPE ducklake);

motherduck.com/blog/announc...

01.07.2025 09:39 👍 11 🔁 3 💬 0 📌 1
How DuckLake Simplifies Lakehouse Architecture ft. Jordan Tigani & Hannes Mühleisen
How DuckLake Simplifies Lakehouse Architecture ft. Jordan Tigani & Hannes Mühleisen YouTube video by MotherDuck

If you missed the livestream with @jrdntgn.bsky.social and @hannes.muehleisen.org, now it's your time to catch up!
A technical discussion about the evolution of open table formats and lakehouse architecture.

youtu.be/-PYLFx3FRfQ

23.06.2025 13:49 👍 8 🔁 2 💬 0 📌 0

that’s if you want the compute to happen in the cloud. if you just want local compute and aren’t worried about latency, then the blob store approach and HF are both great.

16.06.2025 20:10 👍 1 🔁 0 💬 0 📌 0

of course you should do a normal motherduck share allowing folks to create their own motherduck account and access with their own compute (free or paid).

you could do a read-only motherduck token but you’d get as much compute offered by a single account (if paid that can scale to many instances)

16.06.2025 20:09 👍 1 🔁 0 💬 1 📌 0
Preview
DuckLake & The Future of Open Table Formats · Luma Join MotherDuck CEO Jordan Tigani and DuckDB's Hannes Mühleisen for an in-depth discussion about DuckLake, the new lakehouse format that's rethinking how we…

Curious to know more about DuckLake? Next Tuesday, DuckDB co-creator @hannes.muehleisen.org will talk with @motherduck.com CEO @jrdntgn.bsky.social about DuckLake and the future of open table formats.

📆 June 17 (Tuesday), 8:00 PDT / 17:00 CEST
✍️ Register at lu.ma/mt9f8xh1?tk=...

13.06.2025 13:56 👍 21 🔁 4 💬 0 📌 1
Preview
Why REST and JDBC Are Killing Your Data Stack — Flight SQL to the Rescue - MotherDuck Blog Understand how Flight SQL can speed up how your serve data with DuckDB | Reading time: 8 min read

Still using REST or JDBC to serve data? 🐢 You’re slowing things down.

It’s like putting a Ferrari engine in a horse-drawn carriage. 🚗🐎

Arrow Flight SQL streams columnar data at 20+ Gb/s/core.

Serve data as fast as you compute it, by Thomas McGeehan:
motherduck.com/blog/flight-...

13.06.2025 13:12 👍 4 🔁 2 💬 1 📌 0
Preview
The InfraRed Report The Nasdaq Redpoint Cloud Infrastructure Software Index tracks the performance of a selection of companies that derive the majority of its revenue from selling cloud-native infrastructure software.

Full report and list: www.redpoint.com/infrared/rep...

10.06.2025 13:58 👍 0 🔁 0 💬 0 📌 0
Post image

We're thrilled to be part of Redpoint's 2025 InfraRed 100 list, which highlights 100 transformative companies in cloud infrastructure. Proud to be in such outstanding company - congratulations to everyone listed!

10.06.2025 13:58 👍 0 🔁 0 💬 1 📌 0
Preview
Getting Started with DuckLake: A New Table Format for Your Lakehouse - MotherDuck Blog Learn how DuckLake simplifies metadata and brings fast, database-like features to your data lakehouse — with a hands-on example using DuckDB and PostgreSQL | Reading time: 8 min read

If you still haven’t gotten your hands dirty with DuckLake, here’s your opportunity!

In this blog, @mehdio.com covers :

🔍 Recap on what table formats are
🧠 Understand why DuckLake's architecture is faster
🛠️ Create your first DuckLake table

motherduck.com/blog/getting...

09.06.2025 14:07 👍 6 🔁 0 💬 0 📌 0