pgadmin-org
Major Pain: Make the connection lost warning an option
Describe the solution you'd like
My connections to the database the drop relatively quickly.
So I'm constantly getting the "Connection Warning: Cancel/Continue" message box.
E.g., During the daily development and support of my application I may have a half dozen select queries (or "View/Edit Data" | "Filtered Rows") windows open, at any time.
And every time I dive into the code to look up a potential bug, or spend time responding to a support email, the connections to the database will frequently time out.
So when I switch back to pgAdmin, I have to click through the "Connection Warning: Cancel/Continue" message box, on all my query tabs. This can happen a dozen times a day.
So I'm frequently seeing this dialog 50 times a day, which is over 10000 times per year.
I understand from previous chats with Dave Page that it is possible that some databases might be configured to do something special when a connection happens, so the dialog has to be shown to prevent that connection side-effect from happening.
But... I've had to click through this dialog 10000 times this year, 10000 times last year, 10000 the year before (and for the last 12 years!), and I'll have to click through it 10000 times next year, and 10000 times the following year... and never EVER will I do anything other than click "Continue".
Given that the scenario Dave is concerned about is probably pretty rare, can we not just provide a preference to auto-reconnect, so those of us who don't have to worry about connection side-effects don't have to have our workflow interrupted by this irrelevant dialog time tens of thousands of times.
Describe alternatives you've considered
Add a new "Auto reconnect" toggle switch (default = off, so as not to change the behaviour for existing users), under "File" | "Preferences" | "Query Tool" | "Options".
Additional context
The usability of pgAdmin used to be awful, but it has wonderfully improved over the last few years. Awesome! This is now probably one of the biggest remaining usability impediments (i.e., 10000 unnecessary clicks, per year).
I would go further and make it a per-server configuration, not global.
And yes, disabled by default, but available if you know there is no problem with just auto-reconnecting transparently.
Even better if there would be another button in this dialog saying something like "Autoreconnect and don't show this again".
