1.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.

1.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.

1.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.

1.5.12

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

1.5.11

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.

1.5.10

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

1.5.9

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

1.5.8

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

1.5.7

Fixed

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

1.5.6

Changed

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

Fixed

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

1.5.5

Changed

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

1.5.4

Changed

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

1.5.3

Fixed

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

1.5.2

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

1.5.1

Changed

  • Added support for MotherDuck. #136

Fixed

  • Fixed Snowflake schema to default to public.