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 !
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
