Hash: SHA1

Andreas Jung wrote:
> Charlie Clark wrote:
>> Am 06.02.2010, 21:56 Uhr, schrieb Tres Seaver
>> <tsea...@palladion.com>:
>>> You aren't ever going to get ZSQL "migrated" to use ZPT.  ZPT is
>>> a really poor fit for "non-markup" templates like SQL.  Folks
>>> writing "modern" apps tend to favor non-dynamic SQL anyway (using
>>> "placeholder variables") and so would just not use ZSQL.
>> Sorry, I didn't mean to imply that. I would like an alternative to
>> DTML for ZSQL which would generate SQL with the appropriate
>> placeholders and some minimal templating logic. But that would be a
>> different project.
> Why do you want to write new apps on top of ZSQL? The only thing that is
> more disgusting than writing SQL code is generating SQL code with DTML.
> Sorry, but we are in the ORM world and using SQLAlchemy & friends is
> the much nicer and smoother way doing SQL related programming nowadays.

Andreas, you need to back off on the soapbox stuff.  Not everybody likes
ORMs, and they do have their downsides:  I write SQL from scratch for
the same reason the "old timers" hand assembled performance-critical
bits of code, rather than using a C compiler:  I believe (and still find
it to be so) that the schemas and querires I hand tune out-perform the
ORMs significantly for the problems I solve with RDBMSes.  But I don't
use them for "normal" apps:  my typical applications have hundreds of
thousands to millions or tens of millions of records in some tables.

- --
Tres Seaver          +1 540-429-0999          tsea...@palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


Zope-Dev maillist  -  Zope-Dev@zope.org
**  No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope )

Reply via email to