Multi-cursors

Posted by Kyle Hankinson September 23, 2020


SQLPro supports multiple cursors. This allows a users to perform certain actions with fewer keystrokes.

There are two different ways available to select multiple cursors. The first, is by holding Option while dragging the mouse cursor up or down between lines.

The second method is by using the keyboard shortcut Command + Option along with ↑/↓.

Once multiple cursors have been selected, the following keyboard shortcuts are available.

  • ←/→ to move text selection to the left and right one character.
  • Option + ←/→ to move text selection left/right one word.
  • Shift + ←/→ to move and highlight text selection to the left and right.
  • Shift + Option + ←/→ to move and highlight text selection left/right one word.
  • Cmd + Delete to delete from the curors beginnings to the end of the next word.
  • Option + Delete to delete from the curors beginnings to the end of the line.

Any feedback or issues with multi-cursor support should be added to the origional request ticket.


Tags: Feature

Server based results sorting

Posted by Kyle Hankinson August 12, 2020


Overview

Server based results sorting is a helpful and quick way for users to sort all results from a table without needing to write SQL. As of SQLPro v2020.71 is has been enabled by default. Using it is easy as can be. Simply click the header of a result set. The updated sort statement appear 'ghosted' in your query.

How to disable

Server based sorting can be disabled via the 'SQLPro' -> 'Preferences' menu item. Once the preferences dialog is visible uncheck the 'Server based results sorting'.

Notes

Server based sorting only works for simple queries. If the query is complex, then the results will be sorted locally using the 'in memory results'.


Tags: Feature

Autocomplete delay

Posted by Kyle Hankinson June 30th, 2020


The autocomplete delay option is a perference which allows users to determine the time it takes for the autocomplete window to be displayed when typing in the query editor. It can be found on the General page of SQLPro Preferences.

The default autocomplete delay is 1.25 seconds. With the delay, autocomplete would appear as follows.

autocomplete default

Setting the autocomplete delay to 0 would display autocomplete after most-every keystroke.

autocomplete default

Exceptions

When entering a database, schema or table, followed by a period, such as:

SELECT * FROM myDatabase.

Autocomplete will instantly appear showing all children of the parent object.

Autocomplete will also not appear automatically after the following characters: ;\"),

It has generally been found that users tend to want whitespace (such as a newline, space, tab, etc) after those characters. Autocomplete can still be triggered by hitting escape.


Tags: Feature