dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
39.5k stars 3.42k forks source link

Easier/faster ways to change active schema/connection #21724

Open Tix2garr opened 11 months ago

Tix2garr commented 11 months ago

Is your feature request related to a problem? Please describe. I am often changing the schema (database) and/or connection on a script between 2 different databases and/or servers. Would like to make this a little easier.

Issue 1: With "Select active connection" (as labeled in Preferences > User Interface > Keys)/"Select Data Source" (as labeled in the title of the window that shows up), the cursor automatically goes to the filter textbox at the top and the user can start typing to filter the connection names. But typing more than one word seems to confuse it. For example, I have "Set 1", "Set 2", "Set 3", "Set 4" as connections. Typing "Set" obviously gives me all of those. If I add a space, so it is "Set ", all of the connections disappear, then if I finish with 4 so it is "Set 4", everything with Set in it shows up, instead of only "Set 4". If I have more than one entry in the list and I tab from the filter textbox and I have connection folders, it goes to the first folder not the first connection inside that folder.

Issue 2: With "Set active schema" (as labeled in Preferences)/"Choose catalog/schema" (as labeled in the window title), the cursor automatically goes to the list of catalog/schemas. If I start typing there, it doesn't do anything. I have to tab down to the search textbox and start typing and that filters the list just fine. If I'm down to just one database and hit Enter to select it, nothing happens. I understand what the up and down arrows are supposed to do, but they don't seem to do anything.

Describe the solution you'd like Issue 1: A) It would be nice if the description in Keys is the same as the window. B) Have the filter work on all that has been entered, not just the first word. C) When tabbing down from the filter textbox, go to the first connection, not a folder.

Issue 2: A) It would be nice if the description in Keys is the same as the window. B) Have this window work like the "Select Data Source" window with the improvements listed above. So... Filter textbox at the top that gets focus upon opening. Filters as you type (both do currently). If there is just one database shown, hitting Enter selects it. Have some of the additional features here as well like show connected databases only. Not sure if the others would apply or not.

Describe alternatives you've considered 1) Keyboard shortcuts for specific connection or connection/database. (Not sure how you might do that.) I.e. Ctrl+Shift+5 sets the active window to Set 5, database Marvel_Heroes. Ctrl+Shift+6 sets the active window to Set 1, database selected is the default for Set 1. 2) Allow creation of toolbar entries for specific connection or connection/database. I.e. A toolbar button to set the active window to Set 5, database Marvel_Heroes. A toolbar button to set the active window to Set 1, database selected is the default for Set 1.

Additional context Great program, guys!! :-)

ShadelessFox commented 9 months ago

Hello @Tix2garr,

Sorry for the long wait.

Thanks for the feature request! We will consider your suggestions :^)