Re: PYTHON, ODBC

> due to the complicated nature of the database, and inability of zope

Well, I've found that Zope is very good to do a few things, and very bad
at the rest.

> to do what we need, and the problems with overhead we've been
> experiencing with rails due to the size of the database. Hope this

I like psycopy because selects with a lot of rows are processed
efficiently.

Look at the pydo library in the skunkweb project (google !)

I'd advise you to start writing a base class for your database object
(class DbObject) with a set of methods for setting instance methods from
query results. SELECT * then use cursor.dictfetchall() which preserves the
fields names !
Add methods for inserting and updating.
Add a mapping of fields to type converters (which are functions) to
convert non-standard types like arrays to python lists if you need them.

Then derive your DbObject class for each table, with class variables
containing the field names and types converters, which will be used by the
base class. This way you can have a derived class with almost no code.

Enjoy !