Anyone who has used phpmyadmin’s query window knows how frustratingly small the textarea is, and how difficult editing SQL query blocks can be. I wrote a Greasemonkey script to de-suck this query window. As of now, Greased PMA is version 0.1 and has the following features:
- Automatic resizing of the textarea to make best use of the window size
- Ctrl+Enter submits the query
- Tab inserts 4 spaces into the query
Click here to download Greased PMA version 0.1.
Update: While messing around at home on Vista / Chrome, I noticed that Greased PMA partially works on Chrome. I wasn’t expecting this to work outside of Firefox / Greasemonkey, but Chrome has a similar extension feature, it seems. The textarea resizing works, but the Ctrl+Enter submitting query and tab modification do not work. Perhaps this weekend I will debug those two functions on Chrome.
#1 by Brian Wood at July 12th, 2010
I am wrong. It is working. I just forgot that it only works in the popup window *querywindow.php.
I was just trying to make it work for *phpMyAdmin/index.php* Should that be possible?
#2 by visual77 at July 12th, 2010
Good to know. I’ll look into it later tonight to see if it is still working.
#3 by Brian Wood at July 12th, 2010
I noticed that this stopped working with the latest FF update to 3.6.6. I disabled/enabled greasemonkey and reinstalled this script. Maybe it’s something specific to my browser…hmm. Still working for you?
#4 by Brian Wood at June 3rd, 2010
You were my first google hit and my problem was solved in < 5 min. Why can't it always be like this? Thanks!
#5 by Alexander Nyquist at May 28th, 2010
This is so awsome! Thanks for stripping the suck!