Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Thread: Ext.ux.window.VisualSQLQueryBuilder

  1. #1
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34

    Default 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 Attached Images
    • File Type: jpg qb.jpg (25.0 KB, 1344 views)

  2. #2
    Sencha Premium Member
    Join Date
    Mar 2010
    Posts
    150

    Default

    Looks very interesting.

  3. #3
    Sencha - Support Team scottmartin's Avatar
    Join Date
    Jul 2010
    Location
    Houston, Tx
    Posts
    9,409

    Default

    Looks good. Keep up the good work.

    Regards,
    Scott.

  4. #4
    Sencha Premium User dawesi's Avatar
    Join Date
    Mar 2007
    Location
    Melbourne, Australia (aka GMT+10)
    Posts
    1,224

    Default

    nice one
    Cloud Application Architect

    Sencha Specialist / Sencha MVP / Sencha Technical Trainer
    ExtJs Developer + Contributor since 0.2.2 - Champion of the per developer license.

  5. #5
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34

    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

    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


  7. #7
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34

    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.

  8. #8
    Sencha User
    Join Date
    Jul 2011
    Location
    indonesia
    Posts
    6

    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

  9. #9
    Ext JS Premium Member
    Join Date
    Jul 2008
    Location
    Germany
    Posts
    34

    Default

    @hendrisoni Looks verry good!

  10. #10

    Default

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

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •