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