March 13, 2023
Changes since 22.3:
- General improvements:
- The issue with column visibility in the metadata editor was resolved
- Project import now sets DBeaver nature
- Folders drag-n-drop was improved. Drop into the root is now possible
- Debug log file rotation was added, solving the issue with huge log files
- Errors during driver file download are now handled properly
- SSL certificate configuration on Windows was fixed
- Proxy settings are saved between app installations (Windows installer)
- Zip Slip Vulnerability was fixed
- The secured project refresh was fixed
- Database backup/restore: The issue with external tools running was resolved (Linux)
- Server output log level configuration was improved
- Global metadata search was fixed
- General UI:
- Host info was fixed for URL-based connections
- SQL generator dialog now shows progress to avoid UI freeze on big schemas
- “Reset UI settings” and “Reset workspace” behavior was redesigned
- Confirmation dialogs were redesigned
- Multiple minor UI bugs were fixed
- Dark theme support for graph view was added
- Application fonts were unified. Now we have only Main and Monospace fonts configuration
- Fonts were fixed, and the Font and Colors section in Preferences was updated
- Data editor:
- Data Editor icons were consolidated
- The columns filtering/ordering menu was redesigned
- Virtual key definition behavior was redesigned
- The drop-down menu icon rendering was fixed
- Filter panel ordering was fixed
- Filter values save/restore were fixed
- The column context menu was enhanced
- Context menu now respects column in focus
- Pinned columns scrolling was fixed
- Grouping panel messages were improved
- DateTime calendar editor was fixed (in the panel and inline editor)
- Filtering and ordering icons visibility configuration was added again
- The dictionary viewer was fixed (issue with missing dictionary values)
- The “Save filters” button was removed from custom SQL query results
- App crash on the geometry viewer opening was resolved in the latest version of MacOS
- Support of WKT format stored in BLOB columns was added
- Issues with the image viewer and BLOB columns were fixed (NullPointer error))
- Selected columns/rows data export was fixed (issue with BLOB value turning into NULL in UI)
- SQL editor:
- Script statistics visualization was fixed
- NullPointer error during new script opening was fixed
- Execution plan visualization was improved
- Variables binding was fixed for the query execution plan explain
- SQL template completion was fixed
- Auto-completion of complex names was fixed (issue with missing schema name)
- Hippie auto-completion was disabled for complex identifiers
- Query generation from human language text was added
- Variables resolution is fixed in strings and comments
- The issue with queries with invalid line feeds was resolved
- Query text extraction was fixed (issue with trailing comment after query text)
- Column metadata resolution was fixed for quoted column names
- SQL console now respects the “open separate connection” option
- Variables were resolved in @set and other commands were fixed
- The copy/paste command was fixed for editors without an associated connection
- The ability to disable value autocompletion that involves executing SELECT DISTINCT was added
- Native SQL script execute wizard UI was improved
- Generate SQL dialog now supports connection invalidation
- Accessibility:
- The text reader for the entity editor was improved
- The text reader for the data grid was improved
- Font settings are now respected in all editors/popups
- A new keyboard shortcut schema was added “DBeaver Keyboard Only”
- Many new keyboard shortcuts were added
- The catalog/schema selector now supports keyboard-only mode
- Results tab pin/unpin command is now accessible from the keyboard
- Accessibility support was significantly improved (context menu, additional keyboard shortcuts)
- Reader texts were localized
- Screen reader behavior was improved due to the users’ feedback, and some big font issues were fixed.
- Visual Query Builder:
- Support for Ctrl+Z operation was added
- The ‘Create JOINs automatically’ in VQB is always on bug was fixed
- ERD:
- The issue with opening ERD files from disk was resolved
- Data transfer:
- Import CSV to the existing table was fixed
- Export to SQL INSERT statements..’ Insert into export’ issue was fixed
- Data Export to Google Sheets and Google Drive was added
- Schema is migrated to active [not chosen] database issue was fixed
- Data type mapping now respects type name case (for databases with different default case)
- Data export in SQL INSERT format now supports custom target table name configuration
- Spatial viewer:
- The lasso tool was fixed for the Safari browser
- App crash on the geometry viewer opening was resolved in the latest version of MacOS
- Task management:
- The redundant task config page was removed
- Tasks view now shows tooltips
- Variables support in database tasks was fixed
- Variables resolved in saved tasks were fixed
- Performance:
- PRO distribution size was reduced
- Execution plan:
- The incorrectness of the graph view for the execution plan for more than one table was fixed
- An issue with showing the Execution plan on Windows was fixed
- SSH:
- A jump server option for SSHJ was added
- The confirmation dialog issue was fixed
- The issue with the host validation popup was fixed
- Visualization:
- Chart-type settings were moved to the context menu
- Database navigator:
- The issue with rename/refresh was resolved
- Drag-n-drop from the navigator window was fixed for GTK
- Eclipse:
- Eclipse plugin now supports the latest Eclipse IDE version
- DBeaver base platform was changed to Eclipse 2022-12
- DBeaver SVG format support extension was fixed
- PostgreSQL:
- The ability to create a full backup, including connection roles and groups, was added
- PostgreSQL compare issues were fixed
- SSL keys automatic conversion was added
- Template database duplication was fixed
- Object dependencies read query was fixed
- Procedures invocation was improved
- Filter by enum was fixed
- An issue with URL-based connections was resolved (invalid hostname)
- Execution plan parameters are now saved
- SQLite:
- GIS data values displaying bug was fixed
- Utility tables (sqlite_autoindex_%) support was fixed
- View DDL generator was fixed
- Converting binary columns into string representation was fixed
- SQLite external databases were revert
- BigQuery:
- An issue with connecting to BigQuery in the PRO version was fixed
- Netezza:
- Improved data mapping
- tables/views search query was improved
- Clickhouse:
- DDL for array columns was fixed
- ClickHouse driver was updated for PRO.
- MySQL:
- User name quoting was fixed
- Numeric identifiers quoting was fixed
- MariaDB:
- An issue with editing the JSON cell in DBeaver PRO was fixed
- Redshift:
- Incorrect syntax in creating user/role was fixed
- The production Connection Type bug was fixed
- The ability to not generate SQL / DDL with triggers was added
- Data shares meta-model read has been refactored
- SQL Server:
- The driver version was updated to 11.2.3. The trust server certificate option was moved to the main connection page
- Server messages (printed on raise error) reading was fixed
- Multiple resultsets reading was fixed (extra error handling was added)
- VARCHAR(MAX) data type support was added
- UI for Kerberos authentication configuration was fixed
- Table column comments support was added
- Liquibase:
- NPE, when DDL can’t be read, was fixed
- Firebird:
- Remove the Create button from the Firebird Connection wizard
- InfluxDB:
- The ability to zoom graphs was added
- LocalDateTime parse for the date editor was fixed
- The reading of Tag and Field values was fixed
- Vertica:
- Password change support for Vertica was added
- Couchbase:
- “No Data” for tables without index issue was fixed
- Analytic query support was added
- Databricks:
- Table DDL reading was fixed, and extra SQL keywords were added
- View DDL generator was fixed
- Additional metadata was added
- Snowflake:
- Snowflake extension was added to Community and Enterprise
- SQL procedures parser was improved (IF statements support)
- Table constraints reading was fixed
- The driver now uses a single database connection for all editors (configurable)
- Oracle:
- Incorrect Oracle data type in the result set was fixed
- The Connection Wizard bug for Oracle with OS Authentication was fixed
- Stored procedures invocation syntax was improved
- MongoDB:
- An issue with JSON view cutting the Chinese words was fixed
- The error when running db.runCommand was fixed
- The issue with boolean values was fixed
- Some MongoDB bugs were fixed.
- Teradata:
- Kerberos Authentication was added
- Teradata Secure Zones support was added
- The visible tree in the Simple view mode was fixed
- Exasol:
- The driver version was updated to 7.1.16
- Connection encryption support was improved
- Default connection parameters were updated
- SAP HANA:
- Schema create/delete/rename functions were added
- Tables statistics read were added
- Additional keyword highlighting was added
- Case-sensitive schema name support was fixed
- MS Access: identifiers quoting was fixed
- DB2 BigSQL: table with RID_BIT columns data reading was fixed
- CouchDB: The filters were fixed
- Redshift: var byte datatype support was fixed
- Firebird: table column comments support was added
- Localizations:
- French localization was fixed
- Chinese localization was extended
- Database drivers:
- A new ODBC driver was added
- Support for Oracle Autonomous JSON Database was added
- Support for AWS Timestream was added
- The AWS Athena driver version was upgraded
- MySQL NDB driver configuration was fixed
- IRIS (ex Cache): The driver version was updated
- Dremio: The driver version was updated to 24.0