Tag Archives: postgresql  A Pythonic, TTM-inspired interface to
PostgreSQL – Requirements  Several moons ago, I started a series
of posts about “designing and implementing a generic end user
interface for PostgreSQL.” After a while, the series got
sidetracked by other issues.  More recently, I have returned to
the original endeavor. Partly from reading Database
Explorations: Essays on The Third Manifesto and related topics
by C.J. Date and Hugh Darwen, I decided to use relational
concepts as presented in The Third Manifesto (TTM) in my
implementation. This post provides an overview of the
requirements.  Limited Scope  The interface is not a full-blown
replacement for an object-relational mapper (ORM) (although in
theory it could eventually grow in that direction). The
interface is intended to assist with two typical needs of a
database “admin” application: browsing and CRUD.  Browsing
refers to presenting a subset of rows (tuples) of a table
(relation variable or relvar) for subsequent editing. The relvar
wil