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

[The Doctor What]

--vOmOzSkFvhd7u8Ms
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* 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?
>=20
> Near as I can tell, between:
> * Broken type marshalling
> * Loosing the variable between the form and dtml-if
> * Inability to handle table.field names for variables
> * And enough flexibility to work around the above problems
>=20
> This makes ZSQL extreamely nasty, and impossible to use with a
> normalized database.
>=20
> What's the point?  ZSQL sucks, how do I talk to the DB directly?
>=20
> Yeah, I keep almost getting this to be useful.  But damn it if I
> don't keep hitting a brick wall.  And there are no complete examples
> or demos that I can find to load up.
>=20
> Irritatedly yours,
>         DocWhat

I would like to apologize for being particularly pissy.  Things are
quite as bad as I say up there...

My third point is only half true.  I can have SQLTEST specify a
column name (aka a field):
<dtml-sqltest somevarname column=3D"SQLTABLE.sqlfield" type...>

This makes things work MUCH better.  So there are work arounds.  But
this doesn't excuse this not working:
SELECT  table.field1, table.field2 FROM ....

and then:
<dtml-var name=3D"table.field1">  <--doesn't work
<dtml-var name=3D"field1"> <-- does work

I know that the '.' has a special meaning, but there should be ways
around this if the use wants.

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?

Ciao!


--=20
Who are you going to believe, me or your own eyes?
	-- Groucho Marx

The Doctor What: Need I say more?                http://docwhat.gerf.org/
docwhat@gerf.org                                                   KF6VNC

--vOmOzSkFvhd7u8Ms
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE63yfFkJDks3INMZURAhGZAKCIOLgtFflT/8EISxRUVZ1Q+EZSUQCdHyqA
XjtiawwkgBZH2YckGMAEXnA=
=mD9b
-----END PGP SIGNATURE-----

--vOmOzSkFvhd7u8Ms--