SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
ES: Connections, Bookmarks, hotkeys

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
ES: Connections, Bookmarks, hotkeys
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post ES: Connections, Bookmarks, hotkeys Reply with quote
The new Connection Organizer (this is the Connections pane, right?) works like a charm, it's much faster to search for a specific server and/or open a new tab to that server this way. However, there are a few things that might be improved:
1. The connection settings under SA Options > DB Options > DB Connections have a checkbox for each connection that allows to temporarily (or even permanently) disable some connections so that the archived/seldom used connections do not clutter the list of connections in the Connect to dialog. The Connection Organizer disregards the state of these checkboxes and displays the disabled connections. They can be clicked, however, they are actually disabled, and the connection will be made to the server that is set in the SA Options > Targets > Registered Targets > Auto Connection for the editor used, without any warning about what is going to happen instead of the expected outcome.
2. Being able to organize the connections to folders comes in handy. The filter is even better. But there is a great deal of untapped potential here too. For example:
- that filter could use the different name-matching methods available elsewhere.
- it could also have a user-assignable hotkey to move the focus to the filter (IMHO, frequent switching between keyboard and mouse is the greatest enemy of efficiency). This hotkey could also show the Connections pane in case it is not shown yet.
- pressing "Enter" on it could move the focus to the filtered list, where pressing "Enter" again on the selected target could open a new connection to that target. Hitting "Esc" instead could return to the editor (or to filter).
3. The process of organizing is rather cumbersome.
- moving the items between folders can be done using drag-and-drop, but reordering them can't. You have to use the up and down arrow buttons instead but using them will only move the selected item to one place up or down and then make that item lose focus, rendering those buttons disabled until the item is re-selected. Very slow.
- moving the items is a one-by-one exercise, you have no option to select multiple items using Ctrl or Shift + clicks to move the selected ones at once. Having dozens of connections makes the time required to set up the initial folder structure took several minutes instead of the mere seconds it would need otherwise.
4. The connections can be assigned connection color and that is visible in the Connect to dialog, thus picking the desired connection or simply filtering using MK1 eyeball is pretty fast. It would be nice if the Connections had this nice feature as well.

The Bookmarks pane is hidden under Search > Bookmarks without a hotkey. It also takes up a lot of space on the screen. I tried undocking and moving it to another screen but it didn't really work well, having to glance to the other screen where the floating bookmark window might or might not stand out of the background can be pretty disruptive to the workflow. It could have a toggle-type hotkey instead that would toggle the visibility of the pane so it could be quickly shown and hidden when needed. Actually, several other panes could be better by having a toggle-type hotkey instead of simply showing them, eg. History, Code Structure, Bird's Eye. The one that could benefit the most would be the Results pane. The hotkey for Close All Assistant Windows kills that one quickly but that pane cannot be re once removed, that is, without re-running the query that produces it and having to resize it using the mouse is just... well... slow.
Wed May 03, 2023 5:42 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
Noted. Thank you. I will convert your feedback to a couple of separate tickets.

For the bookmarks pane, you can try downsizing it. The live bookmark images will get smaller and take less space, but of course it's part of the same dock, so other panes in the dock will get resized too. You may want to try docking it to the right side and then resizing to a thumbnail size, and see if that works better for you.
Wed May 03, 2023 8:40 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
I've tried docking it to the right side of the editor but it's competing with the Connections pane for that area and so far Connections is winning. Having them both active at the same time takes up too much space. Bookmarks is not something I frequently use because it uses hotkeys that are somewhat inconvenient to use on my keyboard.
Thu May 04, 2023 3:29 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.