DBeaver 24.2.3

  • 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
Posted in Releases

DBeaver 24.2.2

  • 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
Posted in Releases

DBeaver 24.2.1

  • 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)
Posted in Releases

DBeaver 24.2

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)
Posted in Releases

DBeaver 24.1.5

  • 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
Posted in Releases

DBeaver 24.1.4

  • 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
Posted in Releases

DBeaver 24.1.3

  • 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)
Posted in Releases

DBeaver 24.1.2

  • 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
Posted in Releases

DBeaver 24.1.1

  • 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
Posted in Releases

DBeaver 24.1

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)
Posted in Releases