1.4.17

Changed

  • Preview of Snowflake support. #113

1.4.15

Changed

  • Added a setting to control the date/time format. #85
  • Added a setting to control if dates should be shown in your computers local time, or UTC when timezone information is present. #85
  • Changed Postgres supported version to 9.5 or higher. #129

Fixed

  • Maria text fields were showing as binary.
  • Postgres introspection error on version 9.5 through 10. #129

1.4.14

Changed

  • Datetime columns with timezone information now show in the local time. #85
  • Datetime columns now display in the locale/region format of the computer. #85
  • Editing a datetime column will highlight the cell in red if the value does not parse.
  • Datetime columns that are edited are converted to ISO format when sent to the database.

Fixed

  • Tab did not set the cell value when editing data and the cell contained a drop down.

1.4.13

  • Keybinding to show DB Explorer does not break find next (cmd/ctrl+d). #121
  • Executing tabs can be closed, will prompt to cancel execution. #125
  • Potential fix for Postgres queries not returning. #125
  • Bit fields handled correctly in the data editor.

1.4.12

Fixed

  • SQL Server was not handling UTF strings correctly in data changes.
  • Checkbox removed from the table editor.

1.4.11

Changed

  • Moved create database context menu item to the Connection in the DB Explorer.
  • Added context menu item to add a connection to a group.

Fixed

  • Connection error with MariaDB 10.5 through 10.6.10.
  • Added OUTPUT clause to procedure parameters.

1.4.10

Changed

  • Added a fallback autocomplete to use when parser cannot parse the SQL.

1.4.9

Changed

  • Prevented autocomplete from suggesting a lot of syntax, single character tokens.

Fixed

  • Tables with foreign keys across schemas would not open correctly in the grid detail feature.
  • Tables with foreign keys to tables in other schemas which the user did not have access to caused an error. #118
  • Change MongoDB to use direct connection when not using SVR protocol. #119

1.4.8

Changed

  • Added cmd+d,cmd+b and ctrl+d,ctrl+b hotkeys to show the DB Explorer. #106
  • Improved autocomplete suggestions, including support for update, and common table expressions.
  • Added autocomplete support for EXEC procedure statements.
  • Autocomplete will work if statements are not seperated by a semi-colon. #46

1.4.7

Changed

  • Added cmd+f and ctrl+f hotkeys to search the grid. #106
  • Added support for JOIN, GROUP BY, HAVING, and ORDER BY to autocomplete. #59

Fixed

  • Azure Entra ID authentication was not refreshing the token.

1.4.6

Changed

  • Diagrams now show the primary key icon as highlighted.
  • Diagrams can now be saved as PDFs or PNGs. #38

1.4.4

Fixed

  • Postgres better detection of users access to databases when connecting. #105
  • Postgres errors not being raised when unable to connect to the server.

1.4.3

Changed

  • Binary cells can now have files loaded directly into them when editable. #104
  • More values are present in the Set Value menu for editable cells. #76

1.4.1

Fixed

  • SSH Config that failed parsing would cause the extension to crash.
  • Creating tables with single primary key column is now inlined in the DDL.
  • LibSQL was not showing the table structure for empty tables.
  • Creating tables in Cassandra with dual primary keys was producing invalid DDL.
  • Creating tables in Oracle with identity columns and single primary keys was producing invalid DDL.

1.4.0

Changed

  • Added Cassandra as a NoSQL database. #83
  • Added DuckDB as a SQL database. #106

Fixed

  • Fixed introspection query for MySQL 8 that was breaking the SQL parser in MySQL. #100
  • Boolean field editing caused an error. #102