-----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-----
_______________________________________________ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db