เกี่ยวกับตอนนี้
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 through YC, the technical challenges of sharding, and why he believes scaling Postgres shouldn’t require extensions or rewrites.
Follow Lev:
- Twitter: https://twitter.com/levpgdog
- PgDog: https://pgdog.dev
Follow Aaron:
- Twitter: https://twitter.com/aarondfrancis
- LinkedIn: https://www.linkedin.com/in/aarondfrancis
- Website: https://aaronfrancis.com — find articles, podcasts, courses, and more.
- Database School: https://databaseschool.com
Chapters
- 00:00 - Intro
- 01:27 - Lev’s self-taught to computer science degree journey
- 04:50 - Transition to Postgres discussion
- 05:24 - History of PgCat
- 07:06 - What PG Cat does and key features
- 08:59 - Why Lev built PgCat instead of extending PG Bouncer
- 10:06 - PG Cat’s current status and usage
- 12:20 - Moving from PgCat to PgDog
- 13:09 - Applying to YC as a solo founder
- 16:24 - YC pitch: the market gap for Postgres sharding
- 18:52 - High-level overview of PgDog
- 23:32 - Why PgDog is not an extension
- 25:57 - When to build Postgres extensions vs standalone tools
- 27:49 - PgDog architecture and query parsing
- 30:39 - Handling cross-shard queries and current capabilities
- 33:47 - How PgDog shards an existing large Postgres database
- 36:37 - Parallel replication streams for faster sharding
- 39:07 - Alternate resharding approaches
- 42:52 - Where PgDog draws the orchestration line
- 44:00 - Vision for PgDog Cloud vs bring-your-own-database
- 46:47 - Company status: first hire, design partners, and production use
- 50:45 - How deploys work for customers
- 52:20 - Importance of building closely with design partners
- 54:05 - Paid design partnerships and initial deployments
- 56:23 - Benefit of sitting outside Postgres for compatibility
- 58:32 - Near-term roadmap and long-term vision
- 1:01:03 - Where to find Lev online
ภาษาอังกฤษ
สหรัฐอเมริกา
สำเนาบทสนทนา 🔗
Are you the producer of this podcast?
Add a podcast transcript
Need Audio-to-Text?
Transcribe with Listen411 in Just 60 Seconds
ตอนอื่นๆ ใน PODCAST นี้
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 audacious decision to rewrite SQLite from the ground up.
We cover the technical motivations, open c…
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 unstructured data with rich, Python-native workflows.
From ingestion to vector search, transcription to snap…
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-entry accounting principles directly into the database layer to achieve extreme correctness, performanc…
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, how MySQL and Postgres are different at a technical level, and how the change has impacted the compan…
ข้อสงวนสิทธิ์: พอดแคสต์และอาร์ตเวิร์คที่ฝังอยู่ในหน้านี้มาจาก Try Hard Studios ซึ่งเป็นทรัพย์สินของเจ้าของและไม่มีส่วนเกี่ยวข้องหรือรับรองโดย Listen Notes, Inc.