Friday, 6 October, 2017 UTC


Summary

Shippable makes it easy to setup database migrations and test them continuously. In this blog, we will go over the steps to execute and test migrations on a PostgreSQL database using Shippable CI. 
Our sample uses Node.js and the node-pg-migrate module to setup migrations on a postgres database. Shippable integrates with Postgres and allows you to automatically launch a PostgreSQL instance with a single line in the yml configuration. We will test migrations on this PostgreSQL instance.

Sample project

The code for this example is in GitHub: devops-recipes/ci-migrate-postgresdb 
You can fork the repository to try out this sample yourself or just follow instructions to configure your own use case.