CHANGELOG.md

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 🎉

  • 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/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
    • 
  • 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