-
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
Category Archives: User interfaces
The Phantom of the Database – Part 3
In the previous episode: Alice and Bob were trying to simultaneously update the title of the following row of the film table: id | title | release_year ——-+—————-+————– 47478 | Seven Samurai | 1956 User Transaction Correctness In the … Continue reading
Posted in PostgreSQL, Python, User interfaces
Tagged concurrency control, postgresql, python, user interfaces
9 Comments
The Phantom of the Database – Part 2
In the previous episode: Alice, Bob and Carol were trying to simultaneously update the following row of the film table: id | title | release_year ——-+—————-+————– 47478 | Seven Samurai | 1956 Alice wanted to remove the extra space … Continue reading
Posted in PostgreSQL, Python, User interfaces
Tagged concurrency control, postgresql, user interfaces
16 Comments
The Phantom of the Database – Part 1
Scenario: A row with “Seven Samurai” (notice two spaces between the words) as the movie title and 1956 as the release year, in the film table. Plot: User Alice updates the row to remove the extra space. In the meantime, … Continue reading
Posted in PostgreSQL, Python, User interfaces, Version control
Tagged postgresql, python, user interfaces, version control
4 Comments
A Multi-Layered Test Cake
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 postgresql, psycopg, python, test driven development, unittest, user interfaces, werkzeug
2 Comments
Dueling Frameworks, revisited
In the closing remarks of “Dueling Frameworks”, I hinted that I may continue to explore Flask. That road first led me to take a closer look at the recent state of Werkzeug. As I had done with Flask and CherryPy, the … Continue reading
Posted in Python, User interfaces
Tagged cherrypy, flask, python, user interfaces, werkzeug
3 Comments
Quo vadis, Pyrseas?
When I found Andromeda, over a year ago, I was searching for a tool that would help me maintain PostgreSQL tables supporting web sites, somewhat like a Django admin app, but without Django itself since that was not part of … Continue reading
Posted in PostgreSQL, Python, User interfaces, Version control
Tagged andromeda, jinja, postgresql, python, sqlalchemy, user interfaces, version control, wtforms
8 Comments
Database Redesign and User Interface Refactoring
In this series about database user interfaces, until now I’ve focused on a single table with just three attributes. As I did with version control, I’ll be introducing additional entities and attributes and exploring how they could be presented or … Continue reading
Posted in PostgreSQL, Python, User interfaces, Version control
Tagged pagila, postgresql, python, user interfaces, version control
1 Comment
Dueling Frameworks
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
Audit Trails
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 pagila, postgresql, python, user interfaces, version control
2 Comments
A Funny Thing Happened on the Way to the Webserver
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 flask, jinja, mako, python, template languages, user interfaces
11 Comments
