Re: Request for feedback: Alternate desktop runtime architecture

From: Paolo Saudin <paolosaudin(at)gmail(dot)com>
To:
Cc: Dave Page <dpage(at)pgadmin(dot)org>, "pgadmin-hackers(at)lists(dot)postgresql(dot)org" <pgadmin-hackers(at)lists(dot)postgresql(dot)org>, "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Request for feedback: Alternate desktop runtime architecture
Date: 2018-01-24 06:09:56
Message-ID: CADtZQgkeqP4WJYjS1TDnCZjVJAimSeMtWiUNgiPYEmy4Z1fP=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Hi Dave,

runs fine on Windows 10 64bit machine

Paolo

2018-01-23 22:55 GMT+01:00 Barrington-Hughes, Alan <
Alan_Barrington-Hughes(at)premierinc(dot)com>:

> Thanks Dave for positing this different approach to eliminate some of the
> Qt rendering overhead.
>
>
>
> I can say, running on a 2017 mac book pro (10.13.2), the speed improvement
> is noticeable. The increased speed that tree nodes expand and result grids
> present are very appreciated.
>
>
>
> I am hoping that a next step would be present the UI loaded from
> 1.27.0.0.1 within a pgAdmin4 branded window, as Command-Tabbing to pgAdmin4
> is preferable to finding a Safari window amongst the numerous Safari
> windows/tabs I usually have open.
>
>
>
> Keep up the good work and thanks!
>
>
>
> Alan
>
>
>
> *From: *Dave Page <dpage(at)pgadmin(dot)org>
> *Date: *Tuesday, January 23, 2018 at 9:48 AM
> *To: *"pgadmin-hackers(at)lists(dot)postgresql(dot)org" <pgadmin-hackers(at)lists(dot)
> postgresql.org>, "pgadmin-support lists.postgresql.org" <
> pgadmin-support(at)lists(dot)postgresql(dot)org>
> *Subject: *Request for feedback: Alternate desktop runtime architecture
>
>
>
> ****This email did not originate from the Premier, Inc. network. Use
> caution when opening attachments or clicking on URLs.*****
>
>
> .
>
> All,
>
>
>
> As you may know, the most troublesome part of pgAdmin 4 has been the
> desktop runtime application, which has relied on QtWebKit and QtWebEngine
> (of various origins and versions) to render the UI as part of the Qt
> framework.
>
>
>
> This has caused performance issues, rendering issues with remote desktop
> sessions, keyboard navigation issues and more. It probably accounts for 25%
> or more of the bugs reports we deal with.
>
>
>
> Unfortunately, whilst there are alternatives to Qt for this purpose, none
> that we've found are mature enough for our purposes, and would require a
> significant amount of effort to add the features we would need to support
> pgAdmin.
>
>
>
> I've therefore been experimenting with another approach in which pgAdmin
> is rendered in a regular web browser when running in desktop mode. Like
> some other similar applications, a server process is launched and lives in
> the system tray, from where it can be shutdown at any time, or new windows
> opened. When it is first started, it will launch a browser window to render
> pgAdmin automatically. If additional instances are launched, the previously
> running instance will be re-used to avoid wasting resources.
>
>
>
> This is a proof of concept at the moment, for which I would appreciate any
> feedback. Windows and Mac builds can be found here:
>
>
>
> https://developer.pgadmin.org/~dpage/runtime-revamp/
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__developer.pgadmin.org_-7Edpage_runtime-2Drevamp_&d=DwMFaQ&c=2Nw3fMGo2X8W9N0cgJ8QEE6dJUdSW43Zo0sycqQq3H0&r=JXlHlKf8Hjakso54E_rGKblOv3Fth6Zevxm0R26zlGKmuafRJMMVOJj3dLMEx0vS&m=ACN3e71f7SJdKIeZAB5L9A4jDK8uvdvS-ulJTS4dxxI&s=Soj3O5-FV6D5zJC-PSpUtgSVG77QDwhdVUfE-_O-g_g&e=>
>
>
>
> and the GIT branch can be found here:
>
>
>
> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=
> shortlog;h=refs/heads/runtime-revamp
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__git.postgresql.org_gitweb_-3Fp-3Dpgadmin4.git-3Ba-3Dshortlog-3Bh-3Drefs_heads_runtime-2Drevamp&d=DwMFaQ&c=2Nw3fMGo2X8W9N0cgJ8QEE6dJUdSW43Zo0sycqQq3H0&r=JXlHlKf8Hjakso54E_rGKblOv3Fth6Zevxm0R26zlGKmuafRJMMVOJj3dLMEx0vS&m=ACN3e71f7SJdKIeZAB5L9A4jDK8uvdvS-ulJTS4dxxI&s=rB2Kue2Z5KFrB2uwPRn0s_JG8n3a5EKaARL2NFBeGb8&e=>
>
>
>
> Thanks!
>
>
>
> --
>
> Dave Page
> Blog: http://pgsnake.blogspot.com
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__pgsnake.blogspot.com&d=DwMFaQ&c=2Nw3fMGo2X8W9N0cgJ8QEE6dJUdSW43Zo0sycqQq3H0&r=JXlHlKf8Hjakso54E_rGKblOv3Fth6Zevxm0R26zlGKmuafRJMMVOJj3dLMEx0vS&m=ACN3e71f7SJdKIeZAB5L9A4jDK8uvdvS-ulJTS4dxxI&s=rD0UBDGzR82B1LgXezaBFlTzJ7cuI410jd-F7szQWOo&e=>
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.enterprisedb.com&d=DwMFaQ&c=2Nw3fMGo2X8W9N0cgJ8QEE6dJUdSW43Zo0sycqQq3H0&r=JXlHlKf8Hjakso54E_rGKblOv3Fth6Zevxm0R26zlGKmuafRJMMVOJj3dLMEx0vS&m=ACN3e71f7SJdKIeZAB5L9A4jDK8uvdvS-ulJTS4dxxI&s=-9z2wYFebEldPgVCqZnsKHZKM689NT1iiYKVlHW-Ppk&e=>
> The Enterprise PostgreSQL Company
>

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Chethana Kumar 2018-01-24 07:47:27 Re: [pgAdmin4][Patch#3021] Updating existing Index scan & Scan icons
Previous Message Khushboo Vashi 2018-01-24 04:12:00 Re: Table Properties... > [Columns tab] very slow

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2018-01-24 09:57:23 Re: Request for feedback: Alternate desktop runtime architecture
Previous Message Khushboo Vashi 2018-01-24 04:12:00 Re: Table Properties... > [Columns tab] very slow