Postgres FM cover image

Postgres FM

Version control for databases

Nov 4, 2022
This podcast explores the importance of version control for databases, including the challenges of schema change management. The hosts discuss Postgres Compare, the significance of including data in the schema, and the difficulties of managing create statements in version control. They also explore the concept of separating tables and functions, the challenges of triggers and table alteration locking attempts, and the difficulties of managing configuration files in version control.
31:21

Podcast summary created with Snipd AI

Quick takeaways

  • Implementing version control for databases is crucial for managing schema changes alongside data changes.
  • Existing schema change management tools face challenges in achieving zero-downtime deployments and providing better support for database data.

Deep dives

Database version control and schema changes

The podcast discusses the importance of database version control, specifically focusing on schema changes. It emphasizes the need for managing schema changes in conjunction with data changes, such as altering data types or columns. It compares the evolution of code version control systems from naive and lock-based systems to the decentralized systems like Git. While application code version control is well-established, the podcast highlights that many teams still struggle with implementing a similar system for their databases, leading to issues with collaboration, deployments, and continuous integration.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode