September 12, 2023
Changes since 23.1:
- New drivers:
- Azure Cosmos DB
- AWS Timestream
- Amazon Neptune
- Influx 3
- Crate DB for Postgres
- Materialize
- Salesforce
- TDengine
- General:
- We switched to Eclipse 2023-06 and Java-17 as a base platform
- The internal app controller server now uses HTTP instead of RMI
- We have improved the security of storing user settings and Preferences
- SQL script opening was fixed
- The issue with not stopped generating DDL queries was fixed
- DDL generation for the sequence was fixed
- Redundant bytes were removed from dbeaver-debug.log
- Redundant logs of SSH tunnel closing were removed
- The issue with the program launch with the wrong Java version was fixed
- CLI parameter for app version print was added
- CLI processing was fixed in a multi-workspace environment
- The command line connection opening was fixed
- The Maven snapshot repository was added to the default configuration
- General UI:
- Network handlers (SSH, SSL, etc) UI was redesigned
- The preference page was reorganized (AI moved to the General section, Enterprise Security moved to the Security section)
- Objects sorting in tables can now be reset to the original ordering
- Users can use drag-n-drop to copy scripts, open database objects, and insert Navigator node names into the editor
- Settings reset UI and behavior was redesigned
- The editor tab tooltip now contains information about the resource’s project
- Driver search UI was fixed on MacOS
- The creation of objects with mixed-case identifiers was fixed
- External file opening was fixed on MacOS and Linux
- The issue with preference pages in the Eclipse plugin was resolved
- Auto-commit mode switch behavior was fixed
- Logical database structure settings can be disabled or reset in the connection editor dialog
- Logical project deletion was fixed
- Notifications:
- Notification management was improved: now you can choose in Preferences when you need a notification and if you need a sound for it
- Notifications in Dark theme became topic “Notices in the dark” became readable
- “Tip of the day” was updated, and now shows OS-specific shortcuts properly
- SQL Editor:
- Users can configure the options on the toolbar by pressing the gear button in the editor
- Spelling errors and other annotations now work in console mode
- Spelling now works with URLs and non-letters at word boundaries
- Trailing DDL query delimiter processing was fixed
- Table alias generation was fixed (issue with duplicated aliases)
- Auto-proposals now respect the option “empty line is a query delimiter”
- Auto-proposals calculation performance was significantly improved in some cases
- Aliases completion was fixed (issue with redundant spaces)
- Table name completion was fixed for invalid SQL queries
- Autocompletion in single-line comments was fixed
- Smart completion for CTE queries (WITH/SELECT) was fixed
- @include command handler was fixed (reuse the console for the same included script)
- INSERT SQL query generation was fixed (identity columns)
- Variable value editor was fixed
- Issue with text search/replace in hidden files was fixed
- Issue with the missing “Copy file path” option was fixed
- Mouse hovering over editor annotations was fixed
- Data Editor:
- The statistics view can now be disabled
- The dictionary viewer panel UI was redesigned
- The references panel refresh was fixed
- Folding in the XML presentation was fixed
- XML presentation was fixed (NULL value handler)
- Users can see chart presentations for non-numeric values, for example, for salary or grades
- Charts rendering errors visualization was improved
- Filters/orderings/colors reset UI was significantly improved
- Grouping panel icons were improved
- Drag-n-drop in the Grouping panel was fixed on Linux
- Find/Replace dialog and shortcut in the Value view panel were fixed
- Column description was added to the Metadata panel
- Displaying of images in the Value view panel was fixed on Linux
- Column tooltips were fixed
- Confirmation dialog for the result set filtering was improved
- An issue with closing the Result when saving data was resolved
- Render of non-displayable characters was improved
- Spatial data viewer:
- Geometry object labels were added to the map (configurable)
- Curves rendering was implemented
- Copying of spatial viewport/selection bounds was fixed
- EWKT format support was added
- Toolbars and lasso visibility toggle were fixed
- Spatial data types: curved geometries linearizing was fixed
- Spatial viewer now hides empty labels
- Spatial tiles configuration was fixed
- Non-display of PostGIS geometry due to missing SRID prefix was fixed
- Saving picture in Spatial view was fixed
- Spatial values rendering was fixed
- Spatial image capture was fixed
- Special character rendering was improved
- ER Diagrams:
- The issue with element removal after using the View Style option was fixed
- The grid foreground color was fixed
- Saved diagrams can now be opened on other computers
- CTRL+SHIFT+ENTER opens the selected table diagram
- Execution plan: The white background in the dark theme was fixed
- Data transfer:
- Import of multiple sheets from an XLSX was implemented
- The issue with exporting a table without data when using bulk loading was fixed
- Lazy initialization of configuration pages was implemented
- The issue with the duplicated file selector dialog was fixed
- Export in XML format was fixed (the doctype section is now not optional)
- The issue with long filenames on Windows was fixed
- Previous export settings loading was fixed
- Import settings handling was improved
- Connectivity:
- Now you can connect to a database using Kubernetes proxy. To configure it, click the “Network configuration” button in the connection dialog.
- ODBC driver was enhanced: driver properties can be read and saved, date conversion works as expected and some other minor bugs were fixed
- The “Automatically end long idle transactions” option was redesigned
- Authentication failure when connecting via SSH was fixed
- Now users can connect with the jump server using SSHJ
- The issue with connecting to Azure SQL Server using Active Directory was fixed
- The issue when adding driver properties was fixed
- AWS SDK version was upgraded which fixed the issue with connecting via AWS SSO from CLI fixed
- AWS STS client failing was fixed
- AWS SSO authentication doesn’t ask for a user password
- Google Cloud authentication profiles now have different names
- Kerberos support in legacy JDBC drivers (Hive) was fixed
- The user name/password prompt dialog was fixed for SSH tunnels
- Duplicates on driver creation were removed
- The issue with Maven artifacts editing was fixed
- Opening the Trust store was fixed on macOS
- Security:
- Certificate management was added: You can find CA certificates used for SSL access in the Trust store section in Preferences or import your own certificate.
- Project and user password security was improved.
- We have improved the security of storing user settings.
- SQLite driver version was updated due to the vulnerability CVE-2023-3269.
- Bug with connection and project password conflict was fixed
- Security issue with two project passwords asked on startup was fixed
- User passwords now cannot be seen by using a variable
- Accessibility:
- Connection dialog now supports screen readers
- Cell value reading was improved
- Ctrl+Shift/Alt+PageDn: vertical tabs switch
- Ctrl+ALT+6: SQL editor and results tab switch
- Ctrl+Shift+Enter now opens ER diagram entities
- Ctrl+Shift+N: new connection dialog open
- JAWS and Narrator support was improved for the Data editor and vertical tabs
- High contrast theme support was significantly improved. You can choose a high contrast theme in your OS, and the DBeaver high contrast theme is enabled.
- Databases
- Azure MS SQL: The execution plan is working now
- Athena:
- Multi-catalog support was added
- IAM roles can be used for authentication
- BigQuery:
- Driver version was upgraded to 1.3.3
- DDL for tables, views, and stored procedures was added
- Cassandra: The SSL connection page was redesigned
- Clickhouse: arrays and structures visualization was fixed
- DB2: Users can see Column Mask Objects
- DB2z and Denodo: “Show duplicates” button in the Grouping panel was fixed
- Derby: Grouping query generation is fixed
- DuckDB:
- LIST data type support was added
- TIME/TIMESTAMP data types support was added
- DynamoDB: Inability to access with 3d party account was fixed
- Firebird: Filters and sorting in the Grouping panel were fixed
- Greenplum 7.0:
- Function DDL was fixed (default parameter values)
- Partition metadata reading was enhanced
- Tables DDL was fixed — the USING part was added (for version 7)
- External tables reading was fixed
- IBM i: driver download was fixed
- MongoDB: Create index options are now handled
- MySQL: The issue with the missing table partitions folder was resolved
- OpenGauss DB: JSON data types support was added
- Oracle:
- XML presentation was added
- Dates of creation and modification appeared in the information about the packages
- Table partitions and subpartitions reading were fixed
- Partitions cache refresh was fixed
- Missing tablespace statistics after object update was added
- Stored procedures edit/save were fixed
- Table DDL now shows permission grants in “full” mode
- PostgreSQL:
- Enum columns ALTER was fixed
- An issue with duplicated tables was resolved
- The default native clients (pgsql, pg_dump) version was changed to 15
- Redshift: SQL dialect was enhanced with extra keywords
- Teradata:
- Database reading, search, and auto-completion in hierarchy mode were improved
- The issue with the missing templates was fixed
- The Salesforce CDP driver version was downgraded to version 1.16.0 due to the exception
- SingleStore: Triggers are now supported
- Snowflake:
- Quotation rules for object identifiers were added
- Bulk load support in data transfer was added
- TimescaleDB branding was updated
- Vertica: stored procedures are supported, you can view and execute them. The execution plan is available, including JSON queries.
- Yellowbrick:
- Execution plan visualization was fixed
- The stored procedures drop query was fixed
- Localization:
- Chinese Simplified localization was improved
- Chinese localization was updated
- German localization was improved
- Users can now select Portuguese as the default language during installation or in Preferences
- Portuguese localization was improved