Changes to an open connection that affect the connection (e.g., host, port, username, etc) will now prompt you to close and reopen the connection.
Color changes will be removed when the window loses focus and reapplied when the window regains focus to prevent them from appearing in other VS Code windows.
0.12.6
Changed
Assign a color to a connection and specify which sections: the editor tab, status bar, and command center should display that color when active.
Fixed
Codelens does not get hidden above the visible area.
A race condition restoring previously open connections caused multiple connections to the same database to open.
0.12.5
Changed
Open a table cells content in the VS Code editor.
Connection tree view items are now cached for faster initial loading and refreshed in the background.
The connection tree view will reopen previously expanded items on VS Code restart.
Files assigned to a connection are now restored to that connection upon reopening VS Code.
Fixed
Consistency with delete confirmations between connections, tunnels, history.
0.12.4
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.
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.