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
