Hi Pranavan,
On Thursday 13 October 2016 09:41 PM, Pranavan New wrote:
Earlier I thought there is no way to record the query history in phpMyAdmin and then after a good amount of surfing, I found and got to know about pma_history relation residing under phpMyAdmin database.
But still I feel it's not much user friendly because whenever we want to know what queries we issued recently and to re-execute the same queries(for select queries), we always want to go to this particular pma_history table, copy the query and then comeback to the place where we are working, paste and execute which is little troublesome for the user. I myself found it difficult many times to do this continuously. A research by 'Mark Sanderson' and 'Susan Dumais' on "Examining Repetition in User Search Behavior" found that 33% of user queries were repetitions of queries previously issued by the same user. This not only applicable for web surfing but also for database querying required in other applications as well.
Therefore it's better to have an easy way to access the history of the past queries and further having a way to directly re-execute an already executed select query. I suggest to have an additional tab in table level GUI of phpMyAdmin by clicking which user will be able to view and further re-execute (if he/she needs to) a past query again easily(If it is possible). Also a user will be able to filter query history to extract queries only related to a table.
Thanks for your interest in the project and its development. :-)
About the mentioned feature, I am not sure how much similar is this to what you intend to do through this feature but phpMyAdmin already has query history (that you mentioned from pma_history table) visible and accessible in the console.
Moreover, the queries that user wants to repeatedly run can be stored as Bookmarked queries (available on the SQL query tabs) and then can be retrieved from SQL tabs as well as the console and run.
I have already started working on this feature and almost at the end of the development process.This mail is to discuss whether what I feel is feasible and to get suggestions from you all.
We always welcome new contributors and new feature requests, but it would be better to discuss (may be on the issue tracker or mailing list) and fine tune the idea before starting to actually implement it.
Hope it helped to answer your queries.
Regards, Deven Bansod