Ext.ux.window.VisualSQLQueryBuilder

[martinorth]

At http://www.cfsolutions.de/qb/ you will find a first beta of a visual sql query builder plugin. It is possible to drag and drop tables to the left area and to define joins between the tables via drag and drop. I have startet generating the resulting sql for mysql.

The source is not encrypted anymore. So feel free to use the source as it is.

qb.jpg
Save and run will not work yet. Try it yourself or take a look at this YouTube Video http://www.youtube.com/watch?v=QJwlEry_ER4 to see the plugin in action.

Todo:

join context menu- edit / delete join
join tooltip - show join info

column grouping
column order
agregate functions combobox
support for different database dialects / versions

[predator]

Looks very interesting.

[scottmartin]

Looks good. Keep up the good work.

Regards,
Scott.

[dawesi]

nice one

[martinorth]

I have updated the youtube video and the working prototype at http://www.cfsolutions.de/qb/

[another_i]

BUG REPORT:
When I click on bestellpos and after that on produkt it's crashed with error:

Uncaught Error: SYNTAX_ERR: DOM Exception 12

Selection_005.jpg


Chrome Version 19.0.1084.52

[martinorth]

@another_i It seems to be a obusfactor problem. The non obusfactored version is running fine with chrome. At the moment the public beta is obusfactored until I have made a decision wich license I want to use. Try it with firefox to test the plugin right now.

[hendrisoni]

hi, i make something similar. but I focus to PostgreSQL. because I took the code from all friends here. I'll upload it later on this website.

DDL.jpg
Query Builder As.jpg

[martinorth]

@hendrisoni Looks verry good!

[javierdurante]

Is this going to be an open source plugin? I would really like to help with this
thanks