Changelog

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

  • v1.6.15

    Fixed

    • MSSQL: Fixed issue with introspection when user only had read only access. #280
    • DuckDB: Added support for enums.
    • Notebook: Prevent keyboard events from propagating to the notebook. #281
  • 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.

Ready to try DBCode?

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