Changelog

v0.28

v0.28.3 - (Apr 16, 2024)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.28.3

v0.28.2 - (Apr 12, 2024)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.28.2

v0.28.1 - (Nov 13, 2023)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.28.1

v0.28.0 - (Jun 22, 2023)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.28.0

v0.27

v0.27.1 - (Jan 6, 2023)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.27.1

v0.27.0 - (Jan 4, 2023)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.27.0

v0.26

v0.26.0 - (Nov 10, 2022)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.26.0

v0.25

v0.25.1 - (Sep 16, 2022)

See https://github.com/mtxr/vscode-sqltools/releases/tag/v0.25.1

v0.24

v0.24.0 - (Aug 10, 2022)

  • Extension

    • Add new Community Drivers to README.
    • UI updates. #777.
    • Use gethue as sql parser for autocomplete context. #755 - thanks to @smaspe.
    • Truncate query text not to explode result tab. #774 - thanks to @bruwozniak.
    • Update dependent packages.
    • Upgrade to NodeJS v14.
  • Formatter: 1.2.4

  • Driver: MSSQL 0.3.0

    • No changes.
  • Driver: MySQL 0.3.0

  • Driver: PostgreSQL 0.3.0

  • Driver: SQLite 0.3.0

    • Fix dependency installation problem. #757.

v0.23

v0.23.0 - (Aug 4, 2020)

  • Extension
    • Add ability to open results in external programs. #259.
    • Enhanced extension logs.
    • Reduced extension size and load time removing some dependencies.

v0.22

v0.22.11 - (Jul 23, 2020)

  • Extension
    • Enhanced auto connect messages and notifications.
    • Enhanced edit connection error message. #646.
    • Fixed race condition on plugin registration. #645.
    • Fixed blank screen on some versions. #639.
    • Fixed connection failed without provinding details. #654.

v0.22.10 - (Jun 26, 2020)

  • Extension
    • Sort label displaying column name. #445
    • Fixes webview resource. #624

v0.22.9 - (Jun 22, 2020)

  • Extension
    • Minor fixes on connection assistant UI and fixes test connection error.

v0.22.8 - (Jun 20, 2020)

  • Extension
    • Show record count even if only one page is returned. Feature request #532
    • Minor Results UI fixes.
    • Enhanced error handling for SQLite connections.

v0.22.7 - (Jun 6, 2020)

  • Extension and driver fixes
    • Fixes drivers asking for node runtime even if not required. #584
    • Release official drivers v0.0.5.

v0.22.6 - (Jun 6, 2020)

  • Extension fixes
    • Fixes resizing with RegEx filter enabled. #588
    • Fixes panel position after re-running in split. #609
    • Add Bookmark selection button to bookmarks view. #566

v0.22.5 - (Jun 5, 2020)

  • Driver updates
    • Fix data type not showing for PG, MySQL and MSSQL. #595
  • Extension fixes
    • Fixes formatting JSONB operators. #605
    • Fixes grant query formatting. #460
    • Fixes white sapace for query results. #597

v0.22.4 - (Jun 2, 2020)

  • Add boolean option sqltools.highlightQuery to extension configuration so query highlight can be disabled/enabled. #592
  • Fixes drivers not loading correctly. #600

v0.22.3 - (Jun 2, 2020)

  • Fix plugin loading failing silentily
  • Update MySQL, MSSQL, PostgreSQL and SQLite extension icons

v0.22.1 - (May 29, 2020)

  • Drop support for NodeJS 9 or older.
    • Old node versions required me to pack a bigger package and it was slower than NodeJS v10 or newer.
  • Deprecation of indent options in favor of editor options. This will make sqltools.format.indentSize unuseful and can be removed.
  • Add support to set number of lines between queries using sqltools.format.linesBetweenQueries. Default to 1. You can use preserve to keep the lines as is.
  • Renamed dialect option to driver on connection settings. Dialect still works, but will be removed on newer versions
  • Add option sqltools.sessionFilesFolder to set session files folder.
  • Add option sqltools.connectionExplorer.groupConnected to group connected connections.
  • Add Query Console panel to display messages instead of using the UI.

v0.22.0 - (May 29, 2020)

Please ignore this version. Published by mistake

v0.21

v0.21.9 - (May 27, 2020)

  • Fix
    • Fixes connection list not showing up on latest insiders build. #568

v0.21.8 - (May 25, 2020)

  • Fix
    • Add multiple hosts option to Cassandra driver. Thanks to @EpicEric. PR #577
    • Fix disappearing connections after browser refresh in Theia #530. Thanks to @ShimonBenYair. PR #554
    • Oracle DB: Improve display of RAW columns. Thanks to @daniel-liuzzi. PR #542
    • Display results for duplicate column names in Postgres and Mysql queries. Thanks to @jonestimd. PR #485
    • Update pgsql/index.js query() Catch Block. Thanks to @EdwardChapman. PR #555

v0.21.7 - (Apr 16, 2020)

  • Support
    • Announce VSCode.pro course supporting the extension

v0.21.6 - (Jan 03, 2020)

  • Enhancements

    • SQLite: Upgraded to latest npm package version. bd3b0b2.
  • Fix

    • Fix PostgreSQL testing connection always succeeds. See commit 375d3f1

v0.21.5 - (December 12, 2019)

  • Fix
    • Fix wrong checking in production code. See commit 48bb8f6

v0.21.4 - (December 12, 2019)

  • Enhancements
    • MySQL: removed getAffectedRowsCount call for mysql/xdevapi. Thanks to @frankyjuang.
    • SAPHana: hana-client uses latest version. Thanks to @ariel-bentu.

v0.21.3 - (November 06, 2019)

  • Enhancements
    • MSSQL: Fixes list functions query. Thanks to @glha.

v0.21.2 - (November 06, 2019)

  • Enhancements

    • MSSQL: Supporting MSSQL 2000 (v8.x). Thanks to @glha. #440
    • PostgreSQL: Show full error including β€œat character”. #437
    • PostgreSQL: Add support for raising notices. #417
    • Add an option sqltools.dependencyManager['autoAccept'] for preventing install dependency notifications. Read the docs. #434
    • Allow to select multiple table columns from connections tree and copy them into text editor. #406
    • Displaying query messages for DML queries. #404
  • Fixes

    • SQLite: Relative paths now based on VSCode variable ${workspaceFolder}. #430
    • Fixes query not holding execution til complete attaching to connection. #405

v0.21.1 - (October 25, 2019)

  • Enhancements

    • Improve Cassandra visualization. Issue #420
    • SQLite paths for remote development. Issue #421
    • Support for Azure Active Directory login. Issue #375
  • Fixes

    • SQLite asking for passwords. Issue #396

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 πŸŽ‰

  • 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