Re: interface for "non-SQL people"

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: pere roca <peroc79(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: interface for "non-SQL people"
Date: 2009-10-08 20:22:26
Message-ID: b42b73150910081322v233eb33es534f963aa1fec2dc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 6, 2009 at 3:47 PM, pere roca <peroc79(at)gmail(dot)com> wrote:
>
>
>  hi,
>  some nice tool over there to let non-SQL knowing people to construct their
> queries? I'm using pgAdmin III but I know some SQL.
>  there is no other option than constructing an HTML with forms, drop-down
> menus...?

Cant help it :-) but:

The #1 tool you have at your disposal is the human brain. I
personally think GUI database tools are counter productive and huge
time wasters. SQL requires lateral thinking but once you have your
head around how joins work and the general syntax of queries you
should have no problem getting data out of your database. SQL is a
'man machine interface' :-). It's a very high level language with a
lot of power. The gui 'wrappers' that I've seen actually obfuscate
the concepts.

merlin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kalsch 2009-10-08 20:30:43 Using pg_catalog to define things across schemas
Previous Message Thom Brown 2009-10-08 20:20:32 Re: Renaming constraints