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
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 |