DBeaver Ultimate 24.3

December 9, 2024
Changes since 24.2:
  • SQL Editor:
    • Added an ability to select a part of SQL query between brackets using ‘Ctrl+Shift+]’ hotkey to improve script editing.
    • Highlighting and validation:
      • Highlighting and validation were significantly enhanced, including the following: synonym highlighting and validation have been introduced, and the pseudo-column highlighting has been improved. Additionally, the query validation style was updated, and the number of issues displayed for each script query was reduced to improve the interface readability.
      • When a DROP TABLE statement contains IF EXISTS and the table does not exist, a warning is now shown instead of an error.
      •  Underscore in identifiers are now supported in query validation.
    • Autocompletion:
      • Table aliases were fixed in the smart completion.
      • Complicated table qualifiers (database.catalog.schema.user) are now supported.
      • Added the ability to monitor the progress of the autocompletion engine in the Background Tasks view.
      • “Show values setting” in the autocompletion section is disabled by default due to performance issues.
      • New autocompletion engine now expands  * 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.
    • SQL console save was redesigned: it now asks for confirmation.
    • Tabs:
      • Fixed an error in multiple tab mode execution when the new execution results replaced the old ones.
      • Issue with pinned tabs was resolved.
    • Script execution:
      • ‘Cmd+Enter’ shortcut was added in addition to ‘Ctrl+Enter’ on macOS due to the conflict with new system hotkeys in Sequoia.
      • Query execution time is now displayed in seconds/minutes.
      • Added execution time in statistics result .
  • Query manager: 
    • Added an option to clear the Query Manager history.
    • The time column now orders chronologically.
  • Data Editor:
    • JSON and XML text presentation was redesigned: edit controls were moved to the left, word wrap was added to the editor, and find/replace visualization issues were fixed.
    • Presentation and editing of struct and array data types were significantly improved.
    • Commit/rollback buttons are now enabled only when transactions are applicable.
    • Fixed an issue with an application crash caused by too long tooltips.
    • Row coloring mapping was fixed.
    • Column description rendering was improved for the dark theme.
    • Exception on disconnection was fixed.
    • Row coloring mapping now respects the visual order of columns.
    • Fixed invalid thread access on editing data in multiple results in one tab mode.
    • Boolean icons display was fixed.
    • Ability to detach result tabs is now limited to tabs with data.
  • Visual Query Builder:
    • Only relevant action buttons are enabled when the Visual Query Builder is open.
    • Setting a condition can now be configured without errors.
    • Fixed an issue where join lines would disappear when switching from one join type to another.
  • Data transfer:
    • Export in Parquet format was added.
    • Changed icons for collapsed sections to improve the interface readability.
    • JSON values can now be exported as embedded JSON.
    • Added documentation for CSV parameters.
    • Database backup/restore dialog layout was fixed.
    • “Minimum column length” was renamed to “Default column length”.
    • Added an option “Delete export file if export fails”.
    • Commit/rollback behavior during the data import was improved.
    • It’s now possible to not specify quote and escape characters during the import of CSV files.
    • Data Transfer: XLSX import was fixed. 
  • Data Compare: 
    • Comparison tables with composite keys consisting of two or more columns became available.
    • Script in changes preview is now highlighted according to the SQL dialect of the target table. 
    • Added an option to select the target table for applying changes in a task.
    • Fixed missing key attributes when comparing data in the embedded database.
  • Task Management: 
    • Fixed an issue with task execution from the CLI where extra spaces in variable names caused errors.
    • Fixed an issue where task configurations with empty parameters were not saved correctly.
  • Metadata: 
    • Fixed an exception that appeared on right click on table properties.
  • Navigator:
    • Fixed horizontal scrolling; action icons are now always visible.
    • Fixed an issue with bookmark creation.
    • Fixed table filters in Simple view.
    • Disabled the ability to delete the currently active project.
    • Added an option to refresh the database connection.
    • Fixed issues with filters.
    • Multiline comment display was fixed.
    • Scrolling during drag-n-drop was fixed.
  • Connectivity:
    • Added display of AWS SSO code during authorization.
    • Fixed error handling when a user loads a driver and has an error with certificates.
    • “Driver properties” tab in the driver editing dialog was renamed to “Default properties” to improve interface readability.
    • Fixed an issue when script execution did not stop after disconnection.
    • Added an ability to export driver *.JAR files from the “Edit driver” dialog.
    • Fixed user name display in SSH profile.
    • Presentation of driver download errors has been improved for better clarity and user experience.
    • Finding class in the Driver manager was fixed.
    • Issues with unexpectedly closing connections were resolved.
  • Cloud Explorer: 
    • Added support for different global AWS regions.
    • Fixed an issue when saved credentials were used instead of the currently selected ones.
  • Cloud Storage: Improved handling of AWS S3 regions, including task scheduling and other scenarios. 
  • Charts and Dashboards: Fixed charts COUNT for a single value.
  • Security: 
    • Master password management was redesigned.
    • Security settings saving order was fixed.
    • Added the ability to work with OS usernames containing special characters.
  • Miscellaneous:
    • Windows Server 2016, Windows Server 2012, and Windows 8.1 are supported again.
    • We migrated to Eclipse 2024-09 platform.
    • Bottom toolbar layout in the object editor was unified for all tabs.
    • Snapcraft image now includes additional fonts.
    • Embedded browser support was added for Linux/GTK.
    • Added missing controls to the connection dialog for generic drivers.
    • App command line parameters logging was disabled because of security concerns.
    • Issue with splash screen and error message overlapping was resolved.
    • Resource leak detection logging was added by default.
    • Incorrect sorting in the Execution log was fixed.
    • Issue with not working boolean setting editor was fixed.
    • Some SWT errors were fixed.
    • Darkest Dark theme installation was fixed.
    • Eclipse extension installation was fixed.
    • Eclipse license text was updated.
    • The Export Window now advances properly when pressing the Enter key.
    • Query execution canceling was redesigned.
    • Added references to the actual boolean editor in Preferences.
    • Fixed connection creation from the “File” option in the main menu.
    • Option “Open separate connection setting” on SQL Editor and Metadata pages was disabled for embedded databases.
    • Added a note explaining that SSL certificate verification depends on the driver implementation and cannot be directly handled by the application.
  • New drivers:
    • LibSQL/Turso driver.
    • DolphinDB driver.
    • GBase 8s driver.
    • Added new drivers for working with files as databases – these drivers allow you to open files in the Data Editor, execute complex SQL queries, and work with files in cloud storage (AWS, Google Cloud, Azure). Currently, the drivers operate in read-only mode:
      • CSV Pro driver;
      • XLSX driver;
      • Parquet driver.
  • Driver updates:
    • Apache Drill to version 1.21.2.
    • Apache Hive: added support for Hive 4.
    • CouchDB driver was updated to version 0.2.4.
    • SQL Server driver has been updated to version 12.8.0.
    • DB2i driver has been updated to version 20.0.7.
  • Databases:
    • Altibase: 
      • Database replication metadata was supported.
      • Added display of the list of tables and indexes within a tablespace.
      • Module Memory Usage was added to the system information folder in the navigator tree.
      • Lock manager has been added.
    • Azure SQL Server: added an error message to guide users on creating a new connection to access other visible databases.
    • Apache Hive: added support for Hive 4.
    • ClickHouse: Array syntax highlighting in SQL Editor was improved.
    • CosmosDB: URL template in connection dialog was fixed.
    • CUBRID:
      • Index drop command generation was fixed.
      • Procedure create dialog was added.
      • List of reserved keywords was updated.
      • Added the ability to create, edit, and drop Server via UI.
      • Added an ability to create, update, and delete users. 
      • Added the ability to create and edit triggers.
      • “Use SQL to limit fetch size” was set to true.
      • Added sargs, edge and Query parameters to the Execution plan.
    • Db2 z/OS: 
      • DDL generation for creating tables was improved.
      • Fixed broken configuration for generic drivers.
    • DuckDB: BLOB display was fixed.
    • DynamoDB: The connection URL was fixed. 
    • Google BigQuery: 
      • Composite data presentation was improved.
      • Procedures handling is now supported in SQL editor, including LOOPS, IFs, BEGIN END, and CASE.
    • H2: Schemas autocompletion was improved.
    • Ingres: driver download was fixed.
    • MySQL: 
      • DBeaver can now correctly display negative dates in MySQL databases.
      • Added support for table name in backticks for SQL Editor.
      • NULL geometry values handle was fixed.
      • Fixed an issue with table refresh when the “Server-side object filters” option is disabled.
    • Omnis Studio: Added support for connecting to Omnis Databases using the ODBC driver.
    • Oracle:
      • Added highlighting and validation of public synonyms.
      • Table autocompletion was fixed.
      • Fixed highlighting for public schemas.
      • BOOLEAN type is now supported in Data Editor.
    • PostgreSQL: 
      • Permission editor was fixed.
      • Added date picker and fixed data saving in the Role editor.
      • Fixed highlighting for public schemas.
      • Fixed data change saving in Value Panel.
      • Schema permission editing was fixed.
      • Default privileges rendering was fixed.
    • Redshift: 
      • Access to external databases was fixed.
      • Session manager was significantly improved; data is now displayed correctly.
  • RisingWave: Array handling was improved.
  • Salesforce Data Cloud: The connection dialog layout was fixed.
  • SAP HANA:
    • Connection dialog was improved for HANA Cloud.
    • Expired password change feature was added.
  • SQLite:
    • Fixed an issue with duplicate primary key generation in SQL scripts.
    • Fixed an issue with deleting a column without a data type.
  • Teradata:
    • Added a “Show all databases” option to the connection page (disabled by default).
    • Navigator now displays only the databases accessible to the user.
    • Fixed issues with multi-row inserts during data import.
    • Fixed incorrect display of the PERIOD data type.
    • Improved handling of maximum rows.
  • Trino: The issue with the long cursor reading was fixed.
  • Virtuoso: replaced static jar file with Maven artifact.
  • Localization:
    • Arabic localization was added.
    • Brazilian Portuguese localization was updated.