Pagination in pgAdmin4 UI

From: J Payne <jcpayne(at)uw(dot)edu>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Pagination in pgAdmin4 UI
Date: 2016-07-14 06:04:21
Message-ID: 0CFF95B6-D940-46A0-AA14-0D08B4641BC4@uw.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I have now experimented with pgAdmin4 a little bit and am generally impressed by the direction that it’s going. 

However, I am bothered by the pagination of the results on the Query page.  Michal Kozusznik (message id: 6ca1701b-6cf8-79fb-b5b0-9e5261283499(at)ifortuna(dot)cz) politely said “Not sure if it's good idea.”  I have used pgAdmin3 for thousands of hours, so please understand that the following comment comes from a place of great respect for pgAdmin3 and all of the work that went into it:  I’ll stick my neck out and say that pagination is a terrible, terrible idea and I beg you to reconsider.  Scrolling is much faster and easier for the user (see for example Mike Bostock’s comments at https://bost.ocks.org/mike/scroll/), especially since a database admin or heavy user occasionally has a reason to scroll quickly through lots of rows to get the gist of something (a general feeling for the proportion of the rows that are blank, or some such thing).  Of course the same questions can always be answered more precisely with targeted queries, but having a fast and responsive GUI makes the work easier.  I think it’s a pretty safe bet that most pgAdmin users are the kind of people who try to minimize the amount of pointing-and-clicking that they do when working.

For the same reason, it was nice in pgAdmin3 to have the SQL button right on the main ribbon so that you could instantly launch a query page; it’s a bit less convenient to have it down two levels.

Anyway, thank you for the excellent tools, and I look forward to seeing pgAdmin4 in production.

John

Browse pgadmin-support by date

  From Date Subject
Next Message dangal 2016-07-14 14:00:42 PgAdmin Beta 2 problem in Win7
Previous Message Mark Csaba 2016-07-13 21:26:07 Re: Bug: Opening pgAdmin with a file with mixed line endings