DBeaver Enterprise 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.
  • 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 and execute complex SQL queries. 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.