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 🎉

  • 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