Re: PATCH: SlickGrid integration in query tool (pgAdmin4) - Mailing list pgadmin-hackers

From Dave Page
Subject Re: PATCH: SlickGrid integration in query tool (pgAdmin4)
Date
Msg-id CA+OCxowSbAsAi0HGv1p9+zez9xNd-i6FW05Y_rCjejQPkJeREQ@mail.gmail.com
Whole thread Raw
In response to PATCH: SlickGrid integration in query tool (pgAdmin4)  (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>)
Responses Re: PATCH: SlickGrid integration in query tool (pgAdmin4)  (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>)
List pgadmin-hackers
Hi,

On Wed, Aug 17, 2016 at 11:19 AM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi,

PFA initial patch for SlickGrid integration in query tool.

This is looking awesome! I think there are some tweaks to make, but performance-wise, it's blowing away the old code. My tests show it's even faster than you're seeing; I'm seeing ~3x performance rendering 21K rows for example, vs. the first 2K of the same dataset on page 1 with the old code - plus, the rendered HTML isn't so huge that it slows everything else down to being unusable!

Can you look at the following issues please?

1) The colour for a selected row should be #eeeeee

2) If there's a horizontal scroll bar (in Chrome on OSX, possibly others), then it partially eclipses the new blank row in View Data mode. The vertical scroll needs to have the height of the horizontal scrollbar added.

3) If the window is resized, the grid doesn't redraw to the new size.

4) I cannot leave a Primary Key field blank so that it picks up a default value (I get "Primary key columns cannot be null.")

5) When editing text fields with multiple lines, the CR/LFs are lost. Do we need a custom editor for this (textarea?).

6) The tooltips should probably include <pre> tags around the content otherwise the formatting is messed up and becomes unreadable.

Thanks!
 

My finding on grid rendering performance with each grid,
Inline image 1
Tested on PG9.5 (sql attached).

Please review.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Attachment

pgadmin-hackers by date:

Previous
From: Ohad Levinkron
Date:
Subject: New table - column order changes
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Reduce main menu height a little. Fixes #1453