Re: [Design Update] Visual design of query editor and results table

Hi

On Wed, Apr 12, 2017 at 4:20 PM, Shirley Wang <swang(at)pivotal(dot)io> wrote:

> Hello!
>
> Our team is starting to work on changes to the results table, including:
>
> 1. changing unselected columns and row colors to grey
>

I'd like to see the entire window to see if that seems to make things too
flat, but no objection to a colour change in principal.

> 2. changing selected columns and rows to blue
>

OK.

> 3. differentiating header text so that field name is bold and datatype is
> in brackets
>

Not sure about the brackets - for example, it might look weird with array
types, e.g.

[character varying(50)[]]

Given that the column name is in bold, and the type isn't, perhaps the
brackets should be omitted?

> 4. text is white when columns are selected
>

OK.

> 5. removing checkboxes in each cell
>

\o/

> 6. adding a triangle indicator for select all (top left corner)
>

I like it.

>
> Clicking a single cell inside the table will unselect everything else and
> only select that cell.
>
> Here is an updated version of the table:
> [image: Screen Shot 2017-04-12 at 11.11.15 AM.png]
>
> Please review these changes and provide feedback. We would like to
> implement them this week.
>
>
> Thanks!
>
> On Thu, Apr 6, 2017 at 11:27 AM Shirley Wang <swang(at)pivotal(dot)io> wrote:
>
>> Ok! Right justified it is
>>
>> On Thu, Apr 6, 2017 at 11:22 AM Anthony DeBarros <adebarros(at)gmail(dot)com>
>> wrote:
>>
>> Agreed on all the responses thus far. The ability to distinguish values
>> ranging from thousands to tens of thousands to millions, etc., is
>> substantially harder if numbers are left-justified.
>>
>> On Thu, Apr 6, 2017 at 10:41 AM, Robert Eckhardt <reckhardt(at)pivotal(dot)io>
>> wrote:
>>
>> > 3. right-justified numbers come from precedents like excel or other
>> > spreadsheet type tools and muddles the distinction between editable and
>> > un-editable tables (at least data output in from query results is
>> > un-editable, I know right clicking on a table in the browser to "view
>> ...
>> > data/rows" outputs an editable table)
>>
>> When we first released pgAdmin 4 we forgot to right-justify numbers.
>> Users complained. Lots. They need to stay right justified.
>>
>>
>> Right justifying makes it substantially easier to understand magnitude
>> and makes it easier to get decimal alignment.
>>
>> -- Rob
>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>> --
>> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-hackers
>>
>>
>>
>>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company