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.
SQL code isn't complicated, it does exactly what it says on the tin! (most of the time :)). ORM encourages lazy programming = problems later down the line. On 25/08/10 11:09, Andreas Jung wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > 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. >> > Modifying the database schema (adding a new field) requires usually > changes in tons of SQL methods..updating your ORM schema definition > usually takes only one or a few lines of code. > > Or why the hell do you want to write complicated SQL code (I > remember legacy code of a co-worker to tons of complex JOINs) > yourself while you could implement the same functionality in much > nicer way using Python? > > If you ask me: writing SQL is for masochists. > > - -aj > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (Darwin) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iQGUBAEBAgAGBQJMdOvsAAoJEADcfz7u4AZjqyALwNWRbc5Pz3keM2x1wkDQfwfU > WdtHLdNvLO6jIRMadMjlO4lOgPU0/ANIlkrUFgmstiEkpEt4zj8IIBWYZfdkrryo > 6Cb5OeYN+/stFURDSdqGPViJYxybbPFd2pmcX5HW9W9msxIsZsC7mmjLWgUWQEY4 > XXZBLbSTWB3DQt1gOXXNrntPzuSopad6QUb/Pqb/JWF7dtE3WYFY2/ar0YWOd/iU > I7K3rKSTnQaBiDBwFrdrm/hHgeA34zlCs4M0qb8tWKCLsafwYNojAxdF28ScLSBD > pHbxmcQY3aRqkHFPC1DZLqJNmMqbDitIpeUqgx6oLIc73trk2znRmT/HHFP+UhWU > K72Qs6fBfEu1dvJYCA2iKFk2aE83ckqbdQnpwYtL0S3pVY3V5s1Z1ZQ4T1rz4+19 > BnuClXsZEWxfn8nn3uNZ0kpv9RI3Tw2qRgd4L5vk1s/mCFCRUi1riCKkEb/U8ygI > kiJw/Zv6hJrgY74ZA67sfaymJ6hrSfE= > =JGcb > -----END PGP SIGNATURE----- > _______________________________________________ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db