Javascript MySQL GUI Client Tool

The Planche is MySQL GUI client tool. This tool has a flexible structure to use. Basically, the operation through the tunneling. The current version is under development. So it may not work properly. The project has been developed, including the following JavaScript frameworks.

• CodeMirror
• Sencha ExtJS 4.2

• Planche Demo

1. Need php or nodejs environment for execute tunneling file.
2. Apache Web Server(optional) -> Tunneling file has its own web server.

• Execute Query : like a desktop application
• Query Editor : like a desktop application
• Query Alignment : Yet it acts like a fool.
• Support delimiter
• Table schema view
• Auto query result paging(by limit)
• Create, Alter, Drop, Refresh Procedure
• Create, Alter, Drop, Refresh View
• Create, Alter, Drop, Refresh Function
• Create, Alter, Drop, Rename, Refresh Event
• Create, Alter, Drop, Rename, Refresh Trigger
• Create, Alter, Drop, Empty, Truncate, Refresh Database
• Create, Alter, Drop, Truncate, Refresh Table
• Query tokenize.
• Process Manager, Kill Process
• Schema Edit Window
• Show Variables Window
• Show Status Window
• Paste SQL Statement(Insert, Update, Delete, Select)

1. Download planche-master.zip on your PC
2. Extract the zip file
3. Add host's information on the "resources/config/host.js" file

Planche.config = {
    hosts : [
        {
            hostName    : 'My Host',
            tunnelingURL: 'http://localhost:8888',
            requestType : 'jsonp',
            host        : 'localhost',
            user        : 'user',
            pass        : 'password',
            charset     : 'utf8',
            port        : 3306,
            dbms        : 'mysql'
        }
    ]
}

4. Run the index.html file on your browser. (Yet recommend Chrome. I did not test other browsers. You can break your head.)

Run the "tunneling file" at CLI mode. (Attention) When exposed uploaded tunneling files. Security issues may arise. I hope you remember this problem for the database server.

• PHP Environment

[user@localhost ~]$ ./planche php [localhost] [port]

• nodeJS Environment

[user@localhost ~]$ ./planche nodejs [localhost] [port] 

http://www.youtube.com/embed/WCnXJXDRlYs

http://plancheproject.github.io

This content is released under the GPL v3