Hybrid View

  1. #1
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34
    Vote Rating
    3
    martinorth is on a distinguished road

      2  

    Default Ext.ux.window.VisualSQLQueryBuilder

    Ext.ux.window.VisualSQLQueryBuilder


    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
    Attached Images

  2. #2
    Sencha Premium Member
    Join Date
    Mar 2010
    Posts
    141
    Vote Rating
    14
    predator will become famous soon enough

      0  

    Default


    Looks very interesting.

  3. #3
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    9,247
    Vote Rating
    485
    scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute scottmartin has a reputation beyond repute

      0  

    Default


    Looks good. Keep up the good work.

    Regards,
    Scott.

  4. #4
    Sencha Premium Member dawesi's Avatar
    Join Date
    Mar 2007
    Location
    Melbourne, Australia (aka GMT+10)
    Posts
    1,090
    Vote Rating
    56
    dawesi has a spectacular aura about dawesi has a spectacular aura about

      0  

    Default


    nice one
    Lead Trainer / Sencha Specialist
    Teahouse Training Company

    Comprehensive Javascript, Sencha and 3rd Party Stack Training available worldwide online, and onsite in APAC, written by certified official Sencha trainers.



    Unofficial Sites:

    SenchaWorld.com - Videos, and stuff
    Sencha.Community - Tools, Extensions and Resources
    TeahouseHQ.com - Sencha Ecosystem Training Portal

    Code Validation : JSLint | JSONLint | JSONPLint

  5. #5
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34
    Vote Rating
    3
    martinorth is on a distinguished road

      0  

    Default


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

  6. #6
    Sencha User
    Join Date
    Jul 2011
    Location
    Russia
    Posts
    41
    Vote Rating
    3
    another_i is on a distinguished road

      0  

    Default


    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