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@xxxxxxxxxxxxxx)
---------------------------(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
