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.ioClick here to view the episode transcript. 00:00 - Intro02:06 - DuckDB for Google Sheets05:24 - Jacob’s Journey to DuckDB11:05 - OLTP vs OLAP13:08 - DuctDB16:59 - MDSinaBox19:08 - NBA Jam20:05 - MDS in a Box22:19 - Running on the Edge23:56 - Chick-fil-A26:20 - DuckDB31:10 - Querying Data Where It Lives35:30 - ODBC vs Arrow DataFusion42:13 - Mothertuck42:55 - Motherduck46:25 - What is Mother Duck51:10 - Connecting BI Tools to Mother Duck52:55 - PG DuckDB54:33 - Using DuctDB with Postgres56:21 - DuctDB as Cache for Snowflake58:25 - ROI of Data Teams1:01:30 - Future of ELT1:05:20 - Embeddings in Data1:06:20 - Language Models in Analytics1:07:40 - Prompt SQL Techniques1:15:10 - DuckDB Pushing SQL Forward1:18:22 - Speed Round1:19:34 - Favorite Non-DuckDB Database1:20:28 - Favorite Video or Board Game1:21:07 - Best Places to Eat in Seattle1:21:37 - Tyson vs Jake Paul 2https://twitter.com/collide_iohttps://www.tiktok.com/@collide.iohttps://www.facebook.com/collide.iohttps://www.instagram.com/collide.iohttps://www.youtube.com/@collide_iohttps://bsky.app/profile/digitalwildcatters.bsky.socialhttps://www.linkedin.com/company/collide-digital-wildcatters