Changelog

v0.19

v0.19.1 - (May 20, 2019)

  • NEW 🎉

    • Add attach and detach commands to the command palette. Issue #237

  • Fix 🎉

    • Fixed session files when no folder is open. Issue #236

v0.19.0 - (May 20, 2019)

  • NEW 🎉

  • Fix 🎉

    • Fixed timestamps to be raw from server. Issue #231

    • Fixed besides results locations leaving empty space. Issue #211

    • Fixed GO delimiter breaking queries on results screen. Issue #226

  • DOCS Updates

  • Breaking Changes

    • Remove deprecated (v0.17.7) sqltools.previewLimit in favor of sqltools.results.limit.

    • Remove deprecated (v0.17.6) sqltools.connections[].dialectOptions in favor of sqltools.connections[].mssqlOptions, sqltools.connections[].pgOptions, sqltools.connections[].mysqlOptions and sqltools.connections[].oracleOptions.

v0.18

v0.18.2 - (May 9, 2019)

  • Fix 🎉

    • Add stored procedure listing on explorer for Oracle. Issue #208

v0.18.1 - (May 8, 2019)

  • Fix 🎉

    • Add escape chars for table names, schemas and catalogs. Issue #216

v0.18.0 - (May 7, 2019)

  • NEW 🎉

    • Add options to edit connections from explorer and command palette. Issue #185 and PR #209

    • Add stored procedure listing on explorer for MSSQL. Oracle is coming soon. #203

    • Add pool options for Oracle. Issue #186 and PR #204

  • Enhancements

    • Adopted support for more --vscode-editor-* prefixes to webviews.

    • Enhanced results them for JSONB in white themes. Issue #207

  • Fix 🎉

    • Fix results header not in sync with columns. Issue #201

v0.17

v0.17.18 - (May 2, 2019)

  • Enhancements

    • Error messages now has an option for quick opening docs.

    • Font fallbacks. Issue #200

    • Changed tree separators for explorer.

v0.17.17 - (april 29, 2019)

  • NEW 🎉

    • Add support for connections string for PostgreSQL and Oracle. PR #192

  • Fix 🎉

    • Fix command palette not using schemas for tables. Issue #197

    • Fix MySQL escaping for database names. Issue #196

    • Fix completions too fuzzy. Issue #193

    • Fix MySQL escaping for database names. Issue #196

v0.17.16

this package contains a packing error. Please update to most recent version.

v0.17.15 - (April 14, 2019)

  • Fix 🎉

    • Minor fix on codelens.

    • Allow to set connection on query block. See: Codelens Doc

v0.17.14

  • NEW 🎉

    • Add codelens to sql files. You can select file types to add code lens using sqltools.codelensLanguages setting. Default to ['sql']

      • Split your query blocks using @block on comments. See:

      • static/codelens.png

  • Enhancements

    • Installing dependencies now uses VSCode progress indicator notification to better notify user about installation.

    • NULL values are now centered on results table.

    • TRUE and FALSE are better displayed on results table.

v0.17.13

  • NEW 🎉

    • Enhanced connection hierarchy to allow multiple schemas and databases for Oracle, thanks to @mickeypearce

  • Enhancements

    • Generate insert queries now includes database and schema prefixes accordingly with the dialect.

v0.17.12

  • NEW 🎉

  • Enhancements

    • Updated fetch columns query to support MySQL new versions. Issue #173.

v0.17.11

  • NEW 🎉

    • Add command SQLTools.focusOnExplorer to focus on explorer.

    • Allow users to set connection icons.

    • Add stored procedure listing on explorer for PostgreSQL and MySQL. Oracle is coming soon. #74

      • static/stored-procedures.png

    • Enhanced connection hierarchy to allow multiple schemas and databases for PostgreSQL, MySQL, SQLite and MSSQL. Oracle is coming soon. Issue [#71](https://github.com/mtxr/sqltools-formatter/i

    • Enhanced connection hierarchy to allow multiple schemas and databases for PostgreSQL, MySQL, SQLite and MSSQL. Oracle is coming soon. Issue #71

      • You can flatten groups with only one child using the setting sqltools.flattenGroupsIfOne. Default to false

      • static/sidebar-explorer.png

  • Enhancements

    • Insert query generator includes column name and type on placeholders.

    • Improved query parser for better handling MSSQL queries.

    • Identifying table prefix words for suggestions.

    • Changed the icon on suggestions if it`s a view to make it visually different of a table.

    • Sorting column names by table name on suggestions.

  • Fixes

    • Fixed formatting with CRLF. Formatter issue #3

    • Fixed history cutting some query parts on history explorer.

v0.17.10

  • Enhancements

    • Improved query multiple statements parser

    • Add ssl support for MySQL. Thanks to @MOZGIII.

    • Ignoring comments on Query History tree view

v0.17.9

  • Fixes

    • Allow user to force add connection to global settings. Part of issue #137.

    • Fixed filtering excluding some values.

v0.17.8

  • Fixes

    • Fixes Icon Paths on windows. Issue #151

    • Allow empty password. Issue #150

    • Fixes cluttered database tree view. Issue #139

v0.17.7

  • NEW 🎉

    • Added Primary key Alt text and foreign key Alt text icons for PostgreSQL, MySQL, MSSQL and SQLite columns.

    • Added setting format.reservedWordCase allowing to change SQL reserved words case to upper or lower. Default is null meaning no changes.

    • Added setting sortColumns to change column sorting on explorer. Default sort is by name.

    • Added setting results.location to set results show up. Default sort is by active editor.

    • Added setting results.limit to set the limit when using Show Records function. This deprecates global previewLimit. Default changed to 50.

v0.17.6

  • NEW 🎉

    • Added option to open results rows/values in editor. Issue #140.

    • Added SSL support for PostgreSQL via pgOptions connection setting. Issue #141

    • Deprecating dialectOptions in favor of [dialect]Options settings.

  • Fixes

    • Fixed dollar quoting on formatter. Issue #142

v0.17.5

  • Fixes

    • Fixed formatter when formatting query with $1 parameters

    • Fixed #136 scroll issue

v0.17.4

  • NEW 🎉

    • Highlight result row on click.

    • Using query labels for Describe Table and Show Records.

  • Fixes 🔧

    • UI:

      • Fixed scroll issue on windows #132

v0.17.3

  • Fixes readme documentation link

  • Fixes 'server' of undefined issue. Webpack/babel issue.

v0.17.0

  • NEW 🎉

    • Added support for SQLite. #51

    • Added support for Oracle Database, thanks to @mickeypearce. #13

    • Added History Explorer on sidebar

    • Added Bookmarks Explorer on sidebar

    • MySQL Xdevapi: Added support to MySQL XDEVAPI. It fixes ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol error. (Experimental).

    • Export query results as JSON and CSV. #95

      • static/export-results.gif

    • Added feature to copy cell value and the entire row. #63

  • Fixes 🔧

    • UI:

      • Fixed results ui scroll and resize issues. #131 and #132

      • Improved more the look and feel to match VSCode Standards.

    • Connections:

      • MySQL Xdevapi: Added support to MySQL XDEVAPI. It fixes ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol error. (Experimental)

  • Breaking Changes

    • Commands:

      • SQLTools.addNewConnection command was renamed to SQLTools.openAddConnectionScreen

      • SQLTools.appendToCursor command was renamed to SQLTools.insertText

      • SQLTools.refreshSidebar command was renamed to SQLTools.refreshAll

      • SQLTools.runFromInput command was renamed to SQLTools.executeFromInput

      • SQLTools.editFromHistory command was renamed to SQLTools.editHistory

    • Settings:

      • sqltools.logging and sqltools.logLevel were removed.

      • Fixes

        • This settings were ported from Sublime Text version but were never used here.

          • SQLTools.queryTimeout not used in VSCode version.

          • SQLTools.showResultOnTab not used in VSCode version.

          • SQLTools.clearOutput not used in VSCode version.

          • sqltools.completionTriggers not used in VSCode version.

v0.16

v0.16.11

  • Enhancements

    • Connections:

      • MSSQL: Fixed trying to access 'encrypt of undefined issue'.

v0.16.10

  • Enhancements

    • General:

      • Removed some dependencies

      • Reduced startup time

    • Connections:

      • Error logging minor fix

v0.16.9

  • Enhancements

    • General: Reduced extension size from 9.8MB to ~3MB

    • Settings:

      • Added options to disable release notifications. disableReleaseNotifications defaults to false.

    • Connections:

      • MySQL: Updated library to mysql instead of mysql2. Previous was very buggy.

      • PostgreSQL: Updated library and migrated to connection pooling to avoid errors.

      • MSSQL: Updated library and migrated to connection pooling to avoid errors. Issue #126

v0.16.8

  • Fixes

    • Connections:

      • MSSQL: Fixes Requests can only be made in the LoggedIn state, not the LoggedInSendingInitialSql state. Issue #126

v0.16.7

  • Fixes

    • UI:

      • Using Octicons as suggested by VSCode team.

      • Adopted the new QuickPick API.

      • Added disconnect icon to connection-explorer

    • Connections:

      • General: quick pick not showing options if no connection active. Issue #124

      • General: Allow auto connect to multiple connections.

      • MySQL: Fixes Can't add new command when connection is in closed state. Should happen less often at least.

    • History:

      • Add option to edit item from history.

      • Updated history to show most recently used at first position

    • Query Format:

      • Fixed formatting with comments. Issue #97

      • Fixed formatting with non latin chars. Issue #99

v0.16.6

  • Fixes

    • Connections: Error while connecting => toString() of undefined

v0.16.5

  • Enhancements

    • UI: Updated extension icon and README.

    • Settings: Added settings definition for dialectOptions.

    • Connection Explorer

      • Improved to show Generate insert Query and Add to cursor only when an editor is open and editable.

      • Auto Expand connection on connect.

  • Fixes

    • Connection Explorer: Fixes tables not showing columns.

v0.16.4

  • Fixes disconnect not working. #122.

  • Auto connecting if have just one connection

  • 'Add new Server' changed to 'Add new connection'

  • Fixes show records when not connected

v0.16.3

  • Show records and describe tables when using multiple connections. #119

  • Avoid asking password for already open connection

v0.16.2

  • Minor fix. Show records infinity loop.

v0.16.0 and v0.16.1

See v0.16.x

v0.15

See v0.15.x

v0.14

Skipped.

v0.13

See v0.13.x

v0.12

See v0.12.x

v0.11

See v0.11.x