Changelog

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

Fixed

• Autocomplete now works with more complex Select statements (nested selects, alaised tables, etc).
• Autocomplete now works with Delete statements.
• Autocomplete now works with Insert statements, including nested selects.

Changed

• New Charts added to the chart menu.
• Option to expand/shrink the chart. #37

Fixed

• Selecting MySQL for a MariaDB could lead to incorrect introspection being used, this is now fixed.
• Tables named after SQL Keywords (eg user) were not editable.
• Grid lines now show when enabled in a chart. #34
• Autocomplete now suggests operators and multiple condition where clauses.

Fixed

• SQL Server 2016 now works with the DB Explorer.

Changed

• Data can now be changed without signing in/purchasing a subscription, however changes are not verified before applying them when not signed in/subscribed.
• Updated the new connection UI.
• Add the count of items in each “folder” in the DB Explorer.

Fixed

• Introspection is now supported on MariaDB 10.3 and above.

Changed

• Groups can now be renamed in the DBExplorer. #73

Fixed

• D1 now shows views.
• Introspection is now supported on MariaDB 10.0 and above. #74 and #71

Changed

• Table DDL editing now uses transactions where appropriate.
• Custom theme extensions are now supported for syntax highlighting in the table editor.

Fixed

• MongoDB connections can now be created without a username. #70
• MariaDB 10.5 or higher is required.

Changed

• Changes preview in the table editor now matches the VSCode theme for the built in themes.

Fixed

• Retrying a failed connection in the DB Explorer now works.
• Applying table changes now works.