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, jose@... 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@...
> https://lists.sourceforge.net/lists/listinfo/webware-discuss
>
>
_________________________________________
winston wolff - (646) 827-2242 - http://www.stratolab.com - learning by
creating
|