[pgAdmin4] UI/data grid issues

From: Michal Kozusznik <kozusznik(dot)michal(at)ifortuna(dot)cz>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: [pgAdmin4] UI/data grid issues
Date: 2016-06-13 13:59:15
Message-ID: 6ca1701b-6cf8-79fb-b5b0-9e5261283499@ifortuna.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I'm not sure images can be attached to the email, I'll try. In case if
doesn't work, you can see the image at: http://i.imgur.com/oPYHaAw.png

Please note, the first column on the picture is masked intentionally.

There are following issues depicted on the screenshot

1. Width of columns depends on column name as well as datatype
description, but not on data itself. This way, column "vyhra" is way
too wide, while column p_datum wraps contained values.
2. Width of columns is not adjustable. Despite column edge can be
"caught" by mouse and dragged, nothing changes after releasing mouse
button
3. This particular table contains way more columns - but there is no
vertical scroll or any other method I know to get to them
4. numeric datatype with unlimited numeric precision is shown as
numeric(65535, 65535). Similar thing regarding other datatypes like
integer, date, timestamp
5. To numbers, 'thousands' formatting is applied however formatting
rules (added comma before each 3 digits) doesn't match system
settings (spaces instead of comas). To be honest I don't like any
such formatting in data grids. But if any, it should be configurable
or at least should reflect system settings.
6. At the bottom of data grid we can see pagination buttons. Does it
mean that while getting 100 records, these will be split to smaller
parts and available page by page? Not sure if it's good idea. Beside
of this, switching between page 1 and 2 is very slow. Takes about 4
sek on my end (it's only 100 records, but lot of columns)
7. Whole GUI seems to be very slow. especially comparing to pgAdmin3. I
can see some animated transitions (would like to disable it, found
no option for that). But even scrolling is lagging. For example
while scrolling data grid up-down-up-down, the delay between mouse
cursor and grid movement is significant. Next major UI slow downs
are visible while expanding width of object tree or resizing
application window (especially from/to full screen).
8. auto-completion/intellisense is way too slow to be useful (and have
to be triggered manually afaik). Moreover it cannot resolve simple
scenarios like SELECT * FROM mytable WHERE .... showing all object
from database instead of objects of the table. I admin that it might
be valid in some cases but in most cases we need to see the table
columns, nothing more or less Maybe it should show most likely
useful hints first, then others? If you consider this feature to be
improved in near future, IMO SQL Assistant is a remarkable benchmark
for such features.

Hope it helps in some way

With regards

Attachment Content-Type Size
kozusznik_michal.vcf text/x-vcard 370 bytes

Browse pgadmin-support by date

  From Date Subject
Next Message Melvin Davidson 2016-06-14 01:42:18 Re: Poker Tracker 4
Previous Message Dave Page 2016-06-13 10:01:52 Re: Problem displaying intervals and timestamps with pgAdmin 4