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.
1.3.14
Fixed
SQL Server 2016 now works with the DB Explorer.
1.3.13
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.
1.3.11
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
1.3.10
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.
1.3.7
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.
1.3.6
Changed
Table creation and editing is now working, with change preview.
1.3.3
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
1.3.2
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
1.3.1
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.
1.3.0
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.
1.2.16
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.
1.2.14
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.
1.2.8
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.
1.2.7
Changed
Added a Help + Suggestions panel to the sidebar.
Fixed
MySQL 5.7 introspection error when user does not have create permissions on the database.
Redshift was not showing columns in late binding views.
If introspection fails, the connection will still be allowed to be opened.