Tag Archives: psycopg

Testing Python and PostgreSQL on Windows, Part 3

Posted on 28 September, 2012 by

As a commenter mentioned in response to Part 2, an alternative to using pip install psycopg2, which requires that you first install VC++ 2008 Express, is to download and install the Windows port, aka win-psycopg. Jason Erickson makes these builds … Continue reading →

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

Testing Python and PostgreSQL on Windows, Part 2

Posted on 25 September, 2012 by

In the previous post, I covered installation of Git, PostgreSQL and Python under Windows in order to set up a Pyrseas testing and development environment. Today, we’ll explore installation of the Python dependencies. The Hitchhiker’s Guide to Python recommends first … Continue reading →

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

Database User Interfaces – Pagination

Posted on 6 April, 2012 by

Since it’s been a while from my last post on this subject, let me recap what we’ve covered: Defined a minimal command line interface as a means of exercising the basic Python-PostgreSQL interface. Following Toon Koppelaars’ Helsinki (IT) Declaration, split … Continue reading →

Posted in PostgreSQL, Python, User interfaces | Tagged , , , , , , | Leave a comment

A Multi-Layered Test Cake

Posted on 24 October, 2011 by

A recurrent theme in software engineering are the multiple layers (or tiers) into which systems are subdivided. In the ideal case, a given layer only interacts with the immediate layers “above” and “below” it. In practice, that clean separation of … Continue reading →

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

A More Robust Database Interface

Posted on 15 August, 2011 by

The PostgreSQL server, like other client-server DBMSs, is complex. Many things can go awry. Here is a sampling of possible problems, as reported by psycopg: psycopg2.OperationalError: FATAL:  database “None” does not exist psycopg2.OperationalError: could not connect to server: No such … Continue reading →

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

To MVC or not to MVC

Posted on 13 June, 2011 by

Many (or most) application frameworks have adopted a Model-View-Controller (MVC) architecture, for example, Django (they call it MTV but it’s very similar), Pylons, Ruby on Rails, and Struts. In The Helsinki Declaration (IT Version), Toon Koppelaars makes the case for … Continue reading →

Posted in PostgreSQL, Python, User interfaces | Tagged , , , | 7 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

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