Saturday, July 26, 2008

[pgadmin-hackers] First public pre-alpha release of GQB (Graphical Query Builder) for pgAdmin

Hi everyone,

I have been working on improve my Google Summer of Code Project: http://wiki.postgresql.org/wiki/Gsoc08-querybuilder  for a while, and today I'm going to release what I believe it's the first public pre-alpha release, as you notice this release is for testing only an i'ts provided with no warranty :)

Now with the project you can:

0. Create a graphical model of a query sentence. (to add a table just double click on it on the left tree, tables are added at same place please move to other position by drag & drop from the title)
1. Create some simple queries involving joins (only equality joins right now), only drag and drop column from one table to another
2. Order the columns in the projection part of sentence (Select x,y,z...), and add columns alias in a grid
3. Add some restrictions (not validate content yet, a parser should be done in next days)
4. Create synonymous for tables just double click on table title an write synonymous on dialog.

I'm hoping for feedback, any ideas, suggestions or bug reporst are important to improve next releases.

Mini-FAQ
Where is located GQB inside pgAdmin?
At SQL Editor in a top tab you can choose between normal editor & gqb.

How looks GQB?
You can check this post at my project blog.
http://gsoc2008-gqb.blogspot.com/2008/07/first-public-pre-alpha-release-of-gqb.html

Can I try it without applying a patch and compiling it?
Yes, download binary (sorry binary for windows only this time) at rapidshare:
http://rapidshare.com/files/132757130/prealpha-test-pgadmin-gqb-july-27.patch.zip.html

Where is located the patch?
http://svn.assembla.com/svn/vsqlbuilder/Jul/27/prealpha-test-gqb-july-27.patch

Regards,
Luis.

No comments: