[Phpmyadmin-devel] Long list of notes from meeting with people
Hello, These are some items that came up today from talking with users. I thought some of these points deserve further discussion before opening a feature request or bug report. What do you think of these? 1) User suggestion that we add a link to the Export page to "Save this as default for export preferences". This would probably tie in to the User Preference module somehow since some of these preferences are already set there (or in config.inc.php). ~~This might be nice if it can be done without making things overly complex. 2) User suggestion that we have an SQL formatter. This would be a way to take a long string of SQL and have it pretty-printed without actually running the query. ~~There exist other tools to do this (plus we do it if a query is run) and I don't really see a need to incorporate that functionality here. 3) The same user told us that he does not like the blue row highlight when mousing over a row while browsing. "I already know where my mouse is, I don't need the blue highlight to show me," he said. So we should discuss whether this should be continued or removed. ~~This is configurable already, so he just has to edit his config.inc.php or User Preferences to enable/disable it. 4) The same user again stated that he does not care for the underline style for showing a column with a key (in the Structure tab). The suggestion is to instead put a small key icon in front or behind the name of the column to indicate that it's a key. 5) J.M. suggests that we allow a calendar/time picker in the Monitor window. Once you drag to highlight an area on the chart, a dialog pops up displaying the start and end time plus two checkboxes for picking details about what to display. Those date/time fields do not currently have the date/time picker widget. 6) The resulting data in the Monitor view (after selecting a region/time to focus on) is displayed in a table-like format but is not sortable. J.M. suggests that it should be. 7) Again in the Monitor view, after selecting some amount of time and displaying the logs, a dialog appears saying "Loading logs. Log data loaded. Queries executed in this time span: Select: 10 Total: 10" J.M. said this scrolls and should not scroll. 8) Again thanks to J.M., when in Browse mode and viewing table data, you can apply multiple sort options. The only way to remove a column from the sort is to shift-click it. J.M. suggests that we should have a way to quickly remove all sorting, so that if a user sorts by for instance first name, last name, and actor_id that we can allow them to quickly clear all three sort options in one click. That's all for now. Thank you for your thoughts. ~isaac
Isaac, we are looking for a developer to help us with a cron job out of the concrete 5 backend. Would you be interested in helping us or do you know anyone who can? Donna ________________________________________ From: Isaac Bennetch <bennetch@gmail.com> Sent: 10 May 2014 20:22 To: phpmyadmin-devel@lists.sourceforge.net Subject: [Phpmyadmin-devel] Long list of notes from meeting with people Hello, These are some items that came up today from talking with users. I thought some of these points deserve further discussion before opening a feature request or bug report. What do you think of these? 1) User suggestion that we add a link to the Export page to "Save this as default for export preferences". This would probably tie in to the User Preference module somehow since some of these preferences are already set there (or in config.inc.php). ~~This might be nice if it can be done without making things overly complex. 2) User suggestion that we have an SQL formatter. This would be a way to take a long string of SQL and have it pretty-printed without actually running the query. ~~There exist other tools to do this (plus we do it if a query is run) and I don't really see a need to incorporate that functionality here. 3) The same user told us that he does not like the blue row highlight when mousing over a row while browsing. "I already know where my mouse is, I don't need the blue highlight to show me," he said. So we should discuss whether this should be continued or removed. ~~This is configurable already, so he just has to edit his config.inc.php or User Preferences to enable/disable it. 4) The same user again stated that he does not care for the underline style for showing a column with a key (in the Structure tab). The suggestion is to instead put a small key icon in front or behind the name of the column to indicate that it's a key. 5) J.M. suggests that we allow a calendar/time picker in the Monitor window. Once you drag to highlight an area on the chart, a dialog pops up displaying the start and end time plus two checkboxes for picking details about what to display. Those date/time fields do not currently have the date/time picker widget. 6) The resulting data in the Monitor view (after selecting a region/time to focus on) is displayed in a table-like format but is not sortable. J.M. suggests that it should be. 7) Again in the Monitor view, after selecting some amount of time and displaying the logs, a dialog appears saying "Loading logs. Log data loaded. Queries executed in this time span: Select: 10 Total: 10" J.M. said this scrolls and should not scroll. 8) Again thanks to J.M., when in Browse mode and viewing table data, you can apply multiple sort options. The only way to remove a column from the sort is to shift-click it. J.M. suggests that we should have a way to quickly remove all sorting, so that if a user sorts by for instance first name, last name, and actor_id that we can allow them to quickly clear all three sort options in one click. That's all for now. Thank you for your thoughts. ~isaac ------------------------------------------------------------------------------ Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Dne Sat, 10 May 2014 15:22:06 -0400 Isaac Bennetch <bennetch@gmail.com> napsal(a):
1) User suggestion that we add a link to the Export page to "Save this as default for export preferences". This would probably tie in to the User Preference module somehow since some of these preferences are already set there (or in config.inc.php).
Indeed sounds like an useful way to save the defaults from the export (and possibly import as well) to the user preferences.
2) User suggestion that we have an SQL formatter. This would be a way to take a long string of SQL and have it pretty-printed without actually running the query.
Since we no longer format the SQL in the PHP, but rather use CodeMirror for that, I think it's better to recommend them using same solution as well.
3) The same user told us that he does not like the blue row highlight when mousing over a row while browsing. "I already know where my mouse is, I don't need the blue highlight to show me," he said. So we should discuss whether this should be continued or removed.
I think this is feature many people like and many dislike, not sure if we should do something about that.
4) The same user again stated that he does not care for the underline style for showing a column with a key (in the Structure tab). The suggestion is to instead put a small key icon in front or behind the name of the column to indicate that it's a key.
Having icon might indeed add better visual clue what is there.
5) J.M. suggests that we allow a calendar/time picker in the Monitor window. Once you drag to highlight an area on the chart, a dialog pops up displaying the start and end time plus two checkboxes for picking details about what to display. Those date/time fields do not currently have the date/time picker widget.
Sounds logical thing to do.
6) The resulting data in the Monitor view (after selecting a region/time to focus on) is displayed in a table-like format but is not sortable. J.M. suggests that it should be.
Again looks like useful thing to do.
7) Again in the Monitor view, after selecting some amount of time and displaying the logs, a dialog appears saying "Loading logs. Log data loaded. Queries executed in this time span: Select: 10 Total: 10" J.M. said this scrolls and should not scroll.
Hmm, do we need this as a dialog at all?
8) Again thanks to J.M., when in Browse mode and viewing table data, you can apply multiple sort options. The only way to remove a column from the sort is to shift-click it. J.M. suggests that we should have a way to quickly remove all sorting, so that if a user sorts by for instance first name, last name, and actor_id that we can allow them to quickly clear all three sort options in one click.
Not sure how to do this nicely UI wise... -- Michal Čihař | http://cihar.com | http://phpmyadmin.net
On Wed, May 14, 2014 at 6:44 PM, Michal Čihař <michal@cihar.com> wrote:
8) Again thanks to J.M., when in Browse mode and viewing table data, you can apply multiple sort options. The only way to remove a column from the sort is to shift-click it. J.M. suggests that we should have a way to quickly remove all sorting, so that if a user sorts by for instance first name, last name, and actor_id that we can allow them to quickly clear all three sort options in one click.
Not sure how to do this nicely UI wise...
How about adding "Clear Filters" or "Reset Filters" button similar to "Show All" next to Filter Rows Search box which would reset sort and search string?
-- Michal Čihař | http://cihar.com | http://phpmyadmin.net
-- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/
On 5/14/14 11:21 AM, Chirayu Chiripal wrote:
On Wed, May 14, 2014 at 6:44 PM, Michal Čihař <michal@cihar.com <mailto:michal@cihar.com>> wrote:
> 8) Again thanks to J.M., when in Browse mode and viewing table data, you > can apply multiple sort options. The only way to remove a column from > the sort is to shift-click it. J.M. suggests that we should have a way > to quickly remove all sorting, so that if a user sorts by for instance > first name, last name, and actor_id that we can allow them to quickly > clear all three sort options in one click.
Not sure how to do this nicely UI wise...
How about adding "Clear Filters" or "Reset Filters" button similar to "Show All" next to Filter Rows Search box which would reset sort and search string?
I like the idea but wonder if there's a better location for it. I don't, however, have any better suggestion at the moment.
-- Michal Čihař | http://cihar.com | http://phpmyadmin.net
-- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/
On 5/14/14, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Sat, 10 May 2014 15:22:06 -0400 Isaac Bennetch <bennetch@gmail.com> napsal(a):
7) Again in the Monitor view, after selecting some amount of time and displaying the logs, a dialog appears saying "Loading logs. Log data loaded. Queries executed in this time span: Select: 10 Total: 10" J.M. said this scrolls and should not scroll.
Hmm, do we need this as a dialog at all?
I think, as the log results table is displayed on the same page below the chart area, so we need to provide a hint to the user that he needs to scroll down to see the log results and the dialog provides a "Jump to logs" button for that purpose. So either we keep the dialog as it is or we can remove it and do an automatic scroll downwards as results are loaded. I would prefer the dialog as a hint over auto-scrolling. -- Atul Pratap Singh http://blog.atulsisodia.in/
participants (5)
-
Atul Pratap Singh -
Chirayu Chiripal -
Donna Ferreira -
Isaac Bennetch -
Michal Čihař