Re: Query Designer

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

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(at)postgresql(dot)org)
>

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..
>
>> 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(at)postgresql(dot)org)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>