[Phpmyadmin-devel] Extending Console Functionality

[Marc Delisle]

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_Servers_tracking


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



-- 
Marc Delisle (phpMyAdmin)