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