One of the features I like about phpMyAdmin is that when doing a SELECT, the result set rows are editable, row(s) can be deleted and more. This saves time. The equivalent in Execute SQL means having to do a select, an UPDATE or a DELETE, which is more prone to errors.
Please consider making the Execute SQL more user friendly. An added benefit would be less people would have to install phpMyAdmin if they prefer using a GUI over command line SQL.
I never use phpMyAdmin. I either user the Webmin module or the command line client.
We’d like to make the Webmin module nice to use for any common use case. If you consider it completely out of the question that someone might want to use it for anything phpMyAdmin is used for means we probably ought to be working on it.
@Joe
Well if someone wants to use the GUI then most likely the CLI is not something they want to try
Hey all in for improvements in the Webmin module as I like to keep work enclosed into the framework I’m using.
I just meant from a user perspective many look for phpMyAdmin to be installed but hey if a Virtualmin host can say “na we have something built in already” I’m all thumbs up
Sorry, yes I mean the module that’s available in Webmin and Virtualmin. I just called it Execute SQL because that’s the link from the MariaDB Database Server module.
other database systems/applications are available I rather like to keep them all managed externally. especially GUI based I am a system manager, if I want a DB manager I’ll recruit one, meanwhile I can use phpMyAdmin, phpPgAdmin or another non php tool.
That would be cool, although generating the SQL to edit a row in response to a complex query would be pretty tricky to get right! And in fact impossible in some cases.
