PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

Sean Chittenden
Day Talks - Day 1 - 2017-05-25
Room DMS 1120
Start time 10:00
Duration 00:45
ID 1095
Event type Lecture
Track Applications
Language used for presentation English

Codified PostgreSQL Schema

Idempotent Schema Migrations for Developers and DBAs

Why stop at a declarative description of infrastructure alone? Tired of seeing developers do rake db:migrate and want to see something that intelligently handles the schema migration? Now you can codify the structure and permissions of an application's database entirely using Terraform. Terraform provides a declarative, codified framework for describing both infrastructure, and now PostgreSQL schema. The Terraform PostgreSQL provider abstracts the actual mechanics of running the DDL and DCL from the desired declarative structure of PostgreSQL's schema. Describe it in Terraform and let Terraform converge the structure of the database to match what's described in code.

offers a declarative language to codify the structure of infrastructure, including PostgreSQL schema. Terraform internally builds out a dependency graph and evaluates the graph, performing the necessary DCL and DDL to converge the structure of the PostgreSQL database.

This talk will cover a bit of theory but will be a live and interactive demo where we build a PostgreSQL schema using Terraform from the ground up.