Re: User Research Findings into PgAdmin

Hi Dave,
We can definitely send a summary via email. Just to clarify those points
you brought up. Syntax highlighting definitely does exist and is totally
discoverable but people still seemed to miss it. Our best guess as to why
so many users miss it is because of the relatively small contrast in colors
(Navy vs black). Regarding autocomplete, despite it being documented,
almost none of the long time customers we spoke with knew it existed which
suggests they're not reading the documentation very closely or at all.

Regarding the comments you mentioned, the one regarding column names was
talking about preserving the column name when moving data to Excel. And
I'll admit, the other comment is pretty unclear out of context. We probably
should not have included it as is.

A summary of the findings will be forthcoming.

On Wed, Jan 25, 2017 at 4:25 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Tue, Jan 24, 2017 at 9:42 PM, Raffi Holzer <rholzer(at)pivotal(dot)io> wrote:
> > Hi,
> > As part of a project to enable pgAdmin4 to work with Greenplum
> databases,
> > we conducted user research into pgAdmin. We wanted to share those
> insights
> > and potentially develop against them but first wanted to get feedback
> from
> > the pgAdmin group. To that end we created the video below that summarizes
> > our findings. Let us know what you think.
> >
> > https://youtu.be/BylcblYw8sU
>
> That's very helpful, thank you. Can you please summarise your findings
> in an email to the list so we can work with it within our normal
> process?
>
> I will note that whilst I agree some of the points raised need further
> work in pgAdmin 4, some of them make little sense - most notably
> Syntax Highlighting which we've had for ~17 years, and works
> automatically, thus not requiring any kind of user discovery beyond
> typing some SQL into the query tool. Auto-complete is another example
> of a feature we've had for years, that is documented. I agree though
> that there is scope for better discovery mechanisms there.
>
> Some of the other comments highlighted made little to no sense to me,
> for example the comment on column names @ ~3:03 and the comment on the
> bottom left @ ~3:22 (this is a great example of why email is better
> than a video :-) ).
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

--
Raffi Holzer
Product Manager
Pivotal Labs