Re: Zope-DB Digest, Vol 72, Issue 1

This is a multi-part message in MIME format.
--------------060305070204030600010506
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Richard Harley wrote:
> Hmmm..If the database was modeled properly in the first place if
> wouldn't be referenced in many different places therefore it would not
> require changes in tons of SQL methods.

Perhaps you haven't work with large installation using SQL heavily?
After having ported a project with roughly 200 ZSQL methods to
Sqlalchemy: it was a *huge* win working with the backend on the Python
level and dealing with database entities like Python objects.

> 
> SQL code isn't complicated, it does exactly what it says on the tin!
> (most of the time :)). 

SQL can become *very complicated* - ever tried to understand complex
SQL queries of other people? Working with a proper database model
on the Python level is much easier. Yes, you are moving complexity from
SQL to Python and ORM configuration can be confusing as well. However
a descriptive model of a database in Python with its relations is much
easier to handle than dealing with it on the SQL layer directly.

> ORM encourages lazy programming = problems later
> down the line.

Nonsense - using SQLAlchemy for more than four years now in four or five
larger projects and it is a major win regarding productivity, software
architecture, implementation and testing.

- -aj


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJMdPPnAAoJEADcfz7u4AZj6dULv13bzwtodOh1mM0hdl/OamKE
zBlXNMbcKWlZ0pFErFGWuhCQDjgFBTI5nXuNE/py8Ckmzdzrss2Opk1fselyv6qT
AC/++/FX/Zv5HA7yzVKeBGJ88KIoc/XcFm/5syQrbik67mSCtJcQyjoIOrjGXIy/
HmlbWzRYOYM7hORTkWEmsjPFEjlNfQFUx01CkAstkOp2nAsQe0LH2X9N2gs6BI1H
IORI0u0GkNPvkwXJTgHEoR62bPmrWS+MANdLORQI62G7Rm1WG8cZ/jMzUH6yT0r6
p0bGnca2eux3JyvBSm4p+8Ap64zEbjxhB/Iww5qzojSY+xgZmG0DUJKUAMeXMYZU
dd5es9CmoDRNsMjDfBsnciSRcHw9S+T/eRdcf8YEiUPkeSC1P/4RIbgk7vIWnyef
KtlNYoHCVL8IUIYAGOJNytiTp1Oxg9Q581KM2auFZpUSlZBLafovqGvJSCudxYbs
SlSiXx7aI6uv5vPLuOjMF/ZXPvfKp6E=
=Lrga
-----END PGP SIGNATURE-----

--------------060305070204030600010506
Content-Type: text/x-vcard; charset=utf-8;
 name="lists.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="lists.vcf"

begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[email protected]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard


--------------060305070204030600010506
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Zope-DB mailing list
[email protected]
https://mail.zope.org/mailman/listinfo/zope-db

--------------060305070204030600010506--