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.

1.2.6

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.

1.2.5

Changed

  • Added support for DigitalOcean cloud provider.
  • Added option to open a GitHub issue when connection and introspection errors occur.

Fixed

  • Added a check to ensure duplicate connection IDs are not present in settings.json if edited manually.

1.2.4

Changed

  • Charts now appear beside the results, not on top of them.

Fixed

  • Inline code completions via Copilot now work correctly.
  • Download chart button now works correctly.
  • Redshift was not showing all columns in a view in the DB Explorer.

1.2.3

Changed

  • Relationships now support multi key relationships, and the expanded relationship icon will be highlighted and stay visible when the relationship is selected.
  • Added a connection option to disable public key retrieval for MySQL and MariaDB, which is enabled by default.
  • If a connection has a color, it will be used for the highlight color (e.g., primary keys, active icons) instead of the default purple.

1.2.2

Changed

  • Data relationships are now navigated using an icon in the cell when mousing over, instead of the expand icon in the first column.

Fixed

  • Postgres (and derivatives like Redshift) would show duplicate tables in the DB Explorer if the table name was in multiple schemas.