We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Codified PostgreSQL Schema

Formal Metadata

Title
Codified PostgreSQL Schema
Subtitle
Idempotent Schema Migrations for Developers and DBAs
Title of Series
Number of Parts
19
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
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.