I took a quick look at SQLObject, but chose MiddleKit and I am very happy with it. I like defining my "object model" in a spreadsheet and letting MiddleKit generate setters and getters automatically. I feel it lets me get a good overview of all my objects and their links in one easy to read page.

I also like the way MiddleKit allows you to extend the generated python code in separate class files.

That way, I can change my object model and regenerate code without disturbing my hand-written extensions. Another thing is the way MiddleKit allows easy pythonic access to back links. That is, if a Person has multiple Address objects, you can iterate with
for a in thePerson.addresses():
And middle kit makes this iterator more or less automatically. If the iterator would return hundreds of objects, then you probably want to write a custom query for efficiency, but it handles 80% of the cases with ease.

My only concern with MiddleKit are its support for transactions and PostgreSQL. MiddleKit only recently reached the point of passing all its tests with PostgreSQL, and I don't know if anybody is using it for real. Second If you went with PostgreSQL or MSSQL, there is no support in MiddleKit for atomic transactions. Right now I don't need it, but it might become an issue later. Then again, I find the code for MiddleKit very well organized, so I might end up implementing transaction myself.

-winston

On Feb 7, 2005, at 1:43 PM, [EMAIL PROTECTED] wrote:

Dear Webware users,

I've got a non webware, but related question to ask the group. What
Object Relational Model software is being used out there. I've
recently come the conclusion that we will need to move out database
layer to some type of ORM system, especially since we are in the
process of moving from one database system to a different one, and I
had I used an ORM in the first place it would have been easy, now we
will have to redesign much of the website. I've some looking and there
are really quite a few out there the ones that I've seen are:

middlekit (webware)
sqlobject
pydo
ORM (Object Relational Membrane)
pdo
dbo

all of these on the surface seem to provide essentially the same thing,
they just all do it differently. I really think that this is a pretty
important decision to make similar to picking a web-application back
end, once made you end up getting stuck with it for better or worse.
So I am trolling to see what people are out their are using and what the
collective experience is. Thanks for any and all help


Jose



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Webware-discuss mailing list
Webware-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/webware-discuss


_________________________________________
winston wolff - (646) 827-2242 - http://www.stratolab.com - learning by creating

Reply via email to