DBeaver Lite 23.0

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