PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Jeremy Smith
Day Talks - Day 3 - Thursday - 2015-06-18
Room DMS 1140
Start time 13:00
Duration 00:45
ID 789
Event type Lecture
Track DBA
Language used for presentation English

Managing your schema

Using migrations for consistency, repeatability, and sanity

Keeping track of changes in your database schema can be challenging. In this talk I will discuss the advantages of using Flyway to effectively manage this issue.

Migrations are an essential tool for both developers and administrators. Developers can quickly recreate a database from scratch and incrementally modify their development database along with their code and tests. Similarly, administrators can determine the current state of any database and easily migrate to a newer one. Most importantly, schema and data changes can be thoroughly reviewed and tested before going to production.

In this talk, I will discuss the benefits of using Flyway to manage migrations.

Specifically, I will: - Show why migrations are useful - Introduce Flyway and how to use it - Focus on using Flyway from the command line using migrations written in sql - Help you determine which changes should be in your migrations - Discuss how to create a base migration from your existing database - Cover strategies for dealing with global objects - Show how to integrate Flyway with Jenkins

No Java experience is required for this talk.