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