test report: graphical Query builder

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!