On Jan 22, 2008 1:34 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > On 22 jan, 10:33, Dmitry Lipovoi <[EMAIL PROTECTED]> wrote: > > orm is abstraction over database query language. you can make queries > > in oo-terms. so your business logic stays clear and you dont care > > about object persistence. > > Bullshit. > > When using a RDBMS, the database schema is actually 90% (or more) of > the "business logic". Treating a relational database as an "object > persistance" mean is just braindead. FWIW, if what you want is object > persistance, then we have a pretty good Python OODBMS (the ZODB), > which is quite easy to use with Pylons if you want to.
Give him a break. :) English is clearly not his first language, so he's probably using "oo" and "persistence" in the general sense rather than a narrow Computer Science definition. If you read "you don't care about object persistence" as "you don't have to worry about all the SQL details", he's correct. Persistence in Bruno's sense means pickling a complex data structure to a Binary column. That is not ideal but is appropriate in some circumstances, for instance if you're "just" storing an unknown structure like a Beaker session, or you have a small hierarchical object that's not worth mapping into related tables. But Bruno is right that some applications would benefit from an OO database like ZODB or Durus rather than SQLAlchemy. I made a (Quixote) application with a highly hierarchical model and complex searching. I used a database-neutral model with backends for Durus, SQLAlchemy/MySQL and SQLAlchemy/SQLite. The Durus version was significantly faster and more reliable than either of the others, used less memory than SQLite, and was the most distribution-friendly (embeddable, no third-party C libraries, and BSD-like license). So Durus won hands down for this particular dataset. -- Mike Orr <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to pylons-discuss@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---