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

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

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

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

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

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

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

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