Author | Lightnews

MotherDuck

@motherduck.com

550 followers 90 following 110 posts

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

Posts Media Videos Starter Packs

Pinned

MotherDuck @motherduck.com · May 28

S3 isn’t a database. But what if your lakehouse finally acted like one?

@jrdntgn.bsky.social shares why the current generation of lakehouse formats like Iceberg and Delta Lake might be missing the point—and how DuckLake, a new table format, changes the game.

motherduck.com/blog/ducklak...

A Duck Walks into a Lake - MotherDuck Blog

DuckDB introduces a new table format, what does it mean for the future of data lakes ? | Reading time: 9 min read

motherduck.com

1 2 32

MotherDuck @motherduck.com · Oct 2

youtu.be/XqZsoesa55w

Baby Shark Dance | #babyshark Most Viewed Video | Animal Songs | PINKFONG Songs for Children

YouTube video by Baby Shark - Pinkfong Kids’ Songs & Stories

youtu.be

Reposted by MotherDuck

Andy Pavlo @andypavlo.bsky.social · Sep 17

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

Future Data Systems Seminar Schedule (Fall 2025)

1 4 16

MotherDuck @motherduck.com · Sep 14

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

MotherDuck @motherduck.com · Sep 14

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...

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...

github.com

2 1

Reposted by MotherDuck

Mid terms are November 3rd 2026. Go register voters. @usrbinr.bsky.social · Sep 12

Just use @motherduck.com instead

nixCraft @cyberciti.biz · Sep 12

here are the costs associated with the Oracle database, in case anyone doesn't know. the costs can go up further depending on other options 😅 this is why you need to stick with opensource databases such as pgsql 🥰 the amount of freedom FLOSS brings to individuals & small businesses is unmeasurable

A screenshot of Oracle licensing costs. The text lists different editions and their prices, including Enterprise Edition, Standard Edition 2, Named User Plus, Support costs, and Enterprise add ons

3 7

MotherDuck @motherduck.com · Sep 7

delighted to support you and CMU!

Reposted by MotherDuck

jd @jd.codes · Sep 5

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

3 3 13

MotherDuck @motherduck.com · Aug 19

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...

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

motherduck.com

MotherDuck @motherduck.com · Aug 7

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-...

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

motherduck.com

MotherDuck @motherduck.com · Jul 21

motherduck.com/blog/summer-...

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

MotherDuck @motherduck.com · Jul 21

🚀 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

1 4

MotherDuck @motherduck.com · Jul 18

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

Why Your Postgres Analytics Are So Slow (And 3 Ways to Fix It)

YouTube video by MotherDuck

youtu.be

MotherDuck @motherduck.com · Jul 17

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

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.

smalldatasf.com

1 4

MotherDuck @motherduck.com · Jul 16

🦆 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...

1 5

MotherDuck @motherduck.com · Jul 15

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/

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

motherduck.com

1 4

MotherDuck @motherduck.com · Jul 8

🦆 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-...

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

motherduck.com

MotherDuck @motherduck.com · Jul 3

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...

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...

motherduck.com

2 6

MotherDuck @motherduck.com · Jul 1

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...

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.com

3 11

MotherDuck @motherduck.com · Jun 23

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

How DuckLake Simplifies Lakehouse Architecture ft. Jordan Tigani & Hannes Mühleisen

YouTube video by MotherDuck

youtu.be

2 8

MotherDuck @motherduck.com · Jun 16

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.

MotherDuck @motherduck.com · Jun 16

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)

1 1

Reposted by MotherDuck

DuckDB @duckdb.org · Jun 13

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=...

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…

lu.ma

4 21

MotherDuck @motherduck.com · Jun 13

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-...

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

motherduck.com

1 2 4

MotherDuck @motherduck.com · Jun 10

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

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.

www.redpoint.com

MotherDuck @motherduck.com · Jun 10

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!