Changelog

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

Fixed

• Autocomplete ignores case when matching tables and views. #51
• History filter now works correctly in flat view.
• History from cloud providers now shows the correct name of the connection and provider in the history.
• History is limited to 5 records per database in core edition.
• SQLite now works on code-server and other non electron based environments.

Changed

• Added a Create Table, Alter Table, Rename Table, Truncate Table and Drop Table commands to the DB Explorer (Create/Alter are just preview for now, changes wont be saved!).
• Notebooks now use the extension .dbcnb rather than .dbcode.
• Identity/Autoincrement columns now show that in the default value in the DB Explorer.
• Data editing now supports enum fields with a dropdown list of the values.
• Execute keyboard shortcut changed to Ctrl/Cmd+Enter.
• DB Explorer now has a filter to search for for strings on connected databases. #42

Fixed

• SQL Server and Azure now show comments for tables, views and columns
• Fixed Postgres tables with ” in the name not being recognized as editable in the table.
• Autocomplete now suggests views where appropriate.
• Autocomplete now suggests schemas where appropriate.