Fwd: Serious feedback and questions about the future of pgAdmin.

From: Jack Royal-Gordon <jackrg(at)pobox(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Fwd: Serious feedback and questions about the future of pgAdmin.
Date: 2017-06-11 17:42:37
Message-ID: 8D8C6A32-D026-4504-95BB-F23CCD39397A@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

First, I appreciate your tone of constructive criticism — there has been way too much negative criticism on this topic. However, as another user who has his own experiences with pgAdmin4, I feel compelled to reply regarding some of your complaints — please see my comments below.

I don’t doubt that you are experiencing this, but I do not experience increased sluggishness vs. pgAdmin III at all. The difference, I believe, is that I am running OS X on a Mac, instead of Windows 10. So this may be a program tuning problem regarding Windows 10, or it may just be that the browser rendering in Windows 10 is poor for what the developers are doing. Either way, this can be a clue as to how to address this issue.

Question for the Developers: Are you all using Windows as your main testing platform, or are most of you users of other platforms? If you’re not using Windows, then that may account for the poor performance in Windows — since most “business” work is done on Windows, it behooves you to focus on Windows performance primarily (I say this even though I was thrilled to get off Windows for so many reasons).

I have this same problem with pgAdmin III. 4 would not connect with my local server (where I have the empty password), so I cannot say if 4 has this issue.

My experience with 4 is much better than 3 here. 3 did not ever remember any context, so much so that if I had created a new server connection and got a timeout error and the program died when I tried to reopen the connection, the server would be lost and I would have to re-enter it’s properties (unless I first closed out of 3). 4 seems to at least not have that problem.

While the fault for this probably lies in the Windows rendering engine, that does impact the choice of a browser-based implementation. Can you try this on a different browser, such as Firefox or Chrome (I don’t know if that’s even possible)?

> On Jun 11, 2017, at 4:11 AM, <grekloedlc(at)tutanota(dot)com> <grekloedlc(at)tutanota(dot)com> wrote:
>
> Dear pgAdmin developers,
>
> When I first heard that you were doing a total rewrite of pgAdmin III, I was extremely excited, because I had long been frustrated with the various annoyances and bugs in that program, which I was (and am still, actually) using daily, primarily how it always felt like a chore to start up and get ready unless the server was physically located near me.
>
> So when you eventually released the first public version of pgAdmin generation 4, I very eagerly downloaded it and tried it out. Unfortunately, to claim that I was "disappointed" isn't enough; I was frankly *appalled*. I will list the reasons in a moment, but I'd first like to point out that since then, I have repeatedly tried new versions of it, hoping to see improvements, but unfortunately finding all the same issues still present (as of v1.5, 2017-06-11, at the time of typing).
>
> Here are the critical issues:
>
> 1. Extreme sluggishness. Both the GUI itself, and the fetching of data from the server, is so slow and flimsy as to drive me insane even efter using it for less than a minute. I seriously get so angry that I kill the window in disgust. I'm not trying to be insulting or overly dramatic; this is just a fact. The software makes me angry due to how slow and unreliable it seems, and how prone it is to freeze (although it recovers after a while). This is on a *very* powerful and modern x86 workstation running a very "clean" (relative) Windows 10. All other programs are responsive and fast, except for pgAdmin 4. I really feel handicapped using it, in a way that's not at all the case with the old pgAdmin III, although even that one has mysterious fetch-delays that don't seem to correspond with the amount of data pulled through the network (SSH tunnel)…
>
> 2. It doesn't remember the empty password. It just keeps on asking, again and again, for the nonexistent password, even though I've checked the box to "remember" it a million times. This is infuriating to say the least.
>
> 3. Even worse so than the old program, pgAdmin 4 also doesn't seem to remember the "last state" at all, forcing me to slowly progress through the tree hierarchy each time I start it, waiting seconds each time I click anything. This makes me just let out a big sigh each time I have to manage my databases in any way, including making simple queries in a graphical environment. What should be instant becomes a huge chore. I cannot believe that it doesn't remember the "state" of the collapsed objects until the next time.
>
> In order to say something positive, I do appreciate the cross-platformness and apparently the ability for it to run in a browser, hosted on a server. (Although I personally don't trust it or any other software to do that safely.) Sadly, this has the serious downside of extremely poor performance, at least on Windows, to the point of making it practically impossible to use.
>
> I don't wanna sound as if I'm just telling you what a terrible job you've done. I realize that in spite of these serious flaws, a lot of work must have been plowed into this project, and it's unlikely that my complaints will really be taken to heart by the people who worked on it for so long, and for free, only to then get "insulted". I feel genuinely sorry and frustrated about the whole situation, and I'm now seriously wondering what to do with my "computer life" as it is heavily dependent on PostgreSQL as the basis. pgAdmin III is aging and pgAdmin 4 doesn't seem to be going anywhere, or changing in any major ways from its current state.
>
> What are the odds that you'll forget about pgAdmin 4 and instead go straight for a "pgAdmin V", taking everything you've learned but improving on it heavily? By the way, it is extremely common for developers to first do something great, then try to improve it, but failing entirely, instead producing a monster. For example: Winamp. There are many more cases, and it seems to happen again and again. It even happened to me! I was super proud of a product that was, to me, "vastly superior" to the old one, but the users absolutely hated it, and eventually, I had to realize that while technically better in some aspects, I had just done things "differently for the sake of doing them differently". I hope you'll understand me and that I really just want a great pgAdmin tool -- not to be mean.
>
> If you have anything promising to tell me in regards to any of this, I'd like to hear it. In the past, I've looked through the miserable "alternatives", so it's probably pointless to tell me about any of those, but if there is some sort of alternative that you know of, which is heavily polished and maintained and trusted and free of charge, it would definitely be interesting to me. However, I very much doubt that anything like that exists, and I doubt that this is the best place to ask for that. In fact, it's probably considered rude...
>
> // A long-time pgAdmin user who'd hate to see this crucial tool go the same way as so many other now-dead programs.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Pawel Hadam 2017-06-11 22:34:24 Re: Serious feedback and questions about the future of pgAdmin.
Previous Message grekloedlc 2017-06-11 11:11:39 Serious feedback and questions about the future of pgAdmin.