Monthly Archives: April 2011

Python Development Tools of the Trade

Posted on 25 April, 2011 by

Last week, Bruce Momjian commented that pgindent is one of the reasons for the clarity of the PostgreSQL source code. Today, Andrew Dunstan remarked on “how cleanly it compiles” and no doubt this is due in great part to the … Continue reading →

Posted in PostgreSQL, Python | Tagged , , , , , | 2 Comments

SQL Database Version Control and RENAMEs

Posted on 21 April, 2011 by

You’ve just watched Josh Berkus’ presentation “Ten Ways to Wreck Your Database” and bearing in mind point #2 “ranDom_naming(s),” your team has decided to get your act together and adopt a naming convention (although this may not be advantageous to … Continue reading →

Posted in PostgreSQL, Version control | Tagged , , , , | Leave a comment

SQL Database Version Control – Pyrseas

Posted on 12 April, 2011 by

Now that Pyrseas has been released, it’s time to see how the DBAs Carol and Dave would use it to manage the changes described in Version Control, Part 2: SQL Databases. Version 0.1 Carol starts by creating the film table in … Continue reading →

Posted in PostgreSQL, Python, Version control | Tagged , , , , , | 2 Comments

First release of Pyrseas

Posted on 5 April, 2011 by

just a quick note to announce that the first release of Pyrseas is now available as follows: Github https://github.com/jmafc/Pyrseas: Git repository. You can report any issues there. Python Package Index http://pypi.python.org/pypi/Pyrseas:  Source tar archive. PgFoundry http://pgfoundry.org/projects/pyrseas/: Source tar archive. Discussion … Continue reading →

Posted in PostgreSQL, Python, Version control | Tagged , , , | 3 Comments