Re: Tree view icon samples

Hi Dave,

I am attaching the updated icons along with new icons added.

Also I have tried to address the issues raised in our previous review -

1. Cast and Conversion: Eliminated the texty feel as you commented.

Thought process: Basically cast means "Conversion between Data types" and
Conversion means "Conversion between character" so I have come up with box
shape concept where box means any "conversion of any data type or any
character type". Ultimately "Box" plays role of a variable.

2. Primary and Foreign key: Updated as per the feedback and have come up
with one more concept with slight changes in it.

Supporting content for the concept:
As Primary key cannot be more than one but where as Foreign key can be more
than one so taking this as base point I have presented the icon so.

3. Index, Function and Function Trigger : As of now I have kept it as
existing one only, I cannot be more innovative here where it mis-matches
with the user's mental model. I am still brainstorming on these icons.

Note: I have listed out the list of icons which will be used in pgAdmin 4
and will be working on those icons only

Regards,
Chethana kumar

On Mon, Jul 3, 2017 at 3:01 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Friday, June 30, 2017, Strauch, Sheldon <sstrauch(at)enova(dot)com> wrote:
>
>> Dave et al,
>>
>> Might I suggest flipping the foreign key icon left for right? That way,
>> the key "points" to the left, back toward something pre-existing whilst the
>> primary key "points" to the right, forward towards something new?
>>
>
> I like that idea.
>
>
>>
>> Also, for me, the updated index icon loses its intuitiveness as it
>> suggests an ordinal list or an enumeration. I think the clue in the old
>> icon was the index tab at the top of the illustration.
>>
>
> Yeah. Maybe something that looks like a diagram of a btree?
>
>
>>
>> Finally, the new trigger icon suggests, to me, that one is trying to do
>> something with a document, maybe copying it. Whereas the old icon suggests
>> an action to be taken.
>>
>
> I see what you mean. I don't think the old one is any better though.
> Chethana; do you have any alternative ideas?
>
>
>>
>> Just my two cents...
>>
>> On Fri, Jun 30, 2017 at 9:57 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>> Hi
>>>
>>> - The Primary Key and Foreign Key icons should have more differentiation
>>> than just colour. Maybe add a 1 to Primary Key?
>>>
>>> - Did you get a list of the other icons that aren't on that sheet yet?
>>>
>>> - I'm not sure I like the Casts and Conversions icons (mis-spelt as
>>> Converts by the previous owner). The text on the makes them seem textual
>>> than graphical.
>>>
>>> Thanks!
>>>
>>> On Fri, Jun 30, 2017 at 12:56 PM, Chethana Kumar <
>>> chethana(dot)kumar(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Team, Attachment was missing.
>>>>
>>>>
>>>>
>>>> On Fri, Jun 30, 2017 at 5:24 PM, Chethana Kumar <
>>>> chethana(dot)kumar(at)enterprisedb(dot)com> wrote:
>>>>
>>>>> Hello Team,
>>>>>
>>>>> Below are the updates for TreeView Icons -
>>>>>
>>>>> 1. Fine tuned the icons - Database, Language, Primary and Foreign key,
>>>>> Unique Constraint
>>>>> 2. Designed new concept for - Casts and Converts, Trigger
>>>>> 3. Attached the color blind test result for "Primary and Foreign key",
>>>>> now I feel it is pretty evident to differentiate for blind user
>>>>> 4. Attached "thought_process.png" where I have explained the thought
>>>>> process for newly proposed icons (referred:www.postgresql.org)
>>>>> 5. Added little depth to all icons to provide the Afforance of Click
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Jun 29, 2017 at 10:21 AM, Ashesh Vashi <
>>>>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>>
>>>>>> On Thu, Jun 29, 2017 at 9:09 AM, Chethana Kumar <
>>>>>> chethana(dot)kumar(at)enterprisedb(dot)com> wrote:
>>>>>>
>>>>>>> Hi Ashesh,
>>>>>>>
>>>>>>> I tried to eliminate the colour blind issue which might occur with
>>>>>>> the primary & foregin key icons.
>>>>>>> But still I will use the app to test the colors, just let me know
>>>>>>> your opinion now.
>>>>>>>
>>>>>> Please do.
>>>>>>
>>>>>> One more point: :-)
>>>>>> Icons for some nodes are missing here.
>>>>>> i.e. Partition table (introduced in 'Declarative Partition' patch),
>>>>>> Materialized View, etc.
>>>>>>
>>>>>> -- Thanks, Ashesh
>>>>>>
>>>>>>>
>>>>>>> Regards,
>>>>>>> Chethana kumar
>>>>>>>
>>>>>>> On Wed, Jun 28, 2017 at 11:13 PM, Ashesh Vashi <
>>>>>>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Jun 28, 2017 22:32, "Robert Eckhardt" <reckhardt(at)pivotal(dot)io>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>> I like them as well. The only comment I have is that the red icon
>>>>>>>> on disconnected DB and corrupted DB are difficult to make out. They are
>>>>>>>> clearly differentiable but the icon itself is unclear.
>>>>>>>>
>>>>>>>> A colour blind person may not be able to differentiate the primary
>>>>>>>> & foreign key icons.
>>>>>>>>
>>>>>>>> -- Ashesh
>>>>>>>>
>>>>>>>>
>>>>>>>> -- Rob
>>>>>>>>
>>>>>>>> On Wed, Jun 28, 2017 at 12:49 PM, Dave Page <dpage(at)pgadmin(dot)org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi
>>>>>>>>>
>>>>>>>>> > On 28 Jun 2017, at 12:41, Chethana Kumar <
>>>>>>>>> chethana(dot)kumar(at)enterprisedb(dot)com> wrote:
>>>>>>>>> >
>>>>>>>>> > Hi Team,
>>>>>>>>> >
>>>>>>>>> > I am coming up with some sample icons for Tree View Control.
>>>>>>>>> >
>>>>>>>>> > Thought process behind the concept -
>>>>>>>>> >
>>>>>>>>> > 1. Included EDB color brand feel (gray and blue colors)
>>>>>>>>>
>>>>>>>>> You mean pgAdmin colour brand :-). EDB is orange & black.
>>>>>>>>>
>>>>>>>>> > 2. Eliminated the distraction of too many colors and provided
>>>>>>>>> consistency through the icons
>>>>>>>>> > 3. User will recognize the icon shapes rather than recalling it
>>>>>>>>> by their colors (like in existing icons) so focused more on shapes
>>>>>>>>> > 4. It also adds value to the brand since it has EDB color tones
>>>>>>>>> in it
>>>>>>>>> >
>>>>>>>>> >
>>>>>>>>> > So please feel free to share your views on the same
>>>>>>>>>
>>>>>>>>> I like them - they look much more modern and stylish, but still
>>>>>>>>> fit with what they represent.
>>>>>>>>>
>>>>>>>>> Other opinions please?
>>>>>>>>>
>>>>>>>>> Good work!
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Chethana Kumar
>>>>>>> Principal UI/UX Designer
>>>>>>> EnterpriseDB Corporation
>>>>>>>
>>>>>>>
>>>>>>> The Postgres Database Company
>>>>>>>
>>>>>>> P: +91 86981 57146 <+91%2086981%2057146>
>>>>>>> www.enterprisedb.com
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Chethana Kumar
>>>>> Principal UI/UX Designer
>>>>> EnterpriseDB Corporation
>>>>>
>>>>>
>>>>> The Postgres Database Company
>>>>>
>>>>> P: +91 86981 57146 <+91%2086981%2057146>
>>>>> www.enterprisedb.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Chethana Kumar
>>>> Principal UI/UX Designer
>>>> EnterpriseDB Corporation
>>>>
>>>>
>>>> The Postgres Database Company
>>>>
>>>> P: +91 86981 57146 <+91%2086981%2057146>
>>>> www.enterprisedb.com
>>>>
>>>
>>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>>
>>
>> --
>>
>> Assumptions validated by consistent data from actual experiments enable
>> the creation of real value.
>>
>> Sheldon E. Strauch
>> *Data Architect, Data Services *
>> *O* 312-676-1556
>> *M* 224-723-3878
>>
>> *Enova International, Inc.*
>> *This transmission is confidential and may be privileged or proprietary.
>> If you are not the intended recipient, you are not authorized to use the
>> information in this transmission in any way. Please inform the sender
>> immediately if you have received this transmission in error and permanently
>> delete and destroy the original and any copies of the information.*
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>

--
Chethana Kumar
Principal UI/UX Designer
EnterpriseDB Corporation

The Postgres Database Company

P: +91 86981 57146
www.enterprisedb.com