Changelog

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.

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.

Fixed

• Numeric data types were not being correctly displayed in the grid, preventing charting and other features.
• Refresh and Edit features now work correctly in Notebooks.
• Tables and views in the DB Explorer now show in alphabetical order for MySQL/MariaDB.

Changed

• Added a Show Only Discovered Connections option to the DB Explorer.
• Preliminary support for Oracle, including Instant Client.
• Formatting provider for SQL files and notebook cells now added.
• Added a Copy Name option to the context menu when clicking on a column header.
• Added CURRENT_TIMESTAMP as a valid value for date columns when editing data.
• Added support for organizations in Neon.

Fixed

• Autocomplete correctly escapes identifiers, and does not suggest columns from other tables.
• Tunnel creation and editing can now select files from the .ssh folder when it’s hidden by the OS.

Changed

• Added a Copy Connection option to the DB Explorer.
• Added Create, Rename and Drop database for supported databases to the DB Explorer context menu.

Fixed

• Added an option to allow self-signed certificates in chain to be accepted.
• Added Docs option to Help + Suggestions.
• Added more options to the context menu in the DB Explorer.