v0.9.12

Improvements

• Snowflake (snowsql) support
• Added support for prompting of the connection parameters
• Table/view/function selection quick panel is pre-populated with the text of the current selection
• New command ST: Refresh Connection Data (internal name st_refresh_connection_data) to reload the list of database objects
• Improve performance (completions and connection listing)
• Add a configurable setting to enable/disable completion for certain selectors (autocomplete_selectors_ignore, autocomplete_selectors_active)

Fixes

• Fix PostgreSQL v11 compatibility issue (functions were not listed)
• Do not create an empty settings file [#144]
• Bump timeout to 60 seconds for internal commands
• Use python core logging for logs

v0.9.11

Fixes

• New SQLTools command ST: Format SQL All File (internal name st_format_all) to format the entire file [#182]

v0.9.10

Fixes

• Added focus_result setting closing issue [#183]

v0.9.9

Improvements

• Use utf-8 encoding if Connection encoding is not a valid Python encoding

Fixes

• Exception when Connection encoding is set to null [#177]

v0.9.8

Improvements

• Add MSSQL support via native sqlcmd CLI
• Add more options for expanding the empty selection. Instead of config option expand_to_paragraph, introduce new option called expand_to, which can be configured to expand empty selection to: line, paragraph or file
• General review/improvement of each DB config
• Use the encoding option supplied in connection settings when writing to standard input and reading from standard output of CLI command
• Changes how top level and per-query options apply to CLI invocations
• Changes how before and after applied (top level and per-query)
• Introduction of new execute named query section which is used when executing statements with ST: Execute and friends
• Now all named query formatting is done via str.format(), therefore all instances of %s in template strings got replaced with {0}, with back-patch support (i.e. %s should still work for those users who have it on their own user config)
• Improve the way the output is shown - the output panel is not shown until the first output from DB CLI arrives
• Add sample connections for Vertica and Firebird
• [PostgreSQL] Connection options host, port, username are now optional (can be set via environment vars and other means)
• [MySQL] Add configurable connection option default-character-set
• [MySQL] Add --no-auto-rehash and --compress to improve MySQL startup time and improve latency on slow networks
• [MySQL] Connection options host, port, username are now optional (can be set via --defaults-extra-file and --login-path)
• [MySQL] Supply password via environment variable MYSQL_PWD to avoid security warning
• [Oracle] Add ability to configure NSL_LANG to match the server encoding
• [Oracle] Add support for quoted table and column names
• [Oracle] Add support for functions & procedures completions as well as getting and functions & procedures definitions (both top level and those in packages)
• [Vertica] Add support for quoted identifiers
• Other minor improvements

Fixes

• Remove unused settings option unescape_quotes from config

v0.9.7

Fixes

• Completions not working with identifiers containing $ symbol [#152]

v0.9.6

Fixes

• [MySQL] Added basic backtick escaping of identifiers [#147]

v0.9.5

Improvements

• New Feature: List and Insert Saved Queries (ctrl+e ctrl+i) [#126]
• Better error messages if settings json file could not be parsed

Fixes

• Display completions for upper case aliases [#142]
• Fix the display of status bar message when query is executed [#130]
• Open Saved Queries executed the query if not connected to a database prior [#125]

v0.9.4

Improvements

• Execute All File [#114]
• Configurable top/bottom show_query placement [#116]
• [Oracle] In addition to tables views are listed as well (Describe Table works with views) [#115]

v0.9.3

Improvements

• [Oracle] Get identifiers (tables, columns) in all schemas #112