Postgres Pro
Downloads
Home   >   mailing lists

Re: Selecting tables from Browser - Mailing list pgadmin-hackers

From Robert Eckhardt
Subject Re: Selecting tables from Browser
Date
Msg-id CAAtBm9U=2iLrYJNgCq_AC5c1tznKVRpR8vgvA3upB92nJX5ofw@mail.gmail.com
Whole thread Raw
In response to Selecting tables from Browser  (Shirley Wang <swang@pivotal.io>)
Responses Re: Selecting tables from Browser
List pgadmin-hackers
Tree view
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@pivotal.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)
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.
09_01b.png
03 Alternatively, DBAs can just select the tables they need.
09_02.png

04 once selected, the tables appear in the browser
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


pgadmin-hackers by date:

Previous
From: Shirley Wang
Date:
Subject: Selecting tables from Browser
Next
From: Shirley Wang
Date:
Subject: Re: pgAdmin4 - Tree view icons for final reveiw