Como publicar alterações no BD? Como sincronizar a alteração do BD com a nova versão da aplicação? Já ouviu falar de "Migrations"? Play no p de Podcast!

Participantes
Marcio Frayze David
marcio@segunda.tech
https://twitter.com/marciofrayze
https://segunda.tech
https://masto.donte.com.br/web/accounts/138458
https://linkedin.com/in/marcio-frayze

Julianno Martins Silva
juliannoms@gmail.com
https://twitter.com/juliannoms
https://linkedin.com/in/juliannoms

Links:

Artigo da Amanda Sposito. Migrations in databases with large amount of data:
http://blog.plataformatec.com.br/2019/02/migrations-in-databases-with-large-amount-of-data/

Criando íncides no PostgreSQL sem lock:
https://www.postgresql.org/docs/9.1/sql-createindex.html

Undo no flyway (não recomendado):
https://flywaydb.org/documentation/command/undo

Definição de Database refactoring:
https://en.wikipedia.org/wiki/Database_refactoring

Livro Refactoring Databases:
https://www.goodreads.com/book/show/161302.Refactoring_Databases

Blue-green deployment:
https://martinfowler.com/bliki/BlueGreenDeployment.html

Evolutionary Database Design, Pramod Sadalage:
https://www.martinfowler.com/articles/evodb.html

Boas práticas de Migration em Java na Heroku:
https://devcenter.heroku.com/articles/running-database-migrations-for-java-apps

Ferramentas de migrations:

Java:
https://flywaydb.org/
https://www.liquibase.org/

.NET:
https://docs.microsoft.com/pt-br/ef/core/managing-schemas/migrations/?tabs=dotnet-core-cli

Ruby on rails:
https://edgeguides.rubyonrails.org/active_record_migrations.html