PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

David E. Wheeler
Day Tutorials - Day 2 - 2013-05-22
Room MRT 256
Start time 13:00
Duration 03:00
ID 615
Event type Workshop
Track Tutorial
Language used for presentation English

Agile Database Development

with Git, Sqitch, and pgTAP

Hi, I'm David. I like to write database apps. Just as much as I like to write web apps. (Maybe more!) How? Not by relying on bolted-on, half-baked database integration tools like migrations, I'll tell you that!. Instead, I make extensive use of best-of-breed tools for source control (Git, database unit testing (pgTAP), and database change management and deployment (Sqitch). If you'd like to get as much pleasure out of database development as you do application development, join me for this tutorial. We'll develop a sample application using the processes and tools I've come to depend on, and you'll find out whether they might work for you. Either way, I promise it will at least be an amusing use of your time.

Are you tired of the poor tools for managaging database schema changes?

Are you offended by the requirement that changes committed to your souce code repository can never be changed, ever?

Do you want the database interfaces you create to work the way you think they work?

If so, join some of your most hard-working, intelligent, and attractive database colleagues for this tutorial, affectionally known as "Theory's Pragmatic approach to Database Development."

We'll go through the process of developing, modifying, testing, and deploying a database application for a web service. We'll make extensive use of the awesome tools currently at our disposal to grease the wheels of creation, collaboration, and completion:

  • Git for source code management. We'll cover how Git thinks, and discover the freedom to hack without annoying your collaborators.

  • pgTAP for database unit testing. Make sure that the database interfaces you create work the way you think they do -- and stay that way!

  • Sqitch for database schema change management and deployment. Liberate yourself from the constraints of half-baked, bolted-on migrations and discover the freedom of developing, modifying, and deploying your database like the database maven you are.

If you're a database geek who works with source code, applications, and other developers, you won't want to miss this get-together.


Please come to this session with the following software installed and ready to go on your laptop: