{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Database School","title":"Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/d248467d\"></iframe>","width":"100%","height":180,"duration":3766,"description":"Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com.\nIn this interview, I dive deep with Craig Kerstiens from Crunchy Data into the world of Postgres, covering its rise to prominence, scaling at Heroku, and the power of Postgres extensions. Craig also shares insights on database sharding, the future of Postgres, and why developers love working with it.\nFollow Craig:\nTwitter: https://twitter.com/craigkerstiens\nCrunchy Data Blog: https://www.crunchydata.com/blog\nFollow Aaron:\nTwitter: https://twitter.com/aarondfrancis\nLinkedIn: https://www.linkedin.com/in/aarondfrancis\nWebsite: https://aaronfrancis.com - find articles, podcasts, courses, and more.\nChapters:\n00:00 - Introduction: Welcome to Database School\n00:20 - Guest Introduction: Craig Kerstiens and Crunchy Data\n01:40 - Craig's Journey from Heroku to Crunchy Data\n02:55 - Scaling Postgres at Heroku\n04:50 - Mastering Postgres Course Announcement\n05:30 - The Importance of Postgres at Heroku\n07:50 - The Value of Live SQL with Data Clips\n09:25 - Data Clips for Business Intelligence and Real-Time Analytics\n11:05 - Heroku’s Unique Company Culture and How Data Clips Came to Be\n12:30 - Postgres Extensions and Marketplace\n14:00 - Citus: Scaling Postgres for Multi-Tenant Applications\n15:40 - The Challenges of Sharding in Databases\n18:00 - Managing Large Databases and Sharding Keys with Citus\n24:00 - The Evolution of Postgres and Its Growing Popularity\n31:00 - Postgres for Developers and the Importance of Extensions\n35:00 - Extensions as Proving Grounds for Core Postgres Features\n37:50 - Building an Extension Marketplace for Postgres\n41:00 - Postgres as a Data Platform and Developer Flexibility\n46:00 - Why Developers Love Postgres: Stability, Extensions, and Ownership\n51:00 - DuckDB: A Fascinating New Database Approach\n53:30 - Crunchy Data: What They Offer and Why It Matters\n58:30 - Expanding Postgres with DuckDB for Data Warehousing\n01:00:00 - Wrapping Up: Where to Find Craig and...","thumbnail_url":"https://img.transistorcdn.com/QPpKhRBWtM56k1sC7Y7j7aqGy8sd-XKWw6mEKgA1jmw/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9lMmRl/ZTM5ZTAxOTMzNTgy/MmJmZTA4MWE1ZjMw/YjE4Ny5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}