1.3.18

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

1.3.17

Fixed

  • Parser error when loading tables from DB Explorer. #90

1.3.16

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.

1.3.15

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.

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.