Changelog

Fixed

• Fixed domain authentication bug in SQL Server, new option to be specific about authentication type added to connection.
• Fixed PostgreSQL not using right port when first adding a connection.

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.

Fixed

• Updated Microsoft Authentication to use common tenant.

Changed

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

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.

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.

Fixed

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

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.

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.

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.

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.

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.

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.

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.

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.