1. 23 May 2012 3:02 PM #1
    martinorth
    martinorth is offline
    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
    Reply With Quote Reply With Quote
  2. 23 May 2012 6:14 PM #2
    predator
    predator is offline
    Sencha User
    Join Date
    Mar 2010
    Posts
    88
    Vote Rating
    0
    predator is on a distinguished road
      0  

    Default


    Looks very interesting.
    Reply With Quote Reply With Quote
  3. 24 May 2012 7:57 AM #3
    scottmartin
    scottmartin is offline
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    7,185
    Vote Rating
    194
    scottmartin is a splendid one to behold scottmartin is a splendid one to behold scottmartin is a splendid one to behold scottmartin is a splendid one to behold scottmartin is a splendid one to behold scottmartin is a splendid one to behold scottmartin is a splendid one to behold
      0  

    Default


    Looks good. Keep up the good work.

    Regards,
    Scott.
    Reply With Quote Reply With Quote
  4. 25 May 2012 3:22 PM #4
    dawesi
    dawesi is offline
    Sencha - Sales Team dawesi's Avatar
    Join Date
    Mar 2007
    Location
    Melbourne, Australia (aka GMT+10)
    Posts
    738
    Vote Rating
    6
    dawesi will become famous soon enough
      0  
    Send a message via ICQ to dawesi Send a message via AIM to dawesi Send a message via MSN to dawesi Send a message via Yahoo to dawesi Send a message via Skype™ to dawesi

    Default


    nice one
    Check out SenchaWorld.com for articles, screencasts, conference videos and more.

    Sencha Technical Training : Asia Pacific Region

    Code Validation : JSLint | JSONLint | JSONPLint
    Reply With Quote Reply With Quote
  5. 2 Jun 2012 4:04 AM #5
    martinorth
    martinorth is offline
    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/
    Reply With Quote Reply With Quote
  6. 3 Jun 2012 10:44 PM #6
    another_i
    another_i is offline
    Sencha User
    Join Date
    Jul 2011
    Location
    Russia
    Posts
    39
    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

    Reply With Quote Reply With Quote
  7. 4 Jun 2012 1:08 AM #7
    martinorth
    martinorth is offline
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34
    Vote Rating
    3
    martinorth is on a distinguished road
      0  

    Default


    @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.
    Reply With Quote Reply With Quote
  8. 4 Jun 2012 10:24 AM #8
    hendrisoni
    hendrisoni is offline
    Sencha User
    Join Date
    Jul 2011
    Location
    indonesia
    Posts
    4
    Vote Rating
    1
    hendrisoni is on a distinguished road
      1  

    Default


    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
    Reply With Quote Reply With Quote
  9. 4 Jun 2012 12:39 PM #9
    martinorth
    martinorth is offline
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34
    Vote Rating
    3
    martinorth is on a distinguished road
      0  

    Default


    @hendrisoni Looks verry good!
    Reply With Quote Reply With Quote
  10. 8 Aug 2012 10:14 AM #10
    javierdurante
    javierdurante is offline
    Sencha User
    Join Date
    Aug 2012
    Posts
    1
    Vote Rating
    0
    javierdurante is on a distinguished road
      0  

    Default


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