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
IMO Python does not have a powerful enough ORM. Although most of these solutons provide the simple selects, updates, inserts and joins none of them provide good handling of legacy databases or flexibility of using the sql of your choosing (which I think is crucial, there is no point doing certain things one way and other things another way).
The only ORM tool I know of which provides a good solution to ORM is a java product called ibatis sqlmaps. Any python ORM would do well to have a similar design.
In fact I rolled my own ORM for a client which provides pretty much the same as the ORMs above (although I think it's nicer because it has a beautiful metadata model which can be accessed for generating guis, code etc. and has not restriction of database schema, can handle multi key joins) and after using it for a while I still prefer ibatis for more complex applications.
I think any ORM which enforces a database design (eg. key has to be integer id etc.) is of no use except for the simplest applications.
Huy
------------------------------------------------------- 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
