Changelog

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.

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

Fixed

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

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.

Changed

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

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

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

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.

Changed

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

Fixed

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

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

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.

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

Fixed

• SQL Server tables were not editable. #93
• MariaDB 10.4 and below connections did not work if the driver was set to MySQL. #86

Fixed

• Parser error when loading tables from DB Explorer. #90