Changelog

Changed

• Setting: Wrap Tabs. Controls if tabs are wrapped or scrolled (default) when there are more than can be displayed.

Fixed

• Large Schema Performance: Much improved. #425 #378
• Table Editing: Don’t quote the default value. #437

Fixed

• Improved filter icon showing toggled state, and key column data type icons when toggling filter.
• SQL statements not being added to the tabs. #418
• Improved simplified Chinese translation. #427
• Better handling of databases with no access for configured authentication. #421
• Snowflake: Fixed introspection issue. #422

Changed

• Passwords: Expose the config key values as environment variables to the password command. #428

Fixed

• Results: Adding rows would not work with null values. #430

Changed

• SSH Tunnel: Prevent auto close if no active connections.

Fixed

• Results: Allow tabs to wrap. #418
• Results: Reduced size of quick search to allow more tab space, added visual tab separators.
• Quick Open: Remembers last used connection, shows path, shows all items once inside a connection level and user starts typing. #237
• SQL Server: Updated databases to show when the user account does not have access. #421
• Snowflake: Fixed introspection issue. #422

Changed

• Welcome Panel: Re designed.
• Connection: Re designed the add and edit screens.
• Tunnel: Re designed the add and edit screens.

Fixed

• Editor: Looses focus when executing statements. #420

Changed

• Quick Open: Open tables, views, stored procs and other entities that can be clicked on in the explorer via the keyboard shortcut ctrl+windows+o (Mac: cltr+cmd+o). #237
• New Connection: Revised layout, added search feature.
• DB Explorer: Added column names to the index description.
• Results: Esc key will now close relationship sub results in reverse order to how they were opened.

Fixed

• Passwords: When generated by a command, the output is now trimmed to remove whitespace characters. #415
• SQL: Don’t treat numbers with leading 0’s as strings. #409
• Results: Fixed horizontal scrolling with the wheel when not full rows.

Changed

• ClickHouse: Preview support released. #111

Fixed

• Zero Config: Handle drive paths on windows correctly. #408
• SQL Server: Detect unicode characters before N quoting. #409
• DB Explorer: Don’t fetch databases if we already have them on another connection. #405
• Timescale: Filtered out internal timescale schema. #378
• Postgres: Improved types discovered on introspection. #378

Fixed

• Postgres: Inherited tables now show in the table list. #406
• Postgres: Databases sizes are now fetched in the background. #405
• Postgres: Improved introspection speed on foreign keys. #378
• Trae: Fixed loading in TRAE VSCode fork. #404
• Results: Fixed theme color mapping in the inspector. #341
• Notebooks: Failed to save outputs when results still executing. #381

Changed

• Results: Added an Inspector to the right hand tools. #341
• Results: Removed Filters from the right hand tools.
• Results: Filter or exclude selected values via context menu. #401
• Setting: Result Location. Control where results are shown (panel, beside editor, below). #77

Fixed

• Azure: Insufficient permissions to system views/columns. #361

Changed

• Notebook: Cells can be now be locked to specific connections, different to the other cells in the noteboook. #308
• DB Picker: Added path details, back button, made sticky while loading.

Fixed

• Notebook: Failed to render in some cases.

Fixed

• Relationships: Browsing across relationships now work correctly with binary foreign key fields.
• SQL: Added more keywords to the escape list for identifiers. #385
• Results: Insert file on binary field only shows when editing the cell.
• Postgres: Performance regression with large number of schemas. #378

Fixed

• Reduced bundle size, increased loading performance slightly.
• Postgres: Regression on data type handling. #396 #397
• package.json: Updated configuration schema. #395

Changed

• Greenplum: Added support for Greenplum. #392
• Postgres: Moved to new introspection model, improves performance, added support for table partitions and row level security. #278 #165 #378
• Postgres: Support versions 9.2 and above.

Fixed

• Inline completion: Fixed cross database not suggesting columns in select again. #157
• MongoDB: Was not working with the advanced filter.
• MongoDB: Fixed mixed datatype. #393

Changed

• Added toolbar icon to open current SQL in the editor (including applied filters/sorting).
• Added separators to the toolbar for better visual separation.

Fixed

• Advanced Filter: Use equals and not equals symbols, rather than words.
• Editor: Insert statement parameters are now highlighted if the cursor is in a value. #352
• Autocomplete: Was not working with escaped identifiers in dot notation. #391
• .vscode folder: Wont be created unless connections are stored in the workspace. #391

Changed

• Advanced Filter: Tables now have an advanced filter icon in the toolbar, which exposes a SQL “like” interface for filtering.
• Column Filters: now support multiple conditions.
• Column Filters: now supports is blank/null. #388
• Column Filters: now has specific apply/reset buttons.

Fixed

• SQL: Escape all SQL identifiers to cover any keywords, rather than just non alpha strings. #385
• Azure: Store the last successful tenant ID with the connection. #327
• Azure: Fixed token expiry issues. #324
• Supabase: Fixed cloud provider to use session pooler rather than direct connection. #386