Changelog

Changed

• Results: VSCode editor now used in JSON/XML datatypes, and can be opened on any field using the open in editor icon (replaces old open in editor). #107
• Connection Pinning: Will now destroy a connection if keep alive statement fails. #578 #648

Fixed

• Trino: Uses line numbers in errors to reduce highlighting when present.
• Export: Fixed issue with SQL Insert statement export. #655
• Inspector: Show correct data types in the JSON view.
• Inspector: Added proper editor to JSON and XML data types. #107

Changed

• Results: Support for data formatting completed.
• Inspector: Updated to use VSCode editor.

Fixed

• DB2: Fixed issue with SSL connections. #652

Changed

• Results: Added support for data formatting (work in progress).
• Results: Selecting a full row and pressing delete/backspace will now delete the row, rather than clear the contents (cmd/ctrl+delete/backspace will delete partially selected row).

Fixed

• Dragging a table to a new window did not load the data.
• Greenplum: Fixed introspection issue. #651
• Doris: Fixed introspection issue. #645
• Results: Fixed issue with sorting other columns, when primary key sorting setting was enabled.

Fixed

• Autocomplete: Fixed issue where it was not working for some databases. #643
• Redshift: Removed JSON method from introspection. #644

Changed

• Connection Pinning: Added support in notebooks, and for Postgres. #578
• Redshift: Added support for external tables (Spectrum). #613

Fixed

• Postgres: Introspection does not get columns for partitioned tables (redundant).
• Postgres: Don’t change schemas for non user based SQL execution. #507
• Oracle: Fixed syntax error being displayed rather than driver error in certain cases.

Changed

• Export/Share: Added support for tab delimiters in CSV export.

Fixed

• Improved introspection performance for large schemas (1000+ schemas)

Fixed

• Explorer mapping columns to incorrect tables in some cases. #628
• IBM DB2: Added latest bindings. #636
• MySQL/MariaDB: Filtering for year was using date rather than number. #633
• Postgres: Updated to support AWS Aurora DSQL. #637
• Parameters: The data type dropdown was not always visible.

Changed

• Data: Transpose mode finalized. #554

Fixed

• Oracle: executing of begin.. end; blocks fixed. #619

Fixed

• Notebooks: Restore cell height and chart width saved with output. #623
• SQL Parsing: Better handling of begin.. end; blocks. #619
• Supabase: Fixed issue when projects did not use branches. #624

Changed

• Data: Transpose mode improved, cmd/ctrl+t to toggle transpose mode, undo still needs work when switching modes. #554

Changed

• Data: Transpose mode improved, some issues with switching modes with pending edits still to be resolved. #554
• Inspector: Added form view with editing support, search and copy feature, and support for transposed results.
• Results: Simplified selection UX, allowing for duplicating partial rows.
• SQLite: Added support for an idle timeout. #615

Fixed

• Added index as an escaped identifier. #620
• Results: Reduced row heights when a smaller font size is used.

Changed

• Data: Transpose icon added to allow transposing the data in the results grid (in preview, still working on it). #554
• SQL Server/Azure: System tables are now grouped into their own System Tables section in the explorer if present.

Fixed

• Autocomplete: Aliased tables across databases which did not support schemas were not being handled correctly.
• Connection Pinning: Added keep alive for SQL Server. #611

Changed

• ERD: Now part of the core features.
• Notebook Export: Now part of the core features.
• Export/Share: Last used theme is now remembered.

Fixed

• MCP: Autostart was prompting to sign in/activate, even when already signed in. #610
• Results: Refreshing table data with schema changes was not reflecting updated schema (eg new columns not being shown).
• Notebook Export: Fixed issue with formatting of tables.

Changed

• ERD: Added option to change the connecting line style, and remember the choice.
• API: Updated connections will run change detection and re connect if details like port, password, etc change. #568

Fixed

• Postgres: Fixed issue with introspection not getting default values.
• Postgres: Fixed issue with introspection not getting foreign key columns.
• Yugabyte: Fixed introspection issue. #591
• Editor: Fixed parsing create package statements.

Changed

• Export: Remember CSV settings for the next export. #599
• ERD: Will remember the position of tables if they are re arranged.

Fixed

• MCP: Autostart was not always working.
• ERD: Improved cardinality display.