Changelog

Fixed

• Cassandra: Added tunnel option to the config.
• Changed to a filestore for introspection cache, and mapped formats to a version. #291
• SQL Server: Show if a database is offline. #296

Fixed

• DuckDB: Date filters in results not working correctly. #290
• Notebooks: Copied cells broke the notebook render. #293

Changed

• Added auto refresh option to results.
• Added option to script data changes, rather than applying them.

Fixed

• MSSQL: Fixed issue with introspection when user only had read only access. #280
• Notebook: Prevent keyboard events from propagating to the notebook. #281

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

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.

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

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

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

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.

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