Changelog

v0.28

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
- Support PostgreSQL c-style escape strings in formatter. #935 - thanks to @sivaramasubramanian.
- Support PostgreSQL @@ operator in formatter. #936 - thanks to @remlse.
Driver: MSSQL 0.3.0
- No changes.
Driver: MySQL 0.3.0
- Sort databases alphabetically. #706 - thanks @mattschlosser.
Driver: PostgreSQL 0.3.0
- Add Cockroach as an alias. Thanks @ultram4rine.
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
- Enhanced speed removing cycle references. Thanks to @ariel-bentu. PR #233

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 🎉
- Multiple connections with session files. PR #188
  - Read the docs: Sessions and Multiple Connections
- Added support for SAP Hana, thanks to @ariel-bentu. PR #215
- Multiple results screens, one per connection. PR #234
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
- Add SSL example to PostgreSQL docs. Thanks to @lawrencegripper. PR #223
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
  - Thanks to @zetxx
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:
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/driver/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
- 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
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 and foreign key 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
- 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

Changelog

v0.28

v0.28.3 - (Apr 16, 2024)

v0.28.2 - (Apr 12, 2024)

v0.28.1 - (Nov 13, 2023)

v0.28.0 - (Jun 22, 2023)

v0.27

v0.27.1 - (Jan 6, 2023)

v0.27.0 - (Jan 4, 2023)

v0.26

v0.26.0 - (Nov 10, 2022)

v0.25

v0.25.1 - (Sep 16, 2022)

v0.24

v0.24.0 - (Aug 10, 2022)

v0.23

v0.23.0 - (Aug 4, 2020)

v0.22

v0.22.11 - (Jul 23, 2020)

v0.22.10 - (Jun 26, 2020)

v0.22.9 - (Jun 22, 2020)

v0.22.8 - (Jun 20, 2020)

v0.22.7 - (Jun 6, 2020)

v0.22.6 - (Jun 6, 2020)

v0.22.5 - (Jun 5, 2020)

v0.22.4 - (Jun 2, 2020)

v0.22.3 - (Jun 2, 2020)

v0.22.1 - (May 29, 2020)

v0.22.0 - (May 29, 2020)

v0.21

v0.21.9 - (May 27, 2020)

v0.21.8 - (May 25, 2020)

v0.21.7 - (Apr 16, 2020)

v0.21.6 - (Jan 03, 2020)

v0.21.5 - (December 12, 2019)

v0.21.4 - (December 12, 2019)

v0.21.3 - (November 06, 2019)

v0.21.2 - (November 06, 2019)

v0.21.1 - (October 25, 2019)

v0.21.0 - (September 19, 2019)

v0.20

v0.20.3 - (August 31, 2019)

v0.20.2 - (August 15, 2019)

v0.20.1 - (August 12, 2019)

v0.20.0 - (August 11, 2019)

v0.19

v0.19.7 - (July 24, 2019)

v0.19.6 - (June 26, 2019)

v0.19.5 - (June 7, 2019)

v0.19.4 - (June 1, 2019)

v0.19.3 - (May 30, 2019)

v0.19.2 - (May 24, 2019)

v0.19.1 - (May 20, 2019)

v0.19.0 - (May 20, 2019)

v0.18

v0.18.2 - (May 9, 2019)

v0.18.1 - (May 8, 2019)

v0.18.0 - (May 7, 2019)

v0.17

v0.17.18 - (May 2, 2019)

v0.17.17 - (april 29, 2019)

v0.17.16

v0.17.15 - (April 14, 2019)

v0.17.14

v0.17.13

v0.17.12

v0.17.11

v0.17.10

v0.17.9

v0.17.8

v0.17.7

v0.17.6

v0.17.5

v0.17.4

v0.17.3

v0.17.0

v0.16

v0.16.11

v0.16.10

v0.16.9