Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Major Pain: Make the connection lost warning an option #8279

Open
usernamesareaholdoverfromthe90s opened this issue Dec 18, 2024 · 0 comments
Labels

Comments

@usernamesareaholdoverfromthe90s

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).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: No status
Development

No branches or pull requests

1 participant