• SQL Editor:
  • Added ability to disconnect from the datasourse when all associated editors were closed (configurable)
  • New autocompletion engine was significantly enhanced
  • Autocompletion for derived columns in sub-queries was improved
  • Autocomplete suggestions inside literals in INSERT INTO were disabled
  • Execution of the corrected SQL script was fixed
  • ‘Recent SQL script’ was renamed to the ‘Last edited SQL script’
  • Short/long object names completion configuration was redesigned
• Metadata editor: Composite data types presentation was added for table columns
• Data editor: JSON and XML panels performance was enhanced
• Data transfer:
  • Compress option behavior was fixed
  • Wizard window auto-size was fixed
• Task management: Broken exported file extension after the task editing was fixed
• Dashboards: Project dashboard UX was improved
• Connectivity:
  • Connections invalidation after sleep mode was added
  • Idle connections timeout was fixed
• General:
  • Establishing connection visualization was added to Database Navigator and Projects
  • Tooltip delay on macOS was reduced and became configurable
  • Saving script outside the Script folder was fixed
  • SVG extension was moved to the PRO version
  • Authentication in embedded browser was temporarily disabled on Linux
• Databases:
  • Altibase:
    • Added the ability to compile procedure, function, or package from the UI as well as truncate table and refresh materialized view (thanks to @zennken)
    • Added status of the view, materialized view, procedure, function, or package (thanks to @zennken)
    • Execution plan parsing error was fixed (thanks to @zennken)
  • Clickhouse:
    • DateTime32 formatting was fixed
    • IPV6 data presentation was added (thanks to @asifjoardar)
    • Complex structure display in the Data grid was fixed
  • CUBRID:
    • View creation was added to the UI (thanks to @longhaseng52)
    • Supported keywords for SQL Editor were reviewed and updated (thanks to @rathana-pvs)
    • Ability to edit Serial using UI was added (thanks to @longhaseng52)
  • DuckDB: Data edit was fixed
  • Microsoft Azure driver was updated to version 12.7.0
  • Oracle: DDL generation for Oracle Tablespaces was added (thanks to @pandya09)
  • PostgreSQL:
    • Specific functions were supported in the SQL Editor (thanks to @EastLord)
    • Metadata read was fixed
  • Redshift:
    • Metadata reading for indexes was disabled
    • Problems with broken connection were resolved
  • SAP IQ: Duplicated output messages were fixed
  • Teradata: Database name became optional for connection
  • Vertica: Incorrect query execution with the cursor at the end was fixed
• Localization: Italian localization was updated (thanks to @Gnafu)

• SQL Editor:
  • Performance in Smart mode of Blank line as a statement delimiter was enhanced
  • Ability to show all SQL scripts from the main toolbar was added
  • Syntax highlighting for functions with multiple arguments was fixed
  • SQL datatype color use was corrected
  • DROP statement support was added to Outline
• Metadata Editor: Foreign Key creation dialog UIX was improved
• Data Editor:
  • Indication of the table read-only/editable mode was added
  • Information about active unique key used for data edit was added
  • Customise and Save filter buttons were moved to the dropdown
  • Issue with too small Result Set Order/Filter Settings window was resolved
  • Rollback timer flickering was fixed
• Query Manager: information about database schema and catalog was added to the detailed record view
• Simple Structure Compare: issue with long file names was resolved
• Connectivity:
  • Issue with default SSH connection timeout was resolved
  • Driver downloading problem reporting was fixed
• General:
  • Incorrect button behavior in the confirmation dialog was fixed
  • Security credential encryption was enhanced (thanks to @longhaseng52)
  • Toolbar and Data Editor background on the Dark theme was improved
  • Smart commit mode indication was fixed
  • Issue with metadata cache reading was resolved
  • Automatic resize of connection dialog and tasks dialogs was fixed
  • Databases:
    • Clickhouse:
      • Complex structures handling was fixed
      • Clickhouse driver was updated to version 0.6.1
    • CUBRID: ‘db_server’ information was added to the Database Navigator
    • Oracle: Connection error in the application downloaded from the Microsoft Store was fixed
    • PostgreSQL: Dollar-quoted string parsing was fixed
    • SQL Server:
      • Issue with resultset primary key detection was resolved
      • Duplicated output when running stored procedures was fixed
      • NTLM Authentication was fixed
      • Datetime datatype representation was fixed
  Tweet

• AI: GPT-4o model was supported
• SQL Editor:
  • Auto-save editor setting was enabled by default
  • ILIKE keyword was supported
  • Support for unsigned numbers in GROUP BY clause was added
  • Syntax highlighting and outline viewer support parameter changes in SQL Processing settings
  • Links to the SQL Editor and Visual Query Builder were added to the Context menu
  • Buttons in the right toolbar were renamed
  • Print mode in ER Diagrams and Execution plan was fixed
  • Saving Diagram outside the workspace was fixed
• Data Editor:
  • Information about table unique key is displayed in the grid
  • BETWEEN and LIKE keywords were added to filetr autocomplection
• Data transfer:
  • Export of data with backticks was fixed (thanks to @diashalabi)
  • Export of binary columns in JSON format was fixed
• General:
  • Ability to restore default settings was fixed in SQL Editor Formatting settings, SQL Editor settings, SQL Editor Commit type, Error handling settings, and Hex Editor default width
  • Creating a view from the UI was fixed
  • Buttons display when creating new dashboard was fixed
  • New table creation was fixed
• The following drivers were updated:
  • Firebird to version 5.0.4
  • Redshift to 2.1.0.29
  • Informix to 4.50.JC10W1
• Databases:
  • Altibase: Search for server properties was added (thanks to @zennken)
  • BigQuery: Ability to see bytes billed in Statistics panel in the Data Editor was added
  • Cubrid:
    • Execution plan coloring was enhanced (thanks to @hwany7seo)
    • Ability to create a table via UI was added (thanks to @longhaseng52)
    • DDL display for a view was added together with the ability to display the list of indexes, synonyms, serials, triggers, and procedures (thanks to @longhaseng52)
    • Ping query for keep connection alive was added (thanks to @rathana-pvs)
    • Partition display was added (thanks to @rathana-pvs)
  • PostgreSQL:
    • If database field in connection settings is empty, user name is used as a database name
    • Work of ‘Use fully qualified names’ setting was fixed for views
  • Redis: Key settings were fixed
  • Redshift: Constraint creation was fixed
  • Vertica: Stored procedures handling in SQL Editor was fixed

Changes since 24.0.5:

• SQL Editor: issue with extra linefeed during autocompletion was fixed
• Data Editor: loading data when fast scrolling using the keyboard was fixed
• Database tasks:
  • Maximum execution time option was added
  • Tasks running from non-default workspace was fixed
• Connectivity:
  • ‘Azure AD’ was renamed to ‘Microsoft Entra ID’
  • Links to database support documentation were added for many databases
  • Automatical termination of the shell command script ‘Before connect’ was fixed
• General:
  • Crash when closing detached editor tab in another window was fixed
  • ‘Restore default’ for Metadata read, Client identification settings was fixed
  • .projects and .settings folders became findable in Projects when the application is used as an Eclipse plugin
  • Truncated notifications were fixed
• Projects:
  • Disconnecting a database from the Project view was fixed
  • Opening a bookmark after changing the application language was fixed (thanks to @SASUKE38)
• ERD: loading diagrams for drivers with broken foreign keys support was fixed
• Database Navigator:
  • Color of the table statistics was changed to visible in the dark theme and became configurable
  • Deleting connection option in the context menu was renamed to ‘Delete connection’
• Databases:
  • CrateDB: table DDL was fixed
  • Databricks: authentication with personal access token was added
  • DB2i: procedure creation was fixed
  • DuckDB: aliases autocompletion was fixed
  • H2: foreign keys presentation was fixed
  • Oracle: JSON data type support was improved
  • PostgreSQL: support of fully qualified names in DDL was fixed
• Localization:
  • German localization was updated (thanks to @maxbobse)

• SQL Editor:
  • Smart mode for statement delimiter was improved
  • Default option for the setting ‘Blank line is statement delimiter’ was changed to ‘Always’
  • Cursor behavior during autocompletion was improved
  • Code highlighting issue with a quoted identifier in case of no connection was fixed
  • High CPU usage for large script was fixed
• Metadata Editor:
  • Highlighting for created entities was changed to green
  • Virtual foreign keys: reference table container selector was fixed
• Database Navigator: CTRL+C and other shortcuts behavior after the application startup were fixed
• AI (extension): custom scope performance was improved
• General:
  • Opening editors for files with special symbols in names was fixed
  • Portable distribution of the application was fixed (config files location)
  • Licensing for some source files was fixed
• Eclipse plugin: new database objects create was fix
• Databases
  • DuckDB: Spatial data visualization support was added
  • Oracle:
    • Partition type display was added
    • Materialized view refresh was fixed
  • SQL Server: Default IDENTITY was changed to (1,1) (thanks to @Sgierek106)
  • Vertica: LOOP/END LOOP as a block and DECLARE were added to the syntax analyzer

• SQL Editor:
  • Smart mode for Blank line is statement delimiter setting was fixed
  • Vertical button alignment was fixed
• ER Diagrams: Keep layout selection was fixed
• Data transfer:
  • Import from CSV with duplicated columns names was fixed
  • Parallel data transfer monitoring/cancellation were fixed
• Dashboards:
  • Ability to drag and drop charts to another dashboard was added
  • Number of minor UI improvements were added
• Connectivity:
  • SSH parameters validation on the Connection page was added
  • Editing of ‘Local host’ and ‘Remote host’ fields in the Port Forwarding section was fixed
  • Database connection timeout notification was fixed
• Development: Redundant tests were disabled
• Databases:
  • MariaDB:
    • GRANT OPTION privilege persistence was fixed
    • Schema privileges representation was fixed
  • SQL Server: trigger deletion was fixed
  • Teradata: link to the referenced table in the Metadata editor was added
• Localization: French translation was updated (thanks to @Jean-BaptisteC)
• General:
  • Language configuration in Windows installer was fixed
  • We have migrated to Eclipse 2024/06

• General:
  • Migration from Toad for Oracle was supported
  • Sensitive information in the log files is now masked
• SQL Editor:
  • Smart mode for ‘Blank line as statement delimiter’ option was added (enabled by default)
  • Sub-select autocompletion was added
  • Highlighting of column references in INSERT queries was fixed
  • Outline viewer opening was fixed
  • Issue with hidden text on macOS was fixed
• Connectivity:
  • Space trimming when saving user credentials was added
  • Saving SSH configuration with missing AWS private key was fixed
  • Reconnecting via SSH tunnel was fixed
• ER Diagrams: foreign keys presentation was fixed
• AI:
  • AI assistant is enabled by default
  • Database metadata collection was fixed
• Dashboards: disappearance of custom dashboards after version update was fixed
• Connectivity:
  • Space trimming when saving user credentials was added
  • Saving SSH configuration with missing AWS private key was fixed
  • Reconnecting via SSH tunnel was fixed

• Connectivity:
  • Using multiple jumps tunnels when connecting via SSH was supported
  • Enable tunnel sharing option was added
  • Test connection was fixed
• SQL Editor:
  • WHERE TRUE and SELECT UNIQUE support was added
  • Error with single quoted string was fixed
  • Syntax highlighting after active schema change was fixed
• Data Editor:
  • Automatic row count option was added (thanks to @utsav1704)
• Metadata editor:
  • Deleting table comments was fixed
  • Linking with the editor was fixed
• General:
  • Ability to collect log files from the interface was added
  • Transaction rollback behavior was fixed
  • Metadata changes were removed from the commit counter
  • Autocommit in production databases was fixed
• Data transfer:
  • Ability to specify header case in the target file was added
  • Typo in the confirmation dialog was fixed
• Databases:
  • Cubrid: Query plan feature was added (thanks to @rathana-pvs)
  • Old MySQL drivers were repacked
  • PostgreSQL: Jobs, roles, and system information were hidden in the Hide Folders mode
  • SQLite: Deleting columns was fixed

• Connectivity:
  • Shared SSH sessions support was added
  • Connection via native proxy was fixed
  • Dark theme support on the Connection page was improved
• SQL Editor:
  • Highlighting, validation, and outline for INSERT, UPDATE, and DELETE were supported
  • Incorrect cursor position during autocomplete was fixed
  • QUALIFY keyword was supported (thanks to @ashu7896)
• Metadata editor: automatic reference column creation for a new foreign key was implemented
• Data Editor:
  • Opening of a table with empty data was fixed
  • SRID editing was fixed
• General:
  • SVG icons support was added
  • Error when checking checkboxes in the Formatting page in Preferences was fixed
  • Disappearance of renamed project was fixed (thanks to @saikotek)
• Databases
  • Dameng: Sequence creation was fixed
  • DuckDB:
    • Sequences, views, and table definitions were supported
    • Ability to add comments via UI was added
  • MySQL: link to the driver documentation was fixed
  • RisingWave: non-working functions and folders were removed
  • PostgreSQL: issues with scheduled jobs was resolved
  • SQLite: errors when creating table was fixed
  • SQL Server: redundant authentication types were hidden
  • Sybase: stored procedures support was improved
  • Teradata: procedures and functions DDLs reading was enhanced
• Localization:
  • Romanian language support was added (thanks to @v613)
  • French translation was updated (thanks to @Jean-BaptisteC)

Changes since 23.3.5: