From: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
---|---|
To: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>, Dave Page <dpage(at)pgadmin(dot)org> |
Subject: | Re: Query tool data grid - Infinite scroll vs Pagination |
Date: | 2024-06-28 08:33:45 |
Message-ID: | CAM9w-_n2zyK-fGYKedi59Z_t3-6LTfZeD0_Bgz4EWXhrS6=Zuw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgadmin-support |
Hi,
Unfortunately, there were only 3 responses to this.
In that case, we will discuss internally and decide what to do.
On Thu, Jun 20, 2024 at 2:46 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
> Hi Everyone,
>
> Request you to share your opinion on this and respond on:
>
> https://docs.google.com/forms/d/e/1FAIpQLSdfJhNK8qXSe9mKcubZa8jjjYl0hiZVxhv6GGJo8WJcYc27ug/viewform?usp=sharing
>
> On Thu, Jun 20, 2024 at 1:36 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> Hi
>>
>> On Wed, 19 Jun 2024 at 13:42, Aditya Toshniwal <
>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>
>>> Hi Hackers,
>>>
>>> Query tool data grid currently pulls the data on load basis in batches.
>>> For example, it will initially load only 1000 rows and once a user scrolls
>>> to the 1000th row, it will fetch the next batch of 1000.
>>> Many users who want access in between rows or last row struggle to do it
>>> as the user has to scroll and scroll. If someone grabs the scroller and
>>> pulls it down still it will be a good UX and the scrollbar may jump. One
>>> reported here - https://github.com/pgadmin-org/pgadmin4/issues/1780
>>> One more aspect to this is the in memory data of the query tool which
>>> keep on increasing on each scroll, it affects the performance.
>>>
>>> I propose we should use pagination instead of infinite scroll with the
>>> following advantages:
>>> 1. Users can jump to any page they want.
>>> 2. Users can change the page size on the grid directly.
>>> 3. Memory will be used only for visible rows so performance improvement.
>>> 4. Predictable UI, no jumping scrollbars.
>>>
>>> Let me know what you think.
>>>
>>
>>
>> I think there are definite benefits, but there is the downside of having
>> to scroll and click to browse results. Personally I'm fine with that, but I
>> think you should probably poll pgadmin-support for opinions from more users.
>>
>> --
>> Dave Page
>> pgAdmin: https://www.pgadmin.org
>> PostgreSQL: https://www.postgresql.org
>> EDB: https://www.enterprisedb.com
>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"
From | Date | Subject | |
---|---|---|---|
Next Message | Muhammad Ikram | 2024-06-28 12:09:33 | Re: Query tool data grid - Infinite scroll vs Pagination |
Previous Message | Akshay Joshi | 2024-06-27 12:26:50 | Re: Next Library/Package update |
From | Date | Subject | |
---|---|---|---|
Next Message | Muhammad Ikram | 2024-06-28 12:09:33 | Re: Query tool data grid - Infinite scroll vs Pagination |
Previous Message | Akshay Joshi | 2024-06-27 07:39:28 | pgAdmin 4 v8.9 Released |