Thread: Graphical Query Builder enhancement

Graphical Query Builder enhancement

From
Roland Giesler
Date:
I'd like to know what the immediate plans are for this welcome
addition to pgadmin.

Currently one can only create select queries with it and the query are
in by opinion less correct than they should be.   Linking two fields
together creates a where clause instead of a table join and surely
there is a substantial difference?

What I'd like to see is the following:

1. The ability to create SELECT, INSERT, UPDATE and DELETE queries
2. The ability to "parse" an existing query and display it graphically
3. Save the graphical query layout in some format that can be reloaded
later and possibly be stored in the database.

Is there some way in which a bounty can be offered here?

regards

Roland Giesler, CEO

Green Tree Systems Trust
Stellenbosch, South Africa

Re: Graphical Query Builder enhancement

From
Guillaume Lelarge
Date:
Le 19/12/2010 13:05, Roland Giesler a écrit :
> I'd like to know what the immediate plans are for this welcome
> addition to pgadmin.
>

AFAIK, none.

> Currently one can only create select queries with it and the query are
> in by opinion less correct than they should be.   Linking two fields
> together creates a where clause instead of a table join and surely
> there is a substantial difference?
>

This is one way to do a join. But you're right there are many others.

> What I'd like to see is the following:
>
> 1. The ability to create SELECT, INSERT, UPDATE and DELETE queries
> 2. The ability to "parse" an existing query and display it graphically
> 3. Save the graphical query layout in some format that can be reloaded
> later and possibly be stored in the database.
>
> Is there some way in which a bounty can be offered here?
>

You would need to find someone to code this. Perhaps Luis Ochoa, who
already wrote the QGB, would be interested. But you'll need to deal
directly with him.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com