You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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).
The text was updated successfully, but these errors were encountered:
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).
The text was updated successfully, but these errors were encountered: