Tag Archives: user interfaces

Tuples in the Pythonic, TTM-inspired interface to PostgreSQL

Posted on 26 March, 2013 by

The Third Manifesto formally describes tuple types (RM prescription 6), tuple values (prescription 9), tuple variables (prescription 12) as well as other tuple-related elements. As mentioned in the previous post, a tuple value is a set of ordered triples each … Continue reading →

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

Attributes in the Pythonic, TTM-inspired interface to PostgreSQL

Posted on 21 March, 2013 by

The Third Manifesto‘s Relational Model (RM) prescription 9 defines a relation heading as “a set of ordered pairs or attributes of the form <A,T>,” where A is the name of the attribute and T is the name of the declared … Continue reading →

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

A Pythonic, TTM-inspired interface to PostgreSQL – Requirements

Posted on 7 March, 2013 by

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 … Continue reading →

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

More Database Tools?

Posted on 5 March, 2012 by

It’s been over year since I started blogging on these pages about Pyrseas and version control. In a month it will also be the first anniversary of the initial commit to GitHub. Much code and many words have flown under … Continue reading →

Posted in Database tools, PostgreSQL, Python, User interfaces, Version control | Tagged , , , , | 4 Comments

The Phantom of the Database – Part 4

Posted on 13 January, 2012 by

At the end of November, I finished the third episode with mild suspense: I suggested that the problem of optimistic “locking” could perhaps be solved in PostgreSQL with something other than extra qualifications, row version numbers or timestamps. Let’s start … Continue reading →

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

Python Web Frameworks – Application Object

Posted on 10 January, 2012 by

In response to my previous post, someone asked “… what’s the point? How one way is better than the other?” My response was that I’m “not trying to judge these frameworks from the perspective of a developer (at least not … Continue reading →

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

Python Web Frameworks – Development Server

Posted on 29 December, 2011 by

One of the most frequent tasks of a web developer is running the app while it’s being written. So we’ll begin our examination of Python web frameworks by looking at the development servers provided and how does one run the … Continue reading →

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

Python Web Frameworks – Candidates

Posted on 26 December, 2011 by

I’ve been researching web frameworks, partly with a view to writing my own, and thought I’d share my findings. This first post will present the candidates briefly and subsequent posts will delve into particular features. The candidates are presented based on … Continue reading →

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

Design Notes on Database Application Development

Posted on 19 December, 2011 by

I recently took a brief look at web2py since its Database Abstraction Layer (DAL) sounded interesting. After following the tutorials in the Overview chapter, I ended up not delving into DAL.  Instead, I revisited Ruby on Rails which I had … Continue reading →

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