Tutorial project for developing databases with Git, Sqitch, and pgTAP
PLpgSQL
Permalink
Failed to load latest commit information.
deploy
revert
test
verify
.gitattributes
README.md
sqitch.conf
sqitch.plan

README.md

Agile Database Development Project

This is the project for the “Agile Database Development” tutorial, presented at PGCon 2013 on May 21, 2013, and updated in January, 2016. Use this repository as an upstream remote to help follow along.

Dependencies

Before you start the project, you'll need some software.

  • PostgreSQL

    9.1.0 or higher recommended. Usually available via your distribution's package system. Binaries and source are also available for download.

  • Git

    1.7.0 or higher recommended. Usually available via your distribution's package system. Binaries and source are also available for download.

  • pgTAP

    0.92.0 or higher recommended. Download from PGXN and consult its README.md for build instructions. Also available in some packaging systems.

  • Perl

    5.10.0 or higher. Included in most Unix distributions and on OS X. Windows users can install ActivePerl.

  • pg_prove

    3.28 or higher recommended. Available in some packaging systems. Otherwise, Download via CPAN:

    cpan TAP::Parser::SourceHandler::pgTAP
    

    ActivePerl users can use PPI:

    ppm install TAP-Parser-SourceHandler-pgTAP
    
  • Sqitch

    0.97.0 or higher recommended. Install via CPAN:

    cpan App::Sqitch DBD::Pg
    

    ActivePerl users should use PPI:

    ppi App-Sqitch
    

    Homebrew users can use the Sqitch Tap:

    brew tap theory/sqitch
    brew install sqitch_pg
    

Author

David E. Wheeler

License

Creative Commons License
Agile Database Development by David E. Wheeler is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License.
Based on a work at https://github.com/theory/agile-flipr.