Changelog

Changed

• Added a go to definition link on tables, views and materialized Views (ctrl/cmd + click or f12 when hovering a table, view or materialized view in a query). #333
• Connections: Added common default socket paths, and changed it to a text input since VS Code prevents selecting locked files.

Fixed

• Editing a value to the default did not correctly save the change. #331 #299
• Postgres: Adding vector datatype. #330
• Chart: Tooltips were not showing on the chart, right clicking caused the chart to disappear. #30

Changed

• Entity Relationship Diagrams will now only show the filtered tables if a filter is applied in the explorer. #322

Fixed

• SQL Server: Fix introspection issue on servers with case sensitive collation. #318
• Export: SQL Insert statements now include the schema if applicable. #321
• MySQL/MariaDB: Fixed issue with editing triggers.
• MySQL/MariaDB: Fixed issue with socket connections.
• Postgres: Fixed issue with current_schema returning a schema that does not exist.

Fixed

• Icon added for Notebooks.
• SQLite/libSQL now shows row counts for tables in the explorer.

Changed

• Redis: Preview support for Redis, browsing works, not much else at the moment. #39
• Added item to the header context menu of results to clear one or all column filters. #315

Fixed

• UUID icon rendering issue when it was a primary key in the ERD.
• A single column will start no wider than 1/3 rendering space for the results. #314
• Disconnecting a connection was not correctly showing it disconnected in the explorer. #222

Changed

• @dbcode has been added as a chat participant if you have the Github Copilot extension installed.
• You can right-click on a supported database file (.db) and choose to open it in DBCode.
• Autocomplete now works in notebook cells.

Fixed

• The data grid now uses the editor font for cell values.
• Data grid column widths are now limited to prevent excessive length when the table has many columns.
• Data grid charts now correctly display numeric values for series data.

Changed

• Notebooks: Saved output can now be restored. #44

Fixed

• Notebooks: Background color was not being applied. #260
• Cassandra: Was forcing a username. #261

Changed

• Notebooks: Tabs have been removed from output. #247
• Notebooks: The option to save output in a notebook has been added (under active development). #44

Fixed

• Range highlighting better handling new lines after semicolons
• MySQL/MariaDB: Fixed issue with unicode enum values.
• CockroachDB: Fixed issues with default database and introspection differences with Postgres. #258
• Tunnels: Fixed issue with private keys without passwords prompting for passwords. #257

Changed

• DB Explorer context menu now has filtering for any set of items (tables, views, etc). This replaces the previous filtering of databases and schemas configured per connection. #115

Fixed

• Exports no longer includes the row number column.
• CockroachDB: Fixed error when trying to connect to local instance, and a typo. #253

Changed

• If a table has more rows than rowsToLoad setting (default 100) filtering, paging and scrolling will fetch rows from the database as needed. #170
• Added warning if refreshing results with unsaved changes.
• Setting: Removed maxRowsToFetch
• Setting: Added rowsToLoad (default 100). Controls number of initial rows loaded when opening a table or view. #170

Fixed

• Exporting insert statements will use the tables name (if present). #250

Changed

• When results are returned that hit the max row limit, sorting will now re request the data from the server. #170
• SQLite: Added support for loading extensions, currently only sqlite-vec. #249
• Notebooks: Changed file format to YAML for better Git readability.

Fixed

• SQLite: Added real mapping (changed float to be the alias). #246
• Result column filters were not working for date columns correctly.

Changed

• Moved to perpetual license model.
• Setting: Order By Primary Key: Will order by the primary key if present when opening a table. #220
• Notebook: The connection is now persisted in the notebook file, and the notebook will show an error if the connection cannot be found on re opening the file. #44

Changed

• SQL files now show the statement boundaries in the editor. By default the execute icon/keybinding will execute the statement in the boundary. #143

Fixed

• DBCode panel now aware of changes to pagination setting.

Changed

• Settings: Added a setting to enable pagination in the results, along with icon to turn it on per result set (bottom right of the result table).
• BigQuery: Metadata from the executions (Cache hit, bytes processed) are now shown in the status bar. #159
• Removed Apply Changes button from the status bar, save icon is still in the toolbar, keyboard shortcut was added.
• Fixed result editing of boolean fields to use the checkbox, and handle null values for boolean fields correctly.
• Added cmd/ctrl+n to add a new row in the results. #228
• Added cmd+delete ctrl+backspace to delete rows in the results. #228
• Added cmd/ctrl+d to duplicate rows in the results. #228
• Added a filter option to tables, preview of the functionality to replace schema/database filter. #115

Fixed

• Applying a value to a selection of cells was not appling to all the cells in the selection.

Changed

• Added support for removing a group of connections from the explorer, as well as removing a single connection from a group in the explorer.
• Switched to a universal build. Binary packages will be downloaded as needed instead of being included in the extension.
• Added cloud providers to the connection picker.

Fixed

• Postgres databases in some cases were not displaying results.

Changed

• Added support for materialized views (Postgres and BigQuery). #214
• Added cmd/ctrl+r to refresh the results (if enabled). #250
• BigQuery: Added support for editing functions, ADC authentication. #159

Fixed

• Fixed a bug when the file system could not be read. #218
• Show correct icons when opening views and materialized views.