#1687 Multi-query persistent console with tabbed results?
This is my first ever request on SourceForge, I can't see anything similar in the feature requests. So...
I'm really struggling to use PhpMyAdmin as effectively and efficiently as I can use a console. Until recently I had database console access via PhpStorm but with recent business-wide security changes this was taken away and we now must all use PhpMyAdmin.
Is there any way to get PhpMyAdmin to behave more like a serious console-based database management system? For example, SQLyog or the database console in PhpStorm.
I use PhpStorm for development and having to switch back and forth between that IDE and a web-based interface is very slow and clumsy. Also, when I run a query it'd be nice to be able to have just one persistent query window that retains the data between browser sessions (save locally?) and results from each query appear in tabbed areas beneath the main query window.
Is there (could there be) some sort of API that PhpStorm could plug into?
Hi,
before asking more details about your needs, which phpMyAdmin version are you using? Assuming you are not up to date, did you try the Console feature in the current version (available on demo.phpmyadmin.net) ?
If you mean the SQL query window - yes, I've used that and it works the same as it does on our current versions but with a few more bells and whistles.
The versions differ between servers, from 2.10.2-rc1 on our server for legacy sites, 3.4.9 for most sites and 5.1.69 for our newest sites. These may be getting updated soon.
No I mean the Console link at the very bottom of the main panel. The 5.1.69 version you are citing is not a phpMyAdmin version.
Ah, didn't spot that. My mistake, the version was the MySQL version. The PhpMyAdmin versions are 3.4.1 and 3.4.9 - neither have the console link at the bottom (or anywhere).
The console is closer to what I need but still quite a way off and seems to work similarly to the existing query window.
What I'm after is a single text window much like notepad, queries can appear on multiple lines and can be freely executed all together, in groups or individually. The queries are persistent between sessions and the results appear in a new tab next to any existing results tabs. Running three queries means there are three results windows, if I want to re-run an earlier query I move the cursor back up to that query and click on 'Run' or use the CTRL+Enter keyboard short cut.
Do you have PhpStorm? Have you used that database console? That's how I want it to work but I can't use it any more due to a business decision so I'm stuck with PhpMyAdmin and I'm struggling to adapt when I had so much freedom with the PhpStorm database console.
I don't have the commercial product PhpStorm. Note that we have to be prudent about copying features present in a commercial product, due to intellectual property issues.
It's a common layout, I doubt very much that there would be any copyright issues. This type of layout is also present in SQLyog and MySQL Workbench.