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.
Setting the autocomplete delay to 0 would display autocomplete after most-every keystroke.
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.
About the author — Kyle Hankinson is the founder and sole developer of SQLPro Studio and the Hankinsoft Development suite of database tools. He has been building native macOS and iOS applications since 2010.
Try SQLPro Studio — A powerful database manager for MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Oracle, and Snowflake. Available on macOS, iOS, and Windows.
Download Free Trial View Pricing Compare