Re: interface for "non-SQL people" - Mailing list pgsql-general

From Merlin Moncure
Subject Re: interface for "non-SQL people"
Date
Msg-id b42b73150910081322v233eb33es534f963aa1fec2dc@mail.gmail.com
Whole thread Raw
In response to interface for "non-SQL people"  (pere roca <peroc79@gmail.com>)
Responses Re: interface for "non-SQL people"
List pgsql-general
On Tue, Oct 6, 2009 at 3:47 PM, pere roca <peroc79@gmail.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

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Renaming constraints
Next
From: Andreas Kalsch
Date:
Subject: Using pg_catalog to define things across schemas