|
Home > Archive > PostgreSQL Discussion > April 2005 > Query Designer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Carlos Gustavo Fischer 2005-04-26, 8:23 pm |
| Hello, people.
I´m looking for a FREE tool where you can VISUALLY link tables and
mark fields and the tool
generates the query automatically.
I´ve tried PGExplorer. It´s nice, but it doens´t create "JOINS", just
a lot of WHERE... =...AND...=...AND...
Do you people have any tips ??
Thanks in advance,
Carlos G. Fischer
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)
| |
| Hannes Dorbath 2005-04-27, 3:23 am |
| The SQL generated by tools like that is mostly neither performant nor
readable in particular.
Better learn basic SQL and use an editor with keyboard templates. That
way you'll be writing your statements even faster than cicking arround
in some stupid GUI ;)
And yes, PGExplorer is the only FREE query builder I know off as well.
There are several commercial..
> a lot of WHERE... =...AND...=...AND...
Maybe it creates implicit joins?
On 26.04.2005 21:35, Carlos Gustavo Fischer wrote:
> Hello, people.
>
> I´m looking for a FREE tool where you can VISUALLY link tables and
> mark fields and the tool
> generates the query automatically.
>
> I´ve tried PGExplorer. It´s nice, but it doens´t create "JOINS", just
> a lot of WHERE... =...AND...=...AND...
>
> Do you people have any tips ??
>
> Thanks in advance,
> Carlos G. Fischer
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)
>
| |
| Sean Davis 2005-04-27, 7:23 am |
| Particularly if you have a set of queries that are used often, you
could certainly build a framework for doing this. See:
http://genome.ucsc.edu/cgi-bin/hgTables
as an example. There are many others, I would imagine. Perl, ruby,
and probably Java and python offer database abstraction tools that make
are "aware" of the foreign key structures linking tables, so building
an app that capitalizes on this could allow you to build such a "query
builder", but this problem is a hard one to do generally, I think.
Sean
On Apr 27, 2005, at 3:59 AM, Hannes Dorbath wrote:
> The SQL generated by tools like that is mostly neither performant nor
> readable in particular.
>
> Better learn basic SQL and use an editor with keyboard templates. That
> way you'll be writing your statements even faster than cicking arround
> in some stupid GUI ;)
>
> And yes, PGExplorer is the only FREE query builder I know off as well.
> There are several commercial..
>
>
> Maybe it creates implicit joins?
>
>
> On 26.04.2005 21:35, Carlos Gustavo Fischer wrote:
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
|
|
|