The Changelog: Software Development, Open Source Just Postgres (Interview)
19 snips
Jan 20, 2023 Craig Kerstiens, Chief Product Officer at Crunchy Data and a leading Postgres ambassador, dives deep into the evolution and rising popularity of Postgres. He discusses its unique features that distinguish it from proprietary databases, alongside the burgeoning ecosystem of extensions. Insightful conversations about serverless solutions highlight cost dynamics and challenges, while the innovative use of Postgres with Notion opens new doors for web development. With anecdotes and community dynamics, Craig paints a vibrant picture of Postgres's future.
AI Snips
Chapters
Books
Transcript
Episode notes
Bridging the DBA Gap
- Tools and services are needed to fill the DBA gap for app developers.
- Developers should focus on features, not database details, so tools bridging the gap are important.
Postgres Forking and Innovation
- Postgres's extensibility led to forking for data warehousing, creating proprietary solutions.
- This temporarily stalled broader database innovation, but now a return to pure Postgres is occurring.
Postgres Extension Ecosystem
- Postgres offers various extension points like C extensions, backend storage changes, and foreign data wrappers.
- Consider extension complexity and risk when choosing between Postgres extensions, backend changes, and foreign data wrappers.
