Re: SQL generator

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: SQL generator
Дата
Msg-id 20060726153817.GC23123@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: SQL generator  ("Aaron Bono" <postgresql@aranya.com>)
Список pgsql-sql
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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Aaron Bono"
Дата:
Сообщение: Re: SQL generator
Следующее
От: "Andrew Hammond"
Дата:
Сообщение: Re: Rows with exclusive lock