Re: Request for feedback: Alternate desktop runtime architecture

TESTING WEB-BASED pgAdmin
SYSTEM: Windows 10 Pro Version 1709, 12GB RAM, SSD 525GB, Intel Core i7

Disappointment,

The framework may be a 10% faster, not noticeable really

The two bugs I emailed the last couple of days remain exactly the same.

For example, on a very large database, when I View/Edit > All Rows speed is
exactly the same on both apps.

When I click on the grid header both apps hung.

- The desktop crashes.

- The web-based app loose connection with the server and exit the page.
When I try to view all rows again display the following message

‘Query Tool Initialization Error’

Same bugs on both apps. Is that mean that the problem exist in common
source code???

The second bug is when I open table properties > Columns tab form on a
database with 217 columns.

This is as slow as the desktop app. About 100 secs.

I am a delphi programmer. I can accomplish both tasks in my
applications working
on the same database in less than 1.5 sec.

I work on the same database on MSSQL version also. I can accomplish same
connection speed and data retrieve equivalent to the Microsoft SQL Server
Management Studio.

I believe that the problem could be in the code connecting to the server
and retrieving data. Not the UI itself.

Hope I helped a bit.

2018-01-23 18:56 GMT+02:00 McDonaldR <McDonaldR(at)angus(dot)gov(dot)uk>:

> Yes, I can confirm it works on Win 7 Enterprise 64 bit. I’ll test on Win
> 10 Enterprise 64 bit tomorrow. Be interesting to see if it will show
> notifications on the Win 10 box.
>
> I’ll test some more tomorrow and send any feedback.
>
> Thanks for all the effort.
>
>
>
> Ross
>
>
>
>
>
> *Ross McDonald | *GIS Data Coordinator | Angus Council, People, IT |
> Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT* | t:
> 01307 476419*
>
>
>
>
>
>
>
> *From:* Dave Page [mailto:dpage(at)pgadmin(dot)org]
> *Sent:* 23 January 2018 14:49
> *To:* pgadmin-hackers(at)lists(dot)postgresql(dot)org; pgadmin-support
> lists.postgresql.org
> *Subject:* Request for feedback: Alternate desktop runtime architecture
>
>
>
> 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/
>
>
>
> and the GIT branch can be found here:
>
>
>
> https://git.postgresql.org/gitweb/?p=pgadmin4.git;a=
> shortlog;h=refs/heads/runtime-revamp
>
>
>
> Thanks!
>
>
>
> --
>
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> This message is strictly confidential. If you have received this in error,
> please inform the sender and remove it from your system. If received in
> error you may not copy, print, forward or use it or any attachment in any
> way. This message is not capable of creating a legal contract or a binding
> representation and does not represent the views of Angus Council. Emails
> may be monitored for security and network management reasons. Messages
> containing inappropriate content may be intercepted. Angus Council does not
> accept any liability for any harm that may be caused to the recipient
> system or data on it by this message or any attachment.
>