Thread: Tree view icon samples

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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!

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. 

-- Rob

On Wed, Jun 28, 2017 at 12:49 PM, Dave Page <dpage@pgadmin.org> wrote:

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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!

Hi Robert,

Please check the icons of Database Disconnected and Database Corrupted, just let me know if still can't be able to differentiate between themselves. 

Regards,

Chethana kumar

On Wed, Jun 28, 2017 at 10:32 PM, Robert Eckhardt <reckhardt@pivotal.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. 

-- Rob

On Wed, Jun 28, 2017 at 12:49 PM, Dave Page <dpage@pgadmin.org> wrote:

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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

www.enterprisedb.com

On Wed, Jun 28, 2017 at 3:48 PM, Shirley Wang <swang@pivotal.io> wrote:

I recommend using Sim Daltonism to test colors! 

https://itunes.apple.com/us/app/sim-daltonism/id693112260?mt=12

Excellent idea - Chethana, please grab a copy and verify that all icons are distinct when tested for different types of colour blindness.

Thanks!

--

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

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

On Jun 28, 2017 22:32, "Robert Eckhardt" <reckhardt@pivotal.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@pgadmin.org> wrote:

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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!

On Thu, Jun 29, 2017 at 9:09 AM, Chethana Kumar <chethana.kumar@enterprisedb.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.vashi@enterprisedb.com> wrote:

On Jun 28, 2017 22:32, "Robert Eckhardt" <reckhardt@pivotal.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@pgadmin.org> wrote:

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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

www.enterprisedb.com

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.kumar@enterprisedb.com> wrote:

Hi Team,  Attachment was missing.

On Fri, Jun 30, 2017 at 5:24 PM, Chethana Kumar <chethana.kumar@enterprisedb.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.vashi@enterprisedb.com> wrote:

On Thu, Jun 29, 2017 at 9:09 AM, Chethana Kumar <chethana.kumar@enterprisedb.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.vashi@enterprisedb.com> wrote:

On Jun 28, 2017 22:32, "Robert Eckhardt" <reckhardt@pivotal.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@pgadmin.org> wrote:

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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

www.enterprisedb.com

--

Chethana Kumar

Principal UI/UX Designer

EnterpriseDB Corporation

The Postgres Database Company

P: +91 86981 57146

www.enterprisedb.com

--

Chethana Kumar

Principal UI/UX Designer

EnterpriseDB Corporation

The Postgres Database Company

P: +91 86981 57146

www.enterprisedb.com

--

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

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

Hi

On Friday, June 30, 2017, Strauch, Sheldon <sstrauch@enova.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@pgadmin.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.kumar@enterprisedb.com> wrote:

Hi Team,  Attachment was missing.

On Fri, Jun 30, 2017 at 5:24 PM, Chethana Kumar <chethana.kumar@enterprisedb.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.vashi@enterprisedb.com> wrote:

On Thu, Jun 29, 2017 at 9:09 AM, Chethana Kumar <chethana.kumar@enterprisedb.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.vashi@enterprisedb.com> wrote:

On Jun 28, 2017 22:32, "Robert Eckhardt" <reckhardt@pivotal.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@pgadmin.org> wrote:

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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

www.enterprisedb.com

--

Chethana Kumar

Principal UI/UX Designer

EnterpriseDB Corporation

The Postgres Database Company

P: +91 86981 57146

www.enterprisedb.com

--

Chethana Kumar

Principal UI/UX Designer

EnterpriseDB Corporation

The Postgres Database Company

P: +91 86981 57146

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

Hi

On Mon, Jul 3, 2017 at 8:53 AM, Chethana Kumar <chethana.kumar@enterprisedb.com> wrote:

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.

For Conversion, how about we make it a triangle and circle instead of two squares?

 

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

Cool. I like the double-key for Foreign Key.

 

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.

For index, how about a tree, like the bottom one at https://upload.wikimedia.org/wikipedia/commons/3/33/B_tree_insertion_example.png. Leave out the numbers of course.

For function, something with { } in there?

And for Trigger Function, a mashup of function and trigger?

 

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@pgadmin.org> wrote:

Hi

On Friday, June 30, 2017, Strauch, Sheldon <sstrauch@enova.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@pgadmin.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.kumar@enterprisedb.com> wrote:

Hi Team,  Attachment was missing.

On Fri, Jun 30, 2017 at 5:24 PM, Chethana Kumar <chethana.kumar@enterprisedb.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.vashi@enterprisedb.com> wrote:

On Thu, Jun 29, 2017 at 9:09 AM, Chethana Kumar <chethana.kumar@enterprisedb.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.vashi@enterprisedb.com> wrote:

On Jun 28, 2017 22:32, "Robert Eckhardt" <reckhardt@pivotal.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@pgadmin.org> wrote:

Hi

> On 28 Jun 2017, at 12:41, Chethana Kumar <chethana.kumar@enterprisedb.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

www.enterprisedb.com

--

Chethana Kumar

Principal UI/UX Designer

EnterpriseDB Corporation

The Postgres Database Company

P: +91 86981 57146

www.enterprisedb.com

--

Chethana Kumar

Principal UI/UX Designer

EnterpriseDB Corporation

The Postgres Database Company

P: +91 86981 57146

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

--

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

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