Changelog

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

• Added support for storing connections in the workspace. #200
• Added right click context menu to folders to recursively discover connections.

Fixed

• Postgres: Version detection has been improved to handle cases like 12.6dbup. #201

Changed

• Added a row number column to the results, which also now provides row selection interface like a spreadsheet (ctrl/cmd and shift support for ranges). #138

Fixed

• Context menu on editable results was missing add and duplicate row option.

Changed

• Added right click open in DBCode option for .sqlite and .sqlite3 files. #171
• Added ability to resize the grid in the notebook. #191

Fixed

• Changed Chinese translation for Save. #192
• Fixed connection form elements from not showing their translations. #192
• Postgres: Fixed array data types. #167

Changed

• Preview of Snowflake support. #113

Changed

• Added a setting to control the date/time format. #85
• Added a setting to control if dates should be shown in your computers local time, or UTC when timezone information is present. #85
• Changed Postgres supported version to 9.5 or higher. #129

Fixed

• Maria text fields were showing as binary.
• Postgres introspection error on version 9.5 through 10. #129

Changed

• Datetime columns with timezone information now show in the local time. #85
• Datetime columns now display in the locale/region format of the computer. #85
• Editing a datetime column will highlight the cell in red if the value does not parse.
• Datetime columns that are edited are converted to ISO format when sent to the database.

Fixed

• Tab did not set the cell value when editing data and the cell contained a drop down.

• Keybinding to show DB Explorer does not break find next (cmd/ctrl+d). #121
• Executing tabs can be closed, will prompt to cancel execution. #125
• Potential fix for Postgres queries not returning. #125
• Bit fields handled correctly in the data editor.

Fixed

• SQL Server was not handling UTF strings correctly in data changes.
• Checkbox removed from the table editor.