The Changelog: Software Development, Open Source What's so exciting about Postgres? (Interview)
Oct 23, 2020
Craig Kerstiens, a PostgreSQL aficionado known for his extensive contributions to the community, joins the discussion to highlight the unique features of Postgres. He shares insights on its evolution, emphasizing JSON capabilities while maintaining relational integrity. Craig dives into managing background tasks and the power of customizable extensions that make Postgres versatile. With a passion for community engagement, he also discusses future advancements and practical tips for maximizing PostgreSQL performance.
AI Snips
Chapters
Transcript
Episode notes
Heroku's Postgres Influence
- Heroku's influence likely caused the shift from MySQL to Postgres in the Rails community.
- Every Rails app on Heroku had a Postgres database, increasing its popularity.
Postgres: Reliability First
- Postgres prioritizes data safety and reliability over adding shiny new features.
- Unlike some databases, Postgres ensures data integrity as a core value.
Postgres Origin and Community
- Postgres originated from UC Berkeley, rooted in Ingress, and has been stewarded by a dedicated community.
- Tom Lane, a major contributor, worked on image formats before shifting to Postgres.