Re: Request for feedback: Alternate desktop runtime architecture

Поиск
Список
Период
Сортировка
От microsys.gr microsys.gr
Тема Re: Request for feedback: Alternate desktop runtime architecture
Дата
Msg-id CALewnqSrnE9j0y+3No==AuzoYyv1b3MHto=0cCiDR136-BXd2Q@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Request for feedback: Alternate desktop runtime architecture  (McDonaldR <McDonaldR@angus.gov.uk>)
Ответы Re: Request for feedback: Alternate desktop runtime architecture  (Seçkin Alan <seckinalan@gmail.com>)
Re: Request for feedback: Alternate desktop runtime architecture  (Seçkin Alan <seckinalan@gmail.com>)
Re: Request for feedback: Alternate desktop runtime architecture  (Dave Page <dpage@pgadmin.org>)
Re: Request for feedback: Alternate desktop runtime architecture  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
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@angus.gov.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@pgadmin.org]
Sent: 23 January 2018 14:49
To: pgadmin-hackers@lists.postgresql.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:

 

 

and the GIT branch can be found here:

 

 

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.


В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Doug Easterbrook
Дата:
Сообщение: Re: Request for feedback: Alternate desktop runtime architecture
Следующее
От: Seçkin Alan
Дата:
Сообщение: Re: Request for feedback: Alternate desktop runtime architecture