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.

Digital Wildcatters brings the energy community together through events, cutting-edge content, and powerful tools. Join our online community at collide.io. Engage with experts, level up your career, and ask Collide AI your toughest technical questions.”

Click here to watch a video of this episode.
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://www.instagram.com/digitalwildcatters
https://www.tiktok.com/@digitalwildcatters
https://www.facebook.com/digitalwildcatters
https://twitter.com/DWildcatters

EP 59: Jacob Matson from MotherDuck