Re: (Repeat.) Please give pgAdmin 4 its own GUI. The constant password inputs are driving me insane...

Hi

On Mon, Jul 29, 2019 at 1:26 PM richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
wrote:

> Dave,
>
> Ah, I guess the two of us have a different understanding of *desktop* mode.
> In your, and apparently pgAdmin4's case, it's a locally running web server
> with a couple of settings tweaked. In my, and perhaps many other people's,
> understanding *desktop* mode is a program that you install on your
> machine that contains it's own UI and *isn't* a server (even one that's
> running on your local machine) that you access with your web browser as you
> would google.com or facebook.com. Desktop mode is like pgAdmin3,
> non-desktop (server) mode is like running apache locally that has had
> phpPgAdmin installed. In pgAdmin4's case it's using python not php and the
> application and web server come as a bundle.
>

pgAdmin 3 is what we'd call a native (desktop) application. pgAdmin 4 is
*always* going to have a client-server model, as that's how it was designed
and built from the ground up (which I believe Avin noted in the other
thread). What we call desktop mode for pgAdmin 4 is some behavioural
configuration options as you note, and the way the client/server are
bundled together; whether in a single Qt application with the client and
server effectively hidden from the user as we had with v1.x and v2.x, or
with a server application and the users browser as we have now.

>
> But thanks for pointing me to that web page.
>

No problem.

>
> rik.
>
>
>
>
>
> On Mon, Jul 29, 2019 at 8:14 AM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> Hi
>>
>> On Mon, Jul 29, 2019 at 12:58 PM richard coleman <
>> rcoleman(dot)ascentgl(at)gmail(dot)com> wrote:
>>
>>> Dave,
>>>
>>> Thanks for helping to clear that up, I am sorry I misunderstood
>>> Khushboo's response. As for running in *desktop mode*, I didn't think
>>> that was possible for quite some time. I sure haven't been able to find
>>> out how to pull that off. If you could explain, I would imagine I am not
>>> the only one who would like that opportunity.
>>>
>>
>> You are running in desktop mode, otherwise you would see the login page
>> when you first connect (and you wouldn't get the master password prompt).
>> See https://www.pgadmin.org/docs/pgadmin4/4.11/getting_started.html (and
>> the relevant child pages on Server and Desktop deployment)
>>
>> Desktop vs. Server mode is not about the whether you access pgAdmin
>> through a browser or not, but whether it's configured for running on a
>> single user's desktop or on a web server that may be accessible to multiple
>> users (or people who should not be using it at all; e.g. other people on
>> the same LAN)
>>
>>
>>>
>>> rik.
>>>
>>> On Mon, Jul 29, 2019 at 4:45 AM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>
>>>> Hi
>>>>
>>>> On Sat, Jul 27, 2019 at 8:50 PM richard coleman <
>>>> rcoleman(dot)ascentgl(at)gmail(dot)com> wrote:
>>>>
>>>>> (sorry about the last missive - continued)
>>>>>
>>>>> On Sat, Jul 27, 2019 at 3:38 PM richard coleman <
>>>>> rcoleman(dot)ascentgl(at)gmail(dot)com> wrote:
>>>>>
>>>>>> Darren,
>>>>>>
>>>>>> On Sat, Jul 27, 2019 at 3:03 PM Darren Duncan <
>>>>>> darren(at)darrenduncan(dot)net> wrote:
>>>>>>
>>>>>>> Have you tried using more than one browser?
>>>>>>> that's what I've taken to doing, I have a separate install of
>>>>>>> Chromium just for pgAdmin4. I've even changed the browser command to
>>>>>>
>>>>>> "chromium-browser %URL% " so that it starts with the right browser.
>>>>>
>>>>> Although not all browsers are apparently equal. Back on 2019-06-19
>>>>> 04:10:13 Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
>>>>> wrote in response to an issue I was having under Chromium;
>>>>>
>>>>>> "I would suggest, try a different browser as well as Chromium is not
>>>>>> the
>>>>>> supported browser for pgAdmin."
>>>>>
>>>>> Which suggests that there is *a supported browser* for pgAdmin4.
>>>>> This begs the question, if there's only a *single* supported browser,
>>>>> what exactly is the point of a web app? It's like web sites that only
>>>>> worked correctly under IE6.
>>>>>
>>>>
>>>> Don't mistake the phrasing there as an implication that there's only a
>>>> single supported browser. Khushboo's first language is not English.
>>>>
>>>> We (the team at EDB, I can't speak for others) test on Chrome, Firefox,
>>>> Safari, IE and Edge. For anyone using other browsers, the first step for us
>>>> in diagnosing an issue is going to be to try to reproduce it on one of the
>>>> browsers we test with. It's not feasible for us to test with everything
>>>> that is out there.
>>>>
>>>>
>>>>>
>>>>> Developing pgAdmin4 as a *web app*/*web server* thing might make
>>>>> sense from a development standpoint, but personally I think it introduces
>>>>> way more problems than it solves.
>>>>>
>>>>
>>>> It certainly does cause some problems that we didn't have before, but
>>>> it's proven itself to solve a lot more.
>>>>
>>>> There's also the fact that running over the web is exactly what many
>>>> people want these days. I would guesstimate that we probably see something
>>>> like 50% of users we interact with running in web mode, and 50% in desktop
>>>> mode. Download-wise, the number of container pulls is far outstripping the
>>>> number of other downloads these days with Docker hub reporting > 10
>>>> million. All of those users are running in web mode as that's the only way
>>>> the container runs, so it's clear that the web app architecture is the
>>>> right thing for a significant number of users.
>>>>
>>>> --
>>>> Dave Page
>>>> Blog: http://pgsnake.blogspot.com
>>>> Twitter: @pgsnake
>>>>
>>>> EnterpriseDB UK: http://www.enterprisedb.com
>>>> The Enterprise PostgreSQL Company
>>>>
>>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>

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

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