Title: When building services that rely on relational databases, in my case postgres, what are some best practices and tools to help manage schema changes?<p>We&#x27;ve been using migrations and doing it all manually but it&#x27;s become a bottleneck and a little bit of a nightmare with multiple consumers of the database needing to make schema changes.<p>Another concern is multiple environments, from local development to staging and production. We&#x27;re using docker-compose for local development which runs the entire &quot;full&quot; schema and then I&#x27;m manually applying the migration files to staging and production before we deploy.<p>I&#x27;ve looked at some projects like flywaydb[1] and liquibase[2] but both are not completely free and seem proprietary. Does anyone know of another open source system that could help manage database schema versioning and migrations?<p>Thanks so much HN, this is something that I have been struggling with.<p>1: https:&#x2F;&#x2F;flywaydb.org&#x2F;<p>2: https:&#x2F;&#x2F;www.liquibase.org&#x2F;
Upvote: