• New drivers: New LibSQL/Turso driver was added
• SQL Editor:
  • Fixed script execution on disconnected state
  • New autocompletion behavior was enhanced
  • Added execution time in statistics result (thanks to @tlm365)
• Query manager: Time column now orders chronologically
• Metadata: Indexes have been returned to the unique constraint list, and the proper data type is now set when creating a new column for a new foreign key
• Data Editor:
  • Fixed an issue with crash caused by too long tooltips
  • Row coloring mapping was fixed
• Data Transfer: “Minimum column length” was renamed to “Default column length”
• Connectivity: “Driver properties” tab in the driver editing dialog was renamed to “Default properties”
• Charts and Dashboards: Fixed charts COUNT for single value
• Miscellaneous:
  • Windows Server 2016, Windows Server 2012, and Windows 8.1 are supported again
  • Snap build was fixed
  • Eclipse extension installation was fixed
  • Query execution canceling was redesigned
  • Issues with unexpectedly closing connections were resolved
  • Added references to the actual boolean editor in Preferences
• Databases:
  • Added support for Hive 4
  • Altibase: Lock manager has been added (thanks to @zennken)
  • CUBRID:
    • Added the ability to create and edit triggers (thanks to @longhaseng52)
    • Added sargs, edge and Query parameters to the Execution plan (thanks to @rathana-pvs)
  • Oracle: Fixed highlighting for public schemas
  • PostgreSQL:
    • Added date picker and fixed data saving in the Role editor
    • Fixed highlighting for public schemas
    • Connection to custom schemas was fixed
    • Fixed data change saving in Value Panel
  • Teradata:
    • Multi-row insert was fixed in data import
    • Fixed incorrect display of PERIOD data type
    • Max rows handling was improved

• SQL Editor:
  • A warning is now shown instead of an error when a DROP TABLE statement contains IF EXISTS and the table does not exist
  • Fixed script execution on disconnected state
  • New autocomplete engine now expands the * symbol in SELECT statements when using “Ctrl + Space”
  • New autocomplete no longer suggests query-start keywords in the middle of queries
  • Metadata requests are no longer sent while typing a query when “Auto-activate on typing” is enabled
• Data Editor: exception on disconnection was fixed
• Navigator:
  • Added the ability to refresh the database connection
  • Filters were fixed
• Data Transfer: Added the ability to export JSON values as embedded JSON
• Connectivity:
  • Presentation of driver download errors has been improved for better clarity and user experience
  • Finding class in the Driver manager was fixed
• Miscellaneous: the Export Window now advances properly when pressing the Enter key
• Databases:
  • Altibase: Module Memory Usage was added to the system information folder in the navigator tree (thanks to @zennken)
  • ClickHouse: Array syntax highlighting has been improved
  • CUBRID: “Use SQL to limit fetch size” was set to true (thanks to @hwany7seo)
  • Fixed an exception that occurred when creating a column without specifying a data type
  • Ingres: driver download was fixed
  • Redshift: access to external databases was fixed
• Localization: Brazilian Portuguese localization was enhanced (thanks to @brlarini)

• SQL Editor:
  • “Show values setting” in the autocompletion section is disabled by default due to performance issues
  • Added highlighting and validation of synonyms
  • Semantic error style was changed
  • Fixed issues with highlighting that occurred when saving the script
• Metadata: Fixed and exception that appeared on right click on table properties
• Connectivity:
  • Fixed an issue where script execution would not stop when disconnected
  • Added an ability to export driver files from the “Edit driver” dialog
  • Fixed user name display in SSH profile
• Miscellaneous:
  • Added additional Java configuration file independent of the product version update
  • Added the ability to disable Windows Defender at startup, which speeds up application loading
  • Some SWT errors were fixed
  • Darkest Dark theme installation was fixed
  • Added the ability to work with OS usernames containing special characters
  • Git extension installation was fixed
  • Eclipse license text was updated
  • Fixed exception that appeared when loading procedure
• Databases:
  • BigQuery: Array and JSON display was improved
  • Db2 z/OS: Fixed broken configuration for generic drivers
  • DuckDB: BLOB display was fixed
  • MySQL: Added support for table name in backticks for SQL Editor
  • PostgreSQL: Permission editor was fixed

• SQL Editor:
  • ‘Cmd+Enter’ shortcut was added in addition to ‘Ctrl+Enter’ on macOS due to the conflict with new system hot keys in Sequoia
  • Fixed an error in multiple tab mode execution when the new execution results replaced old ones
  • The amount of problems being displayed per script query was limited
  • Complicated table qualifiers (database.catalog.schema.user) are now supported
  • Fixed incorrect highlighting after the database disconnect
  • Query execution time is now displayed in seconds/minutes
  • Added an ability to select the text between brackets using ‘Ctrl+Shift+]’ hot key
  • Background Tasks view now shows progress of autocompletion engine
• Data Editor:
  • Presentation and editing of struct and array data types was significantly improved
  • DBeaver can now correctly display negative dates in MySQL databases
• Data Transfer: changed icons for collapsed sections to improve the interface readability
• Connectivity: fixed error handling when a user loads a driver and has an error with certificates
• Navigator:
  • Table filters in Simple view were fixed
  • Disabled the ability to delete the currently active project
• Miscellaneous:
  • Incorrect sorting in Execution log was fixed
  • Issue with not working boolean setting editor was fixed
• Databases:
  • Altibase: added display of the list of tables and indexes within a tablespace (thanks to @zennken)
  • CUBRID:
    • Added the ability to create, edit, and drop Server via UI (thanks to @longhaseng52)
    • Added an ability to create, update, and delete users. (thanks to @rathana-pvs)
  • Oracle:
    • Added highlighting and validation of public synonyms
    • Table autocompletion was fixed
  • Virtuoso: replaced static jar file with Maven artifact

• SQL Editor:
  • Smart syntax highlighting was significantly improved
  • Pseudo columns highlighting was improved
  • Table aliases were fixed in smart completion
  • Issue with pinned tabs was resolved
  • Syntax highlighting fixed for single quoted strings (thanks to @tlm365)
  • SQL console save was redesigned (it now asks for confirmation)
• Data editor:
  • Commit/rollback buttons now enabled only when transactions are applicable
  • Column description rendering was improved for dark theme
• Database navigator: horizontal scrolling was fixed, now action icons are always visible
• Object editor: bottom toolbar layout was unified for all tabs
• Data transfer:
  • CSV parameters documentation was added
  • Database backup/restore dialog layout ws fixed
• General:
  • Snapcraft image now includes additional fonts
  • Embedded browser support was added for Linux/GTK
  • App command line parameters logging was was disabled because of security concerns
  • Issue with splash screen and error message overlapping was resolved
  • Resource leak detection logging was added by default
  • We migrated to Eclipse 2024-09 platform
• Databases:
  • Altibase: database replication metadata was supported (thaks to @zennken)
  • Azure SQL: “show all databases” option was removed
  • CUBRID:
    • Index drop command generation wad fixed (thanks to @longhaseng52)
    • Procedure create dialog was added (thanks to @longhaseng52)
    • List of reserved keywords was updated (thanks to @rathana-pvs)
  • DolphinDB driver was added (thanks to @peeyee)
  • MySQL: NULL geometry values handle was fixed (thanks to @EastLord)
  • Salesforce CDP: connection dialog layout was fixed
  • SAP HANA:
    • Connection dialog was improved for HANA Cloud (thanks to @kai-morich)
    • Expired password change feature was added (thanks to @kai-morich)
  • Trino: issue with long cursor reading was fixed (thanks to @schaffino)
• Localization:
  • Arabic localization was added (thanks to @AliElamir)
  • Brazilian Portuguese localization was updated (thanks to @brlarini)

Changes since 24.1.5:

• SQL Editor:
  • Fixed highlighting of block $$ for functions and procedures when the semantic analysis option is enabled
  • Warning and errors handling and presentation was improved
  • Subquery semantic analysis was enhanced
  • Improved CREATE and DROP queries handling
  • Autocompletion for fully qualified names was fixed
  • Duplication of proposals with new completion engine enabled was fixed
  • Incorrect suggestions with new completion engine enabled were fixed
• AI Assistant:
  • Added new model ‘gpt-4o-mini’
  • Removed deprecated model ‘gpt-3.5-turbo-16K’
  • Fixed query generation when enabled formatting
• Data Editor:
  • Some datatypes icons were changed
  • Fixed filtering on columns with spaces
  • Added an ability to render geometry shapes in their assigned color if a ‘color’ column is present in the result set
  • Improved handling of fully qualified names in Grouping panel according to SQL dialect
  • Local links opening was restricted
• Datatransfer: Data transfer windows width was fixed
• Connectivity: Fixed verification of the 127.0.01 host when connecting via SSH
• General:
  • Fixed flipping splash screen on macOS Sequoia
  • Foreign Data wrappers configurator was fixed
  • ‘Open auth links in embedded browser’ setting was disabled by default
  • Search in Preferences was improved: added keywords for reopen, open, Hippie, autosave, and others
  • Fixed selection of wrong database when changing connection for database with similar names
  • Folder display in Simple view was fixed
  • Numeric (DWORD) type parameters in Windows Registry are now supported
  • ‘Ctrl+Alt+Left / Right’ hotkeys for ‘Previous Edit Location’ and ‘Next Edit Location’ were fixed
• Databases:
  • Clickhouse: Filtering by the Date data type was fixed
  • MySQL: Error/output log dump was fixed
  • PostgreSQL:
    • Ordering by interval datatypes in the Data grid was fixed
    • Added regexp functions support in SQL Editor (thanks to @anton-erofeev)
  • Redshift:
    • Connection stability was significantly improved
    • DDL presentation was fixed
    • Role, User, and Group presentation was fixed
  • SQL Server:
    • SQL Server driver was updated to version 12.8.0
    • Fixed DDL and column display with custom data types
• Localization: French localization was updated (thanks to @KawtharAlakri)

• SQL Editor:
  • Added semantic analysis and Outline viewer support for CREATE and ALTER TABLE queries
  • Added presentation for warnings in semantic analysis results
  • Data type icons were redesigned
  • SQL error presentation was redesigned
  • ‘Execute SQL Script’ option behavior was fixed
  • SQL Output for SQL scripts was fixed
  • Output panel opening was fixed
  • Column aliases can now be copied with Advanced Copy option (thanks to @dstivanov)
  • Column validation for UPDATE SET clause was fixed
  • Issue with invalid table name was fixed
  • If all tabs with query results are pinned, a new tab with a new query result is created
• Data Editor: Paste into the table with no foreign key was fixed
• Database Navigator:
  • Connection visualization was fixed
  • Navigator icons were redesigned
• Connectivity: Connection page for custom drivers with the URL template was fixed
• General:
  • Opening links to local files has been restricted due to a security issue discovered by @LuskaBol
  • Improved error handling when trying to use not allowed characters in project name
• Databases:
  • Altibase: Non-schema objects like Job, Database Link, Directory, and Library are now supported (thanks to @zennken)
  • BigQuery: Database monitoring dashboards were added
  • GaussDB driver was updated to version 4-1.1 (thanks to @GaussDB-Fans)
  • MariaDB: Geometry data type is now supported
  • Ocient: Incorrect DDL generation was fixed (thanks to @mjsterckx)
  • SQLite: Full text search was improved
  • SQL Server: Saving changes in procedures was fixed

• SQL Editor:
  • Problem markers with semantic error descriptions were added. You can click on the problem description in the tooltip to find out what is wrong with the query.
  • INSERT, DELETE, UPDATE, DROP, CREATE, and ALTER statements execution in read-only mode was prohibited
  • Smart mode for Blank line state delimiter was improved
  • Simultaneous query execution was fixed: if a query is already being executed, you can execute another query in a new tab only
  • Composite type field color became visible in the Dark theme
  • Completion analyzer performance was enhanced
• Data Editor:
  • Inline editing of geometry fields was fixed
  • New keyboard shortcut Ctrl+Shift+Alt+C has been added to use the advanced copy option with the latest settings, without opening a popup window
• Metadata Editor: Generate SQL option in the context menu was fixed
• Connectivity: Closing idle connections and default timeout were fixed
• General:
  • Users can import connections from SQL Workbench and DbVizualizer
  • Wayland support on Linux was fixed
  • Several code improvements have been made (thanks to @KonstantinRight)
• Databases:
  • GaussDB driver was added (thanks to @GaussDB-Fans)
  • Couchbase: Legacy Couchbase driver was removed
  • CUBRID:
    • Execution plan was enhanced (thanks to @rathana-pvs)
    • Issue with Null datatype was fixed (thanks to @longhaseng52)
    • Creating partition option was removed (thanks to @longhaseng52)
  • InterSystems IRIS driver was updated to version 2024.1 (thanks to @isc-rsingh)
  • PostgreSQL: If the database name is empty, it will be set to the same as the username
  • SAP Hana: Additional system table prefix was added (thanks to @kai-morich)
  • SQL Server: Ability to upgrade/install the driver was fixed

• 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