Monthly Archives: August 2011

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

Audit Trails

Posted on 23 August, 2011 by

Back in February, I defined the film table version 0.1 with just three columns: CREATE TABLE film ( id INTEGER NOT NULL PRIMARY KEY, title VARCHAR(32) NOT NULL, release_year INTEGER NOT NULL CHECK (release_year >= 1888) ); It was unclear … Continue reading →

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

A Funny Thing Happened on the Way to the Webserver

Posted on 17 August, 2011 by

Some years ago, I was looking for forum software, preferably written in Python, so I found Pocoo’s original bulletin board project. Since then, I’ve kept an eye on the Pocoo team, experimenting early on with Werkzeug, and using Pygments (indirectly) … Continue reading →

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

Templating for Web Database Interfaces

Posted on 8 August, 2011 by

If you count the number of lines in the HTML files of the (corrected) v0.2 of the minimalist WSGI database interface I presented earlier, you’ll find 228 non-blank lines. However, there are only 91 unique lines. In other words, there … Continue reading →

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

Where to CHECK your premises

Posted on 1 August, 2011 by

“Contradictions do not exist. Whenever you think that you are facing a contradiction, check your premises. You will find that one of them is wrong.” — Ayn Rand 1 In both the command line and WSGI database user interfaces that … Continue reading →

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