Re: [pgAdmin4][PATCH] Improvements to Query Results Grid User Experience

From: Sarah McAlear <smcalear(at)pivotal(dot)io>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Surinder Kumar <surinder(dot)kumar(at)enterprisedb(dot)com>, Shruti B Iyer <siyer(at)pivotal(dot)io>, Robert Eckhardt <reckhardt(at)pivotal(dot)io>, Matthew Kleiman <mkleiman(at)pivotal(dot)io>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, Joao Pedro De Almeida Pereira <jpereira(at)pivotal(dot)io>, George Gelashvili <ggelashvili(at)pivotal(dot)io>
Subject: Re: [pgAdmin4][PATCH] Improvements to Query Results Grid User Experience
Date: 2017-06-08 18:31:05
Message-ID: CAGRPzo8N59YE3qyZDLzBfVu=UiaiYfcK-QoLFF7PvPh2uL5jTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

>
> Thanks. When I run the tests my browser opens in some default size
> that's always consistent, but doesn't match my normal Chrome sessions,
> or the 1024x1024 default set in app_starter.py.

This looks like an issue with string edit box placement in the
implementation. We created an issue for this (RM2477).

Anyway - I found another issue. If I select one or more columns or
> rows, or an arbitrary selection of cells, copy/paste seems to work
> fine. However, if I click the Select All arrow, for a small resultset
> (e.g. SELECT * FROM pg_database with 18 rows) it works fine, but if I
> do the same with the contents of pg_class, which has 1342 rows on this
> DB, it seems to fail to populate the clipboard and ends up pasting
> whatever was copied previously instead. If I use the Copy button, even
> on a fast machine it seems to pause for a second or so before failing
> to put the data on the clipboard.

We were able to reproduce this with "SELECT generate_series(1, 50000)"
The issue was still present for us when we ran the app at each of 2fddf750
and 495a3cedb
Could we move this discussion to a new thread as it doesn't seem related to
these changes?

Thanks,
George & Sarah

On Thu, Jun 8, 2017 at 10:19 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Thu, Jun 8, 2017 at 2:18 PM, Sarah McAlear <smcalear(at)pivotal(dot)io> wrote:
> > On Thu, Jun 8, 2017 at 8:34 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> >> - There are changes to SlickGrid, the addition of a function to scroll
> >> a column into view. Is this submitted upstream and accepted?
> >
> > We have submitted the changes we made to the patch to Slick grid and they
> > were accepted yesterday. We can get this in today or first thing
> tomorrow.
>
> Great.
>
> >>
> >> - One of the regression tests now fails because it's trying to access
> >> an element that's out of the clickable area. If I widen then browser
> >> for testing it passes so I believe it's just the test that needs
> >> fixing. Can you take a look at that ASAP please?
> >
> > We haven't seen this test fail but we can absolutely look into it. Our
> > Chrome browser is always the same size. We can try fiddling with that to
> see
> > if we can get it to fail.
>
> Thanks. When I run the tests my browser opens in some default size
> that's always consistent, but doesn't match my normal Chrome sessions,
> or the 1024x1024 default set in app_starter.py.
>
> Anyway - I found another issue. If I select one or more columns or
> rows, or an arbitrary selection of cells, copy/paste seems to work
> fine. However, if I click the Select All arrow, for a small resultset
> (e.g. SELECT * FROM pg_database with 18 rows) it works fine, but if I
> do the same with the contents of pg_class, which has 1342 rows on this
> DB, it seems to fail to populate the clipboard and ends up pasting
> whatever was copied previously instead. If I use the Copy button, even
> on a fast machine it seems to pause for a second or so before failing
> to put the data on the clipboard.
>
> Can you take a look at that too please?
>
> Thanks.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Sarah McAlear 2017-06-08 21:54:55 [patch] Changing the ACI tree font to Helvetica
Previous Message Dave Page 2017-06-08 16:06:44 Re: [pgAdmin4][Patch]: UI improvements in data-grid/query tool