[Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

Andy McKay andym@ActiveState.com
Thu, 19 Apr 2001 12:30:20 -0700


Whats the problem with ZSQL? It calls a sql db with the sql statement, what
more could you want. If you want more, use python.

Cheers.
--
  Andy McKay.


----- Original Message -----
From: "Paul Browning" <paul.browning@bristol.ac.uk>
To: "The Doctor What" <docwhat@gerf.org>
Cc: <zope-dev@zope.org>
Sent: Thursday, April 19, 2001 11:48 AM
Subject: Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)


>
>
> --On 19 April 2001 13:00 -0500 The Doctor What <docwhat@gerf.org> wrote:
>
> > * The Doctor What (docwhat@gerf.org) [010419 11:57]:
> >> Does any one have an example of ZSQL being used witha normalized
> >> database?  Or is ZSQL just useless?
>
> [intemperate stuff snipped]
>
> I wouldn't dream of posting to zope-dev myself until
> I'd read around a bit. And I've been reading around
> for more than a year and I still haven't posted ...
>
> >
> > I still would love some examples.  Do people end up with 4 ZSQL
> > objects per thing they manipulate in their database?:
> > UPDATE, SELECT, INSERT and DELETE?  Or do they mix them somehow?
>
> .... check out the following:
>
> http://www.zope.org/Members/michel/ZB/RelationalDatabases.dtml
> and
> http://www.zope.org/Documentation/Guides/ZSQL
>
> (the latter is now deprecated but you will find
> http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.4.4.html
> useful in the present context - look for sql_delimiter)
>
> Paul
>
> --
>  The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK
>      E-mail: paul.browning@bristol.ac.uk  URL: http://www.bris.ac.uk/
>
>
> _______________________________________________
> Zope-Dev maillist  -  Zope-Dev@zope.org
> http://lists.zope.org/mailman/listinfo/zope-dev
> **  No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope )
>