PGCon2017 - 20180510
PGCon 2017
The PostgreSQL Conference
Speakers | |
---|---|
Sean Chittenden |
Schedule | |
---|---|
Day | Talks - Day 1 - 2017-05-25 |
Room | DMS 1120 |
Start time | 10:00 |
Duration | 00:45 |
Info | |
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.