Changelog

Changed

• Relationships: Browse foreign key relationships in data to view related data in other tables.
• Edit data and access relationships for your select queries.
• Aiven cloud provider added.

Fixed

• PostgreSQL showed duplicate columns in the foreign key when a foreign key had multiple columns.
• SQLite did not show columns in the explorer whose names matched the table name.

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.

Fixed

• Codelens now indicates whether you are executing a selection or the entire document.
• libSQL now supports encrypted local files.

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

Changed

• Cloud providers support added. (more details)

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.

Changed

• Table creation and editing is now working, with change preview.

Changed

• Added (null) to the drop down menus when editing a field that allows null.
• Added a Set Value menu item to the context menu for editable cells. #47

Fixed

• Fixed Oracle introspection to use all_x and work with user level privileges. #58
• Added string and number to D1 data types. #64

Changed

• MongoDB now supports user code in the editor. #55

Fixed

• DB Explorer filtering now expands items correctly, and works with cloud providers. #42
• Autocomplete now works again in Notebooks. #56
• Trimmed long column comments in the Hover help. #50