-
Recent Posts
Archives
Categories
Tags
adminer alter table andromeda apgdiff autodoc bottle cherrypy concurrency control constraints create table database tools dbdeploy diva django emacs flask git jinja liquibase mako pagila pesto pgfoundry php post facto postgresql psycopg pyramid python pyyaml sqlalchemy test driven development testing tox ttm twisted unittest user interfaces version control versioning web.py web2py webob werkzeug windowsBlogroll
Meta
Monthly Archives: March 2011
SQL Version Control System Design Issues
The initial release of Pyrseas is nearing completion. As noted elsewhere, Pyrseas was born to follow through on the concepts of the Andromeda Project. The idea of using a data dictionary specified in JSON or YAML was perhaps the most … Continue reading
Posted in PostgreSQL, Python, Version control
Tagged postgresql, python, test driven development, version control
8 Comments
SQL Database Version Control – Summary
Update: Please visit the Schema VC page for updated information. Before moving on to discussing how the Pyrseas version control tools deal with the database changes we’ve been using as examples, it seems appropriate to summarize the tools reviewed so … Continue reading
SQL Database Version Control – Andromeda
In my first review of database VC tools, I mentioned Kenneth Down’s article where he recommended storing a single metadata file in a VCS and using a difference engine to do database upgrades. In a subsequent post, Kenneth expanded on … Continue reading
SQL Database Version Control – Post Facto
In this series on SQL database version control solutions, so far we’ve seen a difference engine and some change control aids. The difference tool, apgdiff, suggests you need to store schema listings, i.e., the output from pg_dump -s, in your … Continue reading
Posted in PostgreSQL, Python, Version control
Tagged post facto, postgresql, python, version control
4 Comments
SQL Database Version Control – Liquibase
Scott Ambler is a prolific author in the area of agile software and agile database development. He and Pramod Sadalage wrote Refactoring Databases: Evolutionary Database Design, a book that expounds the process and techniques for making changes to databases. Caveat … Continue reading
Posted in PostgreSQL, Version control
Tagged dbdeploy, liquibase, postgresql, version control
9 Comments
