Thread: Usability

Usability

From
Paul Rogers
Date:
Pgadmin is a very solid tool but it requires a lot of clicking for  
the most common tasks. Please consider the following ideas.

Edit Grid:
* An option to hide the data-type from the column headings would save  
screen space. It seems to add very little.
* An option to left justify the column name. When the column is too  
narrow its difficult to recognize the name using only the middle  
letters.
* Adding an 'X' button to column headings, to hide a column or filter  
it out, would really make the grid more useful when trying to examine  
and compare certain columns.
* A filter input box along the top of the grid, similar to  
CocoaMySQL's filter options, would make finding specific data faster  
and easier. I prefer the power of pgAdmin's current filter system  
over CocaMySQL, its just difficult to find the pgAdmin filter and  
getting there involves so many extra steps.
* One-click sorting by clicking a column heading and perhaps a right- 
click option to 'sort 1st', 'sort 2nd', 'sort 3rd', 'move up sort  
order', 'move down sort order', 'sort next', 'sort previous', etc.
* A visual indicator to show which columns are involved in sorting.  
An arrow pointing up or down would help. Perhaps the indicator could  
be more translucent or a different shade when as the column moves  
down the sorting order.
* I've always wanted a grid view which preserves the widths of  
columns after they've been changed (like a spreadsheet document).  
Perhaps the preferences could be added as a column comment or stored  
in the application preferences. In most cases it would be most useful  
if the setting was associated with a specific column name and not one  
instance of a column. For example, I manage many databases and  
different tables that all store e-mail addresses. And while the  
columns may not all have identical definitions they all require more  
then the standard width.
* Saved 'views': some way to save and restore collections of the  
above mentioned settings for a table: preferred sort order, filter 
(s), and column widths. I realize PostgreSQL has explicit view  
objects for this purpose so perhaps associating the preferred-column  
width with a view is enough.

Server Connection Properties:
* An option to automatically expand and open a certain database,  
schema, and table/view after connecting to a server. Currently,  
getting to the data involves many clicks after the connection is  
made. Perhaps one could choose to open a certain cast, domain,  
function, operator or other resource. Tables and views are far and  
away the most commonly accessed resource for me.

Paul Rogers