Skip site navigation (1) Skip section navigation (2)

test report: graphical Query builder

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: test report: graphical Query builder
Date: 2008-07-31 13:57:42
Message-ID: 7be3f35d0807310657h210b7aadwaa17e5b14d2a098b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
OS: Windows XP Sp2
Database PostgreSQL 8.3.3 on localhost (running on windows)


Reports:
- I like the integration via "own tab" to the Query Tool

Missing:
- VIEWs are not available to put into the Graphical Builder.
- I cannot DRAG a table to the builder, have to double click- feels unnatural
- drawn relations should have context menu with "remove" and "info"
(took some time to guess that "del" is the action wanted)

- the font of the tables within Query Builder is TimesRoman,
everything else is something without serifs

- the second table is added atop the fist in the query builder, should
be auto-placed on some empty space

- On double click on a table an dialog happens "Enter an Alias for
table without withspaces[tablename]". Not quite sure what this is
telling me.

- the command "Create SQL" is hidden below "help"

- the created SQL is invalid, as soon as an alias is added to a table.
(alias is used in where clause, but not in from-clause)

- mixed-case alias has to be quoted within PostgreSQL, GQB just pastes it in

- I recommend to transfer join conditions to SQL-Joins, instead of
where (tableONE.field=tableTWO.field)

- I did not find a way to add restrictions

- missing a way to change the order of output columns

- GQB should detect ForeignKey relations between tables and
automatically add them

- the primary key of a dropped table should be marked

- the name of a table should include the schema

- SQL-creation puts spaces on the wrong side of commas
   (otfragen ,otformularfeld ,feuser should be otfragen, otformularfeld, feuser)

- if an alias is given for a table, that alias should be used within
the column-list of the select clause

okay, that are the first test feedbacks! I am eager to check out the
next version,

best wishes and thanks for the work so far,

Harald





-- 
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Stra├če 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!

Responses

pgadmin-hackers by date

Next:From: Milen A. RadevDate: 2008-07-31 14:32:16
Subject: Re: test report: graphical Query builder
Previous:From: Dave PageDate: 2008-07-31 12:30:16
Subject: Google Summer of Code Projects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group