Database Validation and Versioning
David Steele is Principal Architect at Crunchy Data, the Trusted Open Source Enterprise PostgreSQL Leader. He has been actively developing with PostgreSQL since 1999.
David loves taking on big data challenges. Before Crunchy Data he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.
David's current project is pgBackRest, which will be the subject of this talk.
No video of the event yet, sorry!
There are many advantages to maintaining full build scripts for your database. They allow you to create your database from scratch, run unit tests, and serve as a useful reference to the current state of the database. However, in production full build scripts are only run once per database. After that it is an endless sequence of update scripts. How do you to keep the full build and update scripts in sync? How can you be sure that your production database looks exactly like your full build once all the updates have been applied? In this talk we’ll examine how validation and versioning can be used to ensure that production databases always match full builds even after thousands of updates have been applied. There will be practical demonstrations using tools such as check_postgres and sqitch.
- 30 min
- PGConf NYC 2014 [PgConf.US]