Changelog

Track our development progress with detailed updates, improvements, and bug fixes.

  • v1.6.14

    Changed

    • Improved refresh feature and tab naming for SQL statements, including better handling of multiple result sets. #197
    • Notebooks: Query parameters values are now shared across cells, and persisted on save. #262
    • DuckDB: File search path set to the folder of the database file, to enable relative paths in load commands.
    • DuckDB: Changed to new DuckDB supported driver, upgraded to new introspection model.

    Fixed

    • Cassandra: Added support for multiple statements in a single string.
    • MongoDB: Don’t require a port when connecting via mongodb+srv:// #276
    • MongoDB: A new script file will contain example commands and link to the quick reference. #276
    • Notebooks: Scrolling is now captured when scrolling the results grid, within in a scrollable notebook.
  • v1.6.13

    Changed

    • Setting: Notebook max tabs now controls the number of tabs per output cell in a notebook. #270
    • Changing the max tabs setting to 0 will remove the output tabs from the ui. #270
    • Tabs now shrink properly when there are more than can be displayed on the tab bar. #270
    • Tab icon changes to pin on hover indicating tabs can be pinned. #270

    Fixed

    • Postgres: Fixed issue with query parameters picking up Postgres replacement values. #262
  • v1.6.12

    Changed

    • Added support for executing a command to get the password for a connection. #269

    Fixed

    • MySQL/MariaDB: Changed introspection to not use information_schema for procs. #273 #265
    • Added more checks for connections with configuration issues (invalid drivers). #231
    • Added a configuration option to debug tunnels. #257
    • Notebooks: Fixed a bug with saving outputs when output id’s started with a number. #272
  • v1.6.11

    Changed

    • Notebook tabs have been restored. #270
    • File based drivers (SQLite, DuckDB, etc) now store the path as a relative path when the config is saved in a work space. #268
    • File based drivers (SQLite, DuckDB, etc) can use ${workspaceFolder} in the path. #268
  • v1.6.10

    Changed

    • Query Parameters are now supported. #262
    • Keybinding on Mac for executing a statement has been changed to ctrl+enter (was cmd+enter), consistent in both notebooks and editor now.

    Fixed

    • Error highlighting was not working with the active range.
    • Tables starting with an underscore where not editable when opened.
    • Cassandra tables would not load as it did not support Order By or Offset.
    • When using a row limited table, could not remove a second column filter.
    • When adding a row to a row limited table, you could not scroll/page to get more records without saving the pending row change.
  • v1.6.9

    Changed

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

    Fixed

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

    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
  • v1.6.7

    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
  • v1.6.6

    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
  • v1.6.5

    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.
  • v1.6.4

    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
  • v1.6.3

    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.
  • v1.6.2

    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.
  • v1.6.1

    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.
  • v1.6.0

    Changed

    • Added BigQuery support (in Beta). #159
    • Added cmd/ctrl+s to save all changes in the grid. #215
    • Added the connection color to tab icons where applicable. #72

    Fixed

    • Result saving was being incorrectly enabled if a single change was made, and then another change made which resulted in the original value. #210
    • Undo/Redo keyboard shortcuts when multiple result tabs were visible in the DBCode panel where applying to all result tabs.

Ready to try DBCode?

Install DBCode today and transform your database workflow in Visual Studio Code.