DBeaver Enterprise 23.1

June 12, 2023
Changes since 23.0:
  • General:
    • Microsoft Store: The issue with application installation was fixed on most machines
    • We switched to Java 17 (again)
    • We switched to Eclipse 2023-03 as a base platform
    • The bug with the version display was fixed
    • The SalesForce CDP driver was updated
    • Java native libraries were added to DBeaver installation directly to avoid app crashes caused by system restrictions.
    • DBeaver started to collect user statistics. It is anonymous and optional
    • The ‘Use Windows trust store’ option can be applied in headless mode
    • App name is now passed to MongoDB, DocumentDB, and other NoSQL databases
    • The ability to automatically import PRO licenses from files in TXT format was added
    • Images for all DBeaver Eclipse extensions were added
  • Spelling services were added:
    • Different highlighting for SQL keywords and grammar mistakes was added
    • The ability to show spelling annotations differently than errors was added
    • Scrolling to the next/previous annotation using CTRL+. ctrl+,), add commands in the navigation main menu was added
    • SQL keywords were included in the dictionary
    • Work with the custom scope was improved
  • ODBC improvements
    • The ability to work on Linux and macOS was added
    • The ability to use ODBC instead of JDBC for most data sources was added 
    • Connection errors were fixed
    • Memory issues were fixed
    • The issue with disappearing database names in DB2 when switching ODBC-JDBC was fixed
    • SQLServer support was added
    • Missing set methods in prepared statements were added
    • Driver substitute selector was added to a new connection
    • Default values for host/port/database/use were added
    • Reading/writing of arrays and structs was implemented
  • AI (ChatGPT)
    • The ability to specify the custom endpoint was added
    • The issue with cutting off queries was fixed
    • Unsupported AI models were replaced with new ones
    • The issue with not saved settings was fixed
  • General UI:
    • Part divider UI was redesigned
    • The option to increase formatting time was added in the Preferences
    • The issue with closing pinned tabs using ‘Close Tabs to the Left’ was fixed
    • Zoom-in text editors and data editors were fixed
    • Navigator tree refresh after metadata change was fixed
    • The default font size was increased for MacOS
    • Text font configuration was fixed in multiple dialog windows
    • Connection type settings change now affects UI properly
    • The issue with white nodes in the Execution plan on the Dark theme was fixed
    • Database editors remain open after disconnect (configurable)
    • Clickable hints are now displayed as links
    • The issue with missing icons in the toolbar on MacOS was fixed
    • Font and color changes in the Result Set were improved
    • Large fonts now display correctly on MacOS
    • The issue with zoom in and out with Ctrl++ and Ctrl+
    • in SQL Editor and Data gird was fixed
    • ER Diagram font now depends on the Main font
    • A lot of UI rendering improvements were made
    • The issue with resizing the user authorization window was fixed on Linux
    • Changing the size and position of the connection dialog is now saved
    • The issue with the application freezing when creating a table when the connection hangs was fixed
    • Tips of the day were revised
    • The background color of the object search panel was fixed in the Dark theme
  • SQL Editor:
    • Font changes are now applied without a restart
    • The results tab can now be detached
    • The editor toolbar can now be customized to preferences
    • The query statistics tab can now be turned off
    • Table metadata search was improved
    • Moving with Ctrl+Right/Left now considers words with an underscore and a dollar as a whole word (configurable)
    • Autocomplete for mixed-case was improved
    • The issue with crashing when closing the SQL Editor tab was fixed
    • Order by parsing was improved
    • The issue with the refresh button closing the active result tab was fixed
    • The issue with not correctly displaying \r\n sequence was fixed
    • The issue when generating the same UUID for all rows was fixed 
    • Hovering information for SQL errors and spelling annotations was added
    • Variable and parameter names in the binding dialog are now displayed in their original case
    • Information about assigning a non-dynamic variable was added to the binding dialog
    • The issue with an incorrect icon for Execute SQL Statement after opening the Output tab was fixed
    • Query Manager: The ‘Restore Default’ button behavior was improved
    • The ability to directly execute SQL scripts in native clients was added
    • Autocomplete now supports [ ] and ` as quotes for identifiers
    • Shortcut conflict on macOS was fixed
    • JSQLParser was reverted to version 4.5 and is now faster
    • The issue with substitution variables in text with \n line feeds was fixed
    • Autocomplete case with FROM right after SELECT is now handled
    • Autocomplete for SELECT query without FROM was fixed
    • The ‘Go to Matching Bracket’ shortcut was changed to CTRL+SHIFT+[
    • Autocomplete for columns in tables without alias was fixed
    • Completion analysis errors are now written to the debug log
    • Comment with a tab after a double dash is now handle
    • The issue with hiding the cursor position after resizing the editor was fixed
    • The exception when updating editor annotations was fixed
  • Data Editor:
    • The bottom toolbar became customizable. Users can select which buttons to show or hide
    • Disconnected editors can be easily reconnected
    • The issue with the CTRL+1 shortcut not working was fixed
    • Show numeric values (e.g., infinity) rendering was improved
    • The issue with opening images from the value panel in the external editor was fixed
    • Data filter support in the Grouping panel was added
    • Opening TXT, JSON, and XML files in external editors was improved on macOS and Linux
    • Rendering of non-display characters was improved
    • The issue with the disappearing filter option, when a query returns nothing, was fixed
    • Microseconds epoch transformer was added 
    • Data ordering was improved
  • Database Navigator: The issue with creating a new view was fixed
  • ER Diagrams:
    • ER Diagram became accessible: users can work with it using the keyboard and the NVDA screen reader
    • Many keyboard shortcuts were added
    • The issue with the diagram re-layout after the options change was resolved
    • The issue with moving focus when searching was fixed
  • Visual Query Builder: The icon which opens Preferences was updated
  • Data Transfer:
    • The ability to change the target column type on import to BIGINT was added
    • The ability to select a sheet for import from Excel was added
    • Export from query to CSV was fixed
    • Column description support was added for CSV and XLS formats
    • The ability to change column type from string to text while exporting from MongoDB to MariaDB/MySQL was added
    • The Liquibase library version was updated
    • The issue with set max column length when exporting in TXT was fixed
    • The issue with exporting JSON to TXT was fixed
    • Exporting of BLOB values in TXT format was improved
    • The ability to trim string values when exporting to XLSX was added
    • Handling of datetimeoffset was added
    • The issue with import templates from DBeaver Community was fixed
  • Schema compare:
    • The ability to change the structure of the result table (add additional items) was added
  • Tasks:
    • Unwanted confirmation for scheduled task start was removed
    • Email notification about the failed scheduled tasks was added
    • The option to not verify the mail server certificate was added
  • Git: Missing git buttons and menus were added on macOS (Apple Silicon)
  • Connectivity:
    • Kerberos subject authentication support was added.
    • It is now possible to connect through Azure Cloud without entering a username.
    • The issue with the inability to connect via Azure SSO after token expiration was fixed
    • Legacy SSH algorithm support was added
    • Support of new crypto ciphers was added
    • SHH agents now work properly on Linux
    • Native network proxy configuration was fixed
    • Confirmation dialogs now remember user selection
    • The number of attempts to reopen the connection was reduced
    • The ability to connect via SSHJ with an unsaved password was added
    • Maven artifacts configuration now supports classifier
    • Kerberos: support auth subject authentication was added
    • The link on the instruction on the Kerberos connection configuration was added
    • Notification about the requirement to restart after setting up a connection via Kerberos was added
    • The issue with the driver fallback not being updated was fixed
    • Bug with additional username requests during connection through Azure was fixed
    • AWS SSO issue with authorization was fixed. You can now authenticate via the browser
    • The option to disable SSHJ hostname verification was added 
    • Issue when switching from Community to PRO version and vice versa was fixed
  • Security:
    • The ‘Show password’ option now works again on macOS
    • The issue with the master password needed for the headless start of the task was fixed
    • Issue with disabled ‘Use security password’ option, after resetting UI settings, was fixed
  • New drivers:
    • NetSuite driver was added
    • Raima support was  added
    • SingleStore support was added
    • TiDB was added 
    • TiDB Cloud Telemetry support was added 
  • ClickHouse:
    • The driver version was updated to 0.4.6 
    • Error position display was added 
    • Catalog support was added
    • ClickHouse: the display of large numbers was fixed
  • Databricks:
    • Support of table comments was added
    • Handling of data types without parameters was added
  • DB2 i: Schema compare support was added
  • DB2: NullPointerException error while running Explain Execution plan was fixed
  • Firebird:
    • Procedure parameters default values support was added
    • Recognition of procedure parameter data types was improved
  • Greenplum: support of version 7.0 was added
  • MongoDB:
    • The query document count was fixed
    • The issue with repeated rows after scrolling to the limit of displayed rows was fixed
    • Work of db.getCollection(“alert_record”).stats() was fixed
  • MySQL:
    • Event reading for quoted schemas was fixed
    • Time handling was improved
    • Partition support was added
    • The issue with the empty privileges list was fixed
  • Oracle:
    • Additional properties in the table info were added
    • The issue with cropped ‘q’ at the end of the string was fixed
    • Stop displaying the ‘filler’ time value when querying the DATE data type
    • The issue with parsing IF EXISTS statements was fixed
    • The display of DATE with additional settings in the Result Set was fixed
    • Information about the latest statistics update was added
    • TNS import was fixed
    • The issue with native clients hanging when running SQLPlus scripts was fixed
    • The issue with setting the wrong schema after connecting or changing the Data Editor was fixed
    • Exception with reading table with null BLOB was fixed
  • PostgreSQL:
    • Materialized view dependencies were added
    • Composite data type support was improved
    • Array presentation was improved
    • Generation of ALTER table SQL for foreign tables was improved
    • Role settings were added in the generated DDL
    • IDENTITY SEQUENCE was added to the generated DDL
    • The issue with duplicate tables with generated columns in Database Navigator was fixed
    • An error message about the line on the map created with a single point was added
    • Schema refresh was fixed
    • The issue with an exception when loading attribute information was fixed
    • Reading a numeric array was fixed
  • Redshift:
    • The issue with renaming a view in Database Navigator was fixed
    • The issue with the ‘Show all database’ option was fixed
  • Snowflake:
    • Creation time is now shown for views
    • LiquibasePro support was added
    • The issue with the impossibility of changing the password for the created user was fixed
    • Spatial data support was added
    • The issue with incorrect import with BIGINT, INT, REAL, FLOAT, DOUBLE PRECISION, and DECIMAL data types was fixed
    • TIMESTAMP formatting was fixed
  • SQLite:
    • Triggers delete was implemented
    • The issue with database synchronization with the server was fixed
    • STRICT mode support was added
    • The ability to open ER Diagram in Simple View was added
  • Teradata:
    • Role support for Secure Zones was added
    • The ability to use Keytab for Kerberos authentification was added
    • The issue with connecting via Kerberos was fixed
    • The driver was updated. New versions will be downloaded from Maven
  • Trino:
    • The issue with import files with the varchar data type was fixed
    • Error handling was improved
  • Other databases:
    • BigQuery: the ability to connect via SSO was added
    • DynamoDB: issue with limit and key conditions queries were fixed
    • Hana: comments handling was fixed
    • Influx: The bug with reading tags after 30 days was fixed
    • Informix: The issue with extra spaces in the table name was fixed
    • SQL Server: The issue with duplicated data types was resolved
    • MariaDB: partition support was added
    • Sybase/SQL: The result set size limitation in SQL was fixed
    • The UCanAccess driver was updated to 5.0.1
    • Vertica: expired password change feature was added
  • Localization:
    • Traditional Chinese, Brazilian Portuguese, German, and Italian translations were updated
    • Traditional Chinese language was added to the Windows installer