From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: SQL generator
Date: Wed, 26 Jul 2006 11:38:17 -0400
Message-ID: <20060726153817.GC23123@phlogiston.dyndns.org> (raw)
In-Reply-To: <bf05e51c0607260821sb45c32n246c4ecafd8bb282@mail.gmail.com>
References: <1153395978.590189.261100@75g2000cwc.googlegroups.com>
<60k661a07f.fsf@dba2.int.libertyrms.com>
<bf05e51c0607260821sb45c32n246c4ecafd8bb282@mail.gmail.com>
On Wed, Jul 26, 2006 at 10:21:01AM -0500, Aaron Bono wrote:
> Bottom line though, just how difficult is SQL to read and write anyway? It
> is a hell of a lot easier to read and write than any other computer language
> I have seen.
It's not SQL. It's the notion of relations. If the language were
QUEL or ENGLISH (a PICK variant) or whatever you have, but relations
underneath, the same problem would be happening.
Remember, even people who ought to understand this stuff, like
developers who program against databases for a living, frequently get
it wrong. I'm not surprised that casual users can accidentally do a
5-way Cartesian product. But it would make no difference if the
commands were specified in natural language, because the conceptual
confusion is the problem.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: SQL generator
In-Reply-To: <20060726153817.GC23123@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox