0.12.3

Changed

  • Added an option to import from a connection string when adding or editing connections.
  • Added zero-config functionality to automatically detect connections in .env and web.config files. (more details)
  • Added compass (discovered) icons to the tunnels and connections that are automatically discovered.

Fixed

  • Fixed an issue where SQLite connections would not store the file path when edited in some cases.
  • PostgreSQL is the default connection type when adding a new connection.

0.12.2

Fixed

  • Updated Microsoft Authentication to use common tenant.

0.12.1

Changed

  • Added license information, customer portal and license purchasing to Account view.

0.12.0

Changed

  • Added option to securely share reports.
  • Added an Account view to enable authentication via VSCode authentication providers, necessary for secure report sharing.
  • Added image preview when hovering over image in binary field.

Fixed

  • Mongo protocol was not correctly saved when editing a connection.
  • Editing connections in groups would cause them to ungroup.

0.11.2

Changed

  • Binary fields containing images now display thumbnails in the results.
  • String fields exceeding 500 characters are trimmed, displaying the total size at the end.
  • Tooltips added for all result columns with values longer than 200 characters/bytes.
  • Options to export all results, a selection, or selected rows.
  • Export results in various formats: CSV, Excel, SQL insert statements, JSON, XML, Markdown, or HTML.
  • Copy a selection or selected rows as text, CSV, SQL insert statements, SQL In Clause, JSON, XML, Markdown, or HTML.
  • Added the ability to duplicate rows when editing results.
  • Context menu includes options to add, duplicate, and delete rows if the results are editable.

0.11.1

Fixed

  • Marketplace listing colors.
  • Number rounding on tab badges.

0.11.0

Changed

  • SQLite support added.
  • Added option to explore with a sample database.

Fixed

  • The results table now better aligns with the VS Code theme.
  • Fixed an issue where editing stored procedures incorrectly indicated an error had occurred.
  • MySQL did not correctly handle integers bigger than the javascript limit.

0.10.0

Changed

  • MongoDB support added (table loading, data editing completed, work continues on executing arbitrary statements).
  • Added data type to column headers.
  • Trimmed large data in binary cells to show first 50 characters, and total size.
  • Added output channel and logging of connection and tunnel events.

0.9.3

Changed

  • Added a key binding (Ctrl/Cmd+d Ctrl/Cmd+c) to select/change connection of the current file.

Fixed

  • Improved the rendering performance for large result sets (1M+ rows).
  • MySQL/Maria was showing undefined in the statusbar for schema.
  • MySQL/Maria was not showing correct number of rows updated for insert, update and delete statements.
  • Geometry and Geography data types in results caused the results not to show.
  • Dates with timezones are now displayed with timezone indicators to reflect their true format in the database.

0.9.2

Changed

  • Automatically generate entity relationship diagrams to visually map out your database structures. Simply right-click on the tables folder of a database and select the “Entity Relationship Diagram” option.

Fixed

  • Light themes were not showing the correct database icons for MariaDB in the connection picker.

0.9.1

Fixed

  • Tables now always open with the maximum row limit configured in settings (100,000). Right-clicking on a table provides an option to open it with a different limit.
  • SQL Server connections failed unless the user account had the sysadmin role assigned.

0.9.0

Changed

  • Data within a table can now be edited, added, or deleted, with changes saved directly back to the database.

Fixed

  • Opening a table sometimes did not render the data.
  • SQL Server displayed incorrect lengths for nvarchar and nchar datatype columns.

0.8.2

Changed

  • Clicking on a table or view in the explorer now loads its data in a new tab.
  • Added setting dbcode.maxRowsToFetch to control the maximum number of rows fetched when opening a table.

0.8.1

Changed

  • Added SSH Tunnels. Tunnels are automatically detected from ssh.config and can also be manually created.
  • Introduced a table icon to the results tab; clicking on this icon will pin the tab for easy access.

Fixed

  • Postgres: Ensure columns in indexes are displayed in the correct order, even when they differ from the table order.

0.8.0

Changed

  • MariaDB support added.

Fixed

  • MySQL connections required SSL and would not work without SSL.