PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Jeremy Smith |
| Schedule | |
|---|---|
| Day | Talks - Day 3 - Thursday - 2015-06-18 |
| Room | DMS 1140 |
| Start time | 13:00 |
| Duration | 00:45 |
| Info | |
| 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.