Hi Folks, I think, pgadmin4 not need new architecture. It must even be a server running on the machine (on windows system tray like a wamp server, on mac like a docker).
Yes, I know user experience is different until now. But modern browsers handle this work. I think, chromium embedded could be a good way to do this for example. On Tue, Jan 23, 2018 at 11:30 PM, microsys.gr microsys.gr < microsys...@gmail.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 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 <mcdona...@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:dp...@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: >> >> >> >> 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. >> > > -- Seçkin ALAN http://seckinalan.com
