EP 59: Jacob Matson from MotherDuck

What happens when a lightning-fast database meets a quirky name like MotherDuck? You get DuckDB, an embeddable powerhouse shaking up the data warehouse world. It’s fast, it’s sleek, and it’s turning traditional multi-node setups into yesterday’s news. Jacob Matson from MotherDuck spills the beans on how they’re turbocharging DuckDB for the cloud, making it a dream for anyone juggling local and cloud workflows. Think edge computing, IoT magic, and SQL that's so smart it practically writes itself. Whether you’re crunching numbers in finance or wrangling data in oil and gas, this one’s for the data nerds who like their tech cutting-edge and their tools feather-light.

Join the conversation shaping the future of energy.
Collide is the community where oil & gas professionals connect, share insights, and solve real-world problems together. No noise. No fluff. Just the discussions that move our industry forward.
Apply today at collide.io

Click here to view the episode transcript.

00:00 - Intro
02:06 - DuckDB for Google Sheets
05:24 - Jacob’s Journey to DuckDB
11:05 - OLTP vs OLAP
13:08 - DuctDB
16:59 - MDSinaBox
19:08 - NBA Jam
20:05 - MDS in a Box
22:19 - Running on the Edge
23:56 - Chick-fil-A
26:20 - DuckDB
31:10 - Querying Data Where It Lives
35:30 - ODBC vs Arrow DataFusion
42:13 - Mothertuck
42:55 - Motherduck
46:25 - What is Mother Duck
51:10 - Connecting BI Tools to Mother Duck
52:55 - PG DuckDB
54:33 - Using DuctDB with Postgres
56:21 - DuctDB as Cache for Snowflake
58:25 - ROI of Data Teams
1:01:30 - Future of ELT
1:05:20 - Embeddings in Data
1:06:20 - Language Models in Analytics
1:07:40 - Prompt SQL Techniques
1:15:10 - DuckDB Pushing SQL Forward
1:18:22 - Speed Round
1:19:34 - Favorite Non-DuckDB Database
1:20:28 - Favorite Video or Board Game
1:21:07 - Best Places to Eat in Seattle
1:21:37 - Tyson vs Jake Paul 2

https://twitter.com/collide_io

https://www.tiktok.com/@collide.io

https://www.facebook.com/collide.io

https://www.instagram.com/collide.io

https://www.youtube.com/@collide_io

https://bsky.app/profile/digitalwildcatters.bsky.social

https://www.linkedin.com/company/collide-digital-wildcatters