-
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: February 2011
Interesting database tool: Adminer
No, it’s not a tool to extract extra revenue from Google Ads. Adminer (which I guess is pronounced admin-er, rather than ad-minor) is a nifty little tool that competes with phpMyAdmin, the web-browser-based MySQL administration tool. What is interesting from … Continue reading
SQL Database Version Control – depesz Versioning
In the previous article, we reviewed how a difference engine, as implemented by apgdiff, in conjuction with a VCS, can assist in controlling upgrades to a SQL database, In “How to manage changes to your database?” Hubert “depesz” Lubaczewski explains … Continue reading
SQL Database Version Control – apgdiff
In “Database Development: Table Structure Changes,” Kenneth Downs argued that build scripts to modify table structures “are usually the least tested part of the system.” He suggested using a single metadata file that describes the database and can be placed … Continue reading
Version Control, Part 2: SQL Databases
In Part 1 we saw how Alice and Bob used a VCS to manage changes to a file of movie information. In this post, we’ll examine how Carol and Dave, database specialists, deal with similar changes while developing the same … Continue reading
Posted in PostgreSQL, Version control
Tagged alter table, create table, postgresql, version control
16 Comments
Version Control, Part I: Pre-SQL
A version control system (VCS) such as Git or Subversion is an indispensable component of modern software projects. Many applications use a relational database management system (DBMS) such as PostgreSQL. While a DBMS facilitates an application’s data management tasks, it … Continue reading
