Tag Archives: git

Testing Python and PostgreSQL on Windows – Basics

Posted on 20 September, 2012 by

In my previous post, I wrote: Although I have not yet personally run the [Pyrseas] unit tests on Windows …, I believe the tox setup should be quite portable …, since the tests only depend on Python and psycopg2 being … Continue reading →

Posted in PostgreSQL, Python | Tagged , , , , , | 1 Comment

Dueling Frameworks

Posted on 29 August, 2011 by

Cue the music … In this corner, the time-tested CherryPy, standing at version 3.2, six years old, enabled for Python 3, sporting an HTTP 1.1-compliant WSGI webserver, support for other WSGI servers or adapters, a plugin mechanism, built-in tools and … Continue reading →

Posted in Python, User interfaces | Tagged , , , , | 10 Comments

A Minimalist Command Line Database User Interface

Posted on 31 May, 2011 by

To begin exploring the design of a generic database user interface as mentioned in my previous post, I’ve written a minimalist command line program. To try it, do this: $ git clone git://github.com/jmafc/database-ui-tutorial.git dbui $ cd dbui $ createdb moviesdev … Continue reading →

Posted in PostgreSQL, Python, User interfaces | Tagged , , , , | 9 Comments

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 – 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

SQL Database Version Control – apgdiff

Posted on 14 February, 2011 by

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 →

Posted in PostgreSQL, Version control | Tagged , , , | 15 Comments

Version Control, Part I: Pre-SQL

Posted on 1 February, 2011 by

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 →

Posted in PostgreSQL, Version control | Tagged , , , | 1 Comment