SQLTools
Welcome
Getting StartedChangelogv0.21v0.20v0.19v0.18v0.17v0.16v0.15v0.14v0.13v0.12v0.11

Changelog

v0.21

v0.21.0 - (September 19, 2019)

  • New 🎉

    • New Icons! Using outline icons design to match VSCode icons.
    • New connection assistant! PR #368
      • Added possibility to test connections before saving. Issue #184
    • Add new drivers tool! PR #387
      • Now it will be easier to add new drivers. Check out the docs.
    • Added Cassandra driver! Special thanks to @EpicEric. PR #379
  • Enhancements

    • Displaying rowversion for SQL Server as HEX. Issue #344
    • Revamp some Connection Explorer code to make it faster. This is the first step of #322
  • Fixes

    • SQL Server connect string fixed some bug scenarios . Issue #356

v0.20

v0.20.3 - (August 31, 2019)

  • Enhancements

    • Better rendering for JSON fields on results screen. Issue #327
    • Add connection options to SAP Hana. Special thanks to @ariel-bentu. PR #346
    • Support views for SAP Hana. Special thanks to @ariel-bentu. PR #347
    • Oracle driver updated to v4. Thanks to @mickeypearce. PR #310
  • Fix

    • Fix click connection on explorer triggering to connect twice. Issue #328
    • Fix bigint casting/rounding issue for MySQL 5.7. Issue #334

v0.20.2 - (August 15, 2019)

  • Fix
    • Minor fix on MariaDB version checking. Issue #332

v0.20.1 - (August 12, 2019)

  • Fix
    • Minor fix on webpack config causing MySQL connections not to work. Issue #325

v0.20.0 - (August 11, 2019)

  • NEW 🎉

    • Upgrades on results screen UI. Moved from react-table to @dx/react-grid to support new enhancements. PR #12
  • Enhancements

    • Added option sqltools.languageServerEnv to allow user to add environment variables to the language server. Issue #281
    • Adde connection in progress indicator. Issue #229
  • Fix

    • Fix beautify server variables for MSSQL. Issue mtxr/sqltools-formatter/#12
    • Fix listing functions in MySQL older then 5.5. Issue #304
    • Fix escaping columns on SQLite. Issue #309
    • Fix regex search on results window. Issue #302
    • Fix oracledb/sqlite dependencies and node runtime message on new VSCode versions. Issue #318
    • Fix bookmarks snippet in wrong order. Issue #258
    • Minor fixes on MySQL v5 or older connections. Issue #304
    • Minor fixes on MySQL escaping tables names code. Issue #309

v0.19

v0.19.7 - (July 24, 2019)

  • NEW 🎉
    • Add run, bookmark and format selected query to context menu
  • Fix 🎉
    • Reopen existing session file when reconnecting. Issue #283
    • Small changes on high contrast themes. Issue #286

v0.19.6 - (June 26, 2019)

  • Fix 🎉
    • Codelens connection switch. Issue #270
    • Bookmarked query changed on edit. Issue #278
    • SQLTools blocking output of test cases for other extensions. Issue #273

v0.19.5 - (June 7, 2019)

  • NEW 🎉
    • Add support for AWS Redshift. Issue #264

v0.19.4 - (June 1, 2019)

  • NEW 🎉
    • Dialect configs extended to match connector options. Issue #235
    • Oracle data types in stored procedures. Thanks to @mickeypearce. PR #260

v0.19.3 - (May 30, 2019)

  • NEW 🎉

    • Upgrade SQLite lib to 4.0.8 to support NodeJS v12. Issue #256
    • Add/edit SQLite connections will be relative to workspace. Thanks to @mitchellsimoens. PR #255
  • Fix 🎉

    • Fixed edit connection not using existing port. Issue #224
    • Fixed column filtering breaking results screen. Issue #251
    • Fixed results screen taking focus after running query. Issue #254
    • Fixed saving results using editor button. Issue #257

v0.19.2 - (May 24, 2019)

  • Fix 🎉

    • Fixed explorer tree when tree items have dots. Issue #242
    • Hiding sqlite_sequence from explorer. Issue #152
  • Enhancements

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 🎉

    • Add some options to customize results screen. Issue #174. Eg:
      ...
      "sqltools.results": {
      ...
      "customization": {
      "font-size": "12px",
      "font-family": "monospace",
      "table-cell-padding": "2px 4px"
      }
      },
      ...
    • Allow connecting to MySQL using Socket files. Issue #163. See https://vscode-sqltools.mteixeira.dev/connections/mysql#1-connections
  • 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