Changelog

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

• Added a new command to the database context menu to execute SQL files on a database. #162
• Reduced logo size in activity bar.

Fixed

• Fixed error with hovering a procedure name in the editor that does not have parameters. #184
• Postgres: Added the pseudo types to introspection. #163
• Postgres: Added support for composite types. #164

Changed

• Added Entity Relationship Diagram option to the context menu of individual tables, filters the initial display to that table and it’s related tables. #134

Fixed

• Revised URL handling for file paths on auto discovery. #152 #156
• ERD was not loading when a column type was not matched to a type from the schema. #153

Fixed

• Snowflake now supports Key Pair Auth #113
• CoPilot will now quote identifiers in case sensitive dialects #154

Changed

• Snowflake supports full introspection, and procedures are now supported.

Fixed

• Handle urls that cannot be parsed in autodisovery and manual discovery. #152

Changed

• Updated Snowflake connections to support SSO, Warehouse, and Secondary Roles. #113
• Updated Redshift to the new introspection model. #146

Changed

• Updated MySQL/MariaDB to new introspection model. #145 #132 #122

Fixed

• MySQL/Maria null dates (0000-00-00) were causing a results not to render. #137
• Notebook results windows were incorrectly sized. #144

• Added preview support for IBM DB2
• Added a completion item to include all fields in a table when typing table.*

Fixed

• Result columns are now resized sooner to avoid the flash of resizing on initial loading.
• Result columns can now be dragged as wide as needed.

Changed

• Added support for MotherDuck. #136

Fixed

• Fixed Snowflake schema to default to public.

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.