Re: Request for feedback: Alternate desktop runtime architecture

On Tue, Jan 23, 2018 at 8:30 PM, microsys.gr microsys.gr <
microsys(dot)gr(at)gmail(dot)com> wrote:

> 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 wouldn't expect either of those issues to be affected by this change.

>
> 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.
>

Right.

Thanks!

>
> 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.
>>
>
>

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

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