Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens
Database School24 Syys 2024

Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens

Want to learn more Postgres? Check out my Postgres course: https://masteringpostgres.com.

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

Follow Craig:
Twitter: https://twitter.com/craigkerstiens
Crunchy Data Blog: https://www.crunchydata.com/blog

Follow Aaron:
Twitter: https://twitter.com/aarondfrancis
LinkedIn: https://www.linkedin.com/in/aarondfrancis
Website: https://aaronfrancis.com - find articles, podcasts, courses, and more.

Chapters:
00:00 - Introduction: Welcome to Database School
00:20 - Guest Introduction: Craig Kerstiens and Crunchy Data
01:40 - Craig's Journey from Heroku to Crunchy Data
02:55 - Scaling Postgres at Heroku
04:50 - Mastering Postgres Course Announcement
05:30 - The Importance of Postgres at Heroku
07:50 - The Value of Live SQL with Data Clips
09:25 - Data Clips for Business Intelligence and Real-Time Analytics
11:05 - Heroku’s Unique Company Culture and How Data Clips Came to Be
12:30 - Postgres Extensions and Marketplace
14:00 - Citus: Scaling Postgres for Multi-Tenant Applications
15:40 - The Challenges of Sharding in Databases
18:00 - Managing Large Databases and Sharding Keys with Citus
24:00 - The Evolution of Postgres and Its Growing Popularity
31:00 - Postgres for Developers and the Importance of Extensions
35:00 - Extensions as Proving Grounds for Core Postgres Features
37:50 - Building an Extension Marketplace for Postgres
41:00 - Postgres as a Data Platform and Developer Flexibility
46:00 - Why Developers Love Postgres: Stability, Extensions, and Ownership
51:00 - DuckDB: A Fascinating New Database Approach
53:30 - Crunchy Data: What They Offer and Why It Matters
58:30 - Expanding Postgres with DuckDB for Data Warehousing
01:00:00 - Wrapping Up: Where to Find Craig and Crunchy Data

Jaksot(30)

A million transactions per second: building TigerBeetle with Joran Greef

A million transactions per second: building TigerBeetle with Joran Greef

In this episode, Aaron talks with Joran Greef, CEO and creator of TigerBeetle, the world’s first financial transactions database. Joran takes us on a deep dive of on how TigerBeetle brings double-entr...

23 Loka 20251h 28min

PlanetScale Postgres with CEO Sam Lambert

PlanetScale Postgres with CEO Sam Lambert

Sam Lambert, my former boss at PlanetScale, talks to me about PlanetScale moving from a MySQL company to now also having a Postgres offering. Sam shares why PlanetScale decided to move to Postgres, ho...

22 Syys 20251h 6min

The database for all your AI needs

The database for all your AI needs

Marcel Kornacker, the creator of Apache Impala and co-creator of Apache Parquet, joins me to talk about his latest project: Pixeltable, a multimodal AI database that combines structured and unstructur...

16 Syys 20251h

Sharding Postgres without extensions with PgDog founder, Lev Kokotov

Sharding Postgres without extensions with PgDog founder, Lev Kokotov

I chat with Lev Kokotov to talk about building PgDog, an open-source sharding solution for Postgres that sits outside the database. Lev shares the journey from creating PgCat to launching PgDog throug...

19 Elo 202548min

Rewriting SQLite from scratch (yes, really)

Rewriting SQLite from scratch (yes, really)

Want to learn more about SQLite?  Check out my course on SQLite: https://highperformancesqlite.com/?ref=yt  In this episode of Database School, I chat with Glauber Costa, CEO of Turso, about their aud...

8 Elo 20251h 17min

Vitess for Postgres, with the co-founder of PlanetScale

Vitess for Postgres, with the co-founder of PlanetScale

Sugu Sougoumarane, co-creator of Vitess and co-founder of PlanetScale, joins me to talk about his time scaling YouTube’s database infrastructure, building Vitess, and his latest project bringing shard...

1 Heinä 20251h 7min

PlanetScale Metal

PlanetScale Metal

In this episode, I chat with Richard Crowley from PlanetScale about their new offering: PlanetScale Metal.We dive deep into the performance and reliability trade-offs of EBS vs. locally attached NVMe ...

27 Kesä 202550min

From Prisma Founder to LiveStore: Building local-first apps with Johannes Schickling

From Prisma Founder to LiveStore: Building local-first apps with Johannes Schickling

Johannes Schickling, original founder of Prisma, joins me to talk about LiveStore, his ambitious local-first data layer designed to rethink how we build apps from the data layer up.We dive deep into e...

29 Touko 20251h 31min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-narsisti
adhd-podi
rss-liian-kuuma-peruna
rss-duodecim-lehti
jari-sarasvuo-podcast
psykologia
rss-koira-haudattuna
rahapuhetta
leveli
rss-uskonto-on-tylsaa
rss-valo-minussa-2
rss-luonnollinen-synnytys-podcast
rss-niinku-asia-on
kesken
salainen-paivakirja
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-tietoinen-yhteys-podcast-2