Re: Selecting tables from Browser

Shirley,

I have a few questions.

1. Why 20. It is a dunbar number and seems smallish but is there another
reason?
2. Since this is referred to as an Object Manager I assume the same
thing will eventually be available for databases, schema, partitions, etc.
How do permissions work currently to limit m view of these objects? (or do
they)
3. Do you think that this would look differently if you assumptions were
based on a user who writes BI reports or some other non-DBA user?

-- Rob

On Mon, Aug 21, 2017 at 12:20 PM, Shirley Wang <swang(at)pivotal(dot)io> wrote:

> Hello!
>
> Our team is working on validating a solution for viewing many tables in
> the Catalog Browser. We've heard through user interviews that some schemas
> hold many tables (over 10000 in some cases) and when expanding tables, the
> browser crashes. In cases where people are able to view tables in the
> catalog browser, finding the relevant tables requires a lot of
> search/scrolling.
>
> We are testing these designs over the next few weeks. In particular we're
> looking to validate/invalidate if:
> Terry would filter the list of tables before selecting tables
> Terry has a curated schema list based on her permissions
> Terry needs to reopen the object manager again after making a selection
> Terry needs to collapse and expand the list of tables without opening the
> object manager
> Terry needs to use the object manager once there are at least 20 tables
> (Terry is our DBA persona)
>
>
>
> Here are the screens:
> *01 Open 'Object Manager' by clicking on tables in the browser. (not
> attached to 'object manager', open to suggestions)*
> [image: 08.png]
> *02 Most DBAs tend to know which tables they're working with on a high
> level. Here they can filter down the list.*
> [image: 09_01b.png]
> *03 Alternatively, DBAs can just select the tables they need.*
> [image: 09_02.png]
>
> *04 once selected, the tables appear in the browser*
> [image: 10.png]
>
> Part of our test is to learn how users expect to re-open the object
> manager as well.
>
> Feedback is welcome. We'll consolidate feedback from here with the
> feedback we get from user tests and share that out in a few weeks once the
> sessions are done.
>
>
> Shirley & pgAdmin team
>
>