Re: [Zope-DB] ORMs (Zope-DB Digest, Vol 72, Issue 1)

2010-08-26 Thread M.-A. Lemburg
Richard Harley wrote: Please can someone explain why ORM is better than speaking directly to the database? Isn't this just adding another layer of complexity which in huge databases is certainly not needed. It really all depends on what your needs are. This is my experience: If you just

Re: [Zope-DB] SQLAlchemy

2010-08-26 Thread Chris Withers
M.-A. Lemburg wrote: I'd suggest to use a Python class as abstraction layer Sounds like an ORM to me ;-) Seriously, SQLAlchemy lets you do all of the things you're worried about, performance and flexibility wise, as well as map your sql onto objects (or not, if you don't actually want

Re: [Zope-DB] SQLAlchemy

2010-08-26 Thread M.-A. Lemburg
Chris Withers wrote: M.-A. Lemburg wrote: I'd suggest to use a Python class as abstraction layer Sounds like an ORM to me ;-) No, there's no object-relational mapping being done, only interfacing between the data used by the application and the schema you have in the database. As nice