[Phpmyadmin-devel] Regarding Feature request: #532 Multiple DB sql query
Hi, This is about a feature request <https://sourceforge.net/p/phpmyadmin/feature-requests/532/> for choosing database(s) to apply a sql query.I think we should add a drop-down near (aside clear/format buttons) query box for same. But this can be a problem if the user have access to thousand number of databases. So,One of the solution I thought would be to keep it under configuration file for showing it or not and another solution can be by simply limiting number of databases (say 10) for showing the same. However it can increase some work for the user so I need suggestions for it's implementation. Thanks and Regards. -- Rakesh Kumar-B.Tech CSE ,ISM Dhanbad
Rakesh Kumar a écrit :
Hi, This is about a feature request <https://sourceforge.net/p/phpmyadmin/feature-requests/532/> for choosing database(s) to apply a sql query.I think we should add a drop-down near (aside clear/format buttons) query box for same. But this can be a problem if the user have access to thousand number of databases. So,One of the solution I thought would be to keep it under configuration file for showing it or not and another solution can be by simply limiting number of databases (say 10) for showing the same. However it can increase some work for the user so I need suggestions for it's implementation. Thanks and Regards.
We can safely show more than 10 database names in a drop-down (with multiple select option); I don't expect a problem by showing, say, 50 database names, but more than that, we could show an input field so that the user can type the database names on which to apply the query. -- Marc Delisle (phpMyAdmin)
On 2/17/15 9:09 AM, Rakesh Kumar wrote:
Hi, This is about a feature request <https://sourceforge.net/p/phpmyadmin/feature-requests/532/> for choosing database(s) to apply a sql query.I think we should add a drop-down near (aside clear/format buttons) query box for same. But this can be a problem if the user have access to thousand number of databases.
I'm not really in favor of this, though my opinion is not strong on the matter. I think it's adding clutter to the user interface for a feature few users will need; besides there are several ways of accomplishing basically the same although with perhaps an extra click or two. For instance, "Show this query here again" is persistent if changing databases; there's also the possibility to bookmark a query or simply copy and paste code. While I see how it could be useful to some users some of the time, I would vote no.
So,One of the solution I thought would be to keep it under configuration file for showing it or not and another solution can be by simply limiting number of databases (say 10) for showing the same. However it can increase some work for the user so I need suggestions for it's implementation. Thanks and Regards.
I'm against adding a configuration option about whether to show it; I might be willing to add one to configure how many databases to show (in which case we might make 0 "hide this option entirely").
Isaac Bennetch a écrit :
On 2/17/15 9:09 AM, Rakesh Kumar wrote:
Hi, This is about a feature request <https://sourceforge.net/p/phpmyadmin/feature-requests/532/> for choosing database(s) to apply a sql query.I think we should add a drop-down near (aside clear/format buttons) query box for same. But this can be a problem if the user have access to thousand number of databases.
I'm not really in favor of this, though my opinion is not strong on the matter. I think it's adding clutter to the user interface for a feature few users will need; besides there are several ways of accomplishing basically the same although with perhaps an extra click or two. For instance, "Show this query here again" is persistent if changing databases; there's also the possibility to bookmark a query or simply copy and paste code. While I see how it could be useful to some users some of the time, I would vote no.
After reading Isaac's comment, I am joining his side; this is probably an edge feature and we should reject it. -- Marc Delisle (phpMyAdmin)
Yes,I also think that this would be an unnecessary extra load to PMA.we should leave it. Thanks, On 17 February 2015 at 23:23, Marc Delisle <marc@infomarc.info> wrote:
Isaac Bennetch a écrit :
On 2/17/15 9:09 AM, Rakesh Kumar wrote:
Hi, This is about a feature request <https://sourceforge.net/p/phpmyadmin/feature-requests/532/> for choosing database(s) to apply a sql query.I think we should add a drop-down near (aside clear/format buttons) query box for same. But this can be a problem if the user have access to thousand number of databases.
I'm not really in favor of this, though my opinion is not strong on the matter. I think it's adding clutter to the user interface for a feature few users will need; besides there are several ways of accomplishing basically the same although with perhaps an extra click or two. For instance, "Show this query here again" is persistent if changing databases; there's also the possibility to bookmark a query or simply copy and paste code. While I see how it could be useful to some users some of the time, I would vote no.
After reading Isaac's comment, I am joining his side; this is probably an edge feature and we should reject it.
-- Marc Delisle (phpMyAdmin)
------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Rakesh Kumar-B.Tech CSE ,ISM Dhanbad
participants (3)
-
Isaac Bennetch -
Marc Delisle -
Rakesh Kumar