Manraj Grover a écrit :
Hi
I would like to extend the functionalities of the present Console in phpMyAdmin as a part of GSoC project. I was testing current one and found the following issues:
Hi, thanks for sharing your idea.
UI improvements:
The option tab and console pointer are too far away from each other
leading to great mouse traversing time. It should be close enough and not at the other end given a lot of space is available to use.
Keyboard use: Escape to close is another thing missing(Minute fix) On clicking "Options" a huge div for settings open. Given options are
currently low in number and there is not a lot of text to show, it should be reduced.Again it increases mouse traversing time.
Currently the console is used for SQL queries. I would like to propose following additions to it.
Introduction of version control. (git like feature)
This is a much needed change. How many times it has happened one single query and your data is lost forever? This is help keep track of previously saved version of database as a backup so that user can restore and start working on it if and when required.
Where do you plan to keep the backup? In the database itself, I guess? If so, how will this scale?
And do you plan an automatic save?
Regarding this feature, are you aware that phpMyAdmin already has a tracking mechanism?
http://docs.phpmyadmin.net/en/latest/config.html?highlight=tracking#cfg_Serv...
Introduction of opening tabs and filling fields using console
Again another feature that gives console power to do things.
Introduction of "help" command
It will help users how to use console for example one can execute "help" for complete help or "help select" to know the details
Run, preview and then only apply changes to database
Another safety feature that can be included in console making console more powerful.
The possibilities are endless. Lets discuss this over and create a working model.
Regards, Manraj Singh Grover Secretary, IEEE NSIT Connect on LinkedIN http://in.linkedin.com/in/manrajsinghgrover/ Ph. +91-9811040427