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
On 5/15/14, Atul Pratap Singh <atulpratapsingh05(a)gmail.com> wrote:
> On 5/10/14, Isaac Bennetch <bennetch(a)gmail.com> wrote:
>> Hello,
>>
>> 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.
>>
>> 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.
>>
Added in https://github.com/phpmyadmin/phpmyadmin/commit/1a3c958f394e1aa214321b3f4a8…
--
Atul Pratap Singh
http://blog.atulsisodia.in/
Hi,
I have few doubts about this feature. Should it open dialog when clicked on
link shown in :
1) 1.png (i.e. some foreign value) or
2) 2.png (i.e. when clicked on "Browse foreign values") or
3) Both of them.
--
Regards,
Chirayu Chiripal
phpMyAdmin Intern - Google Summer of Code 2014
https://chirayuchiripal.wordpress.com/