Yet another database question, please

Bruno Desthuilliers bruno.42.desthuilliers at
Fri Nov 30 17:51:15 CET 2007

nmp a écrit :
> Bruno Desthuilliers wrote:
> [..]
>> About DB access, there are two major APIs : the official (low-level -
>> that is,relatively to the other one...) db-api, and the higher-level
>> SQLAlchemy package. Note that while having an ORM part, SQLAlchemy is
>> first an higher-level SQL/Python integration layer, so you can still
>> think "relational" - but with something much more powerful than strings
>> to build your queries.
>> Tying the model (wether relational or not) with the UI is quite a
>> different problem. I assume you know what MVC mean, and from then I'm
>> afraid I can't help more.
> MVC is one of those vague abbreviations that describe the architecture of 
> three-tier client/server applications, right? :)

Nope. It's one of those vague abbreviations that describes the 
architecture of GUI applications !-)

More seriously, the original MVC concept (which comes from Smalltalk) is 
still worth studying.

> Anyway, I think I have found some study material. I don't know whether 
> these are really good examples, but I will be studying the source code of 
> <> and <>. 
> These seem to be two programs in the same style that I want to create, 
> using both SQLAlchemy and PyGTK.
> I have also found <> (looks trustworthy) and 
> <> (website offline at the moment?) 
> which could be alternatives for SQLAlchemy. I am not sure at this point 
> if I want to go that course.

Well, having used SQLAlchemy, I can tell you it's really worth it's 
weight in gold.

More information about the Python-list mailing list