DBeaver 23.0

Changes since 22.3.5:

  • SQL editor:
    • Column metadata resolution was fixed for quoted column names
    • SQL console now respects “open separate connection” option
    • Variables resolve in @set and other commands was fixed
    • Copy/paste command was fixed for editors without associated connection
  • Data editor:
    • Spatial viewer: lasso tool was fixed for Safari browser
    • Support of WKT format stored in BLOB columns was added
    • Issues with image viewer and BLOB columns was fixed (NullPointer error))
    • Selected columns/rows data export was fixed (issue with BLOB value turning into NULL in UI)
  • Accessibility:
    • Font settings are now respected in all editors/popups
    • New keyboard shortcuts schema was added “DBeaver Keyboard Only”
    • Many new keyboard shortcuts were added
    • Catalog/schema selector now supports keyboard only mode
    • Results tab pin/unpin command is now accessible from keyboard (thanks to @hawthorne3341)
    • Reader texts were localized
  • Database dashboard create wizard UI was fixed
  • Generate SQL dialog now supports connection invalidation
  • Clickhouse: driver version was updated to 0.4.1
  • Dremio: driver version was updated to 24.0
  • Firebird: table colum comments support was added
  • PostgreSQL:
    • Issue with URL-based connections was resolved (invalid host name)
    • Execution plan parameters are now saved
  • Redshift: varbyte datatype suport was fixed
  • SQL Server:
    • UI for Kerberos authentication configuration was fixed
    • Table colum comments support was added
  • French localization was fixed (thanks to @alexgille)
  • Problems with Kerberos were resolved (we have reverted to Java 11)
Posted in Releases

DBeaver 22.3.5

  • ChatGPT smart completion:
    • Completion popup UI was improved
    • Metadata scope configuration was added
    • Redundant config options wer removed
  • Data editor:
    • Accessibility support was significantly improved (context menu, additional keyboard shortcuts)
    • Filtering and ordering icons visibility configuration was added again
    • Dictionary viewer was fixed (issue with missing dictionary values)
    • “Save filters” button was removed from custom SQL queries results
    • App crash on geometry viewer opening was resolved in the latest version of MacOS
  • SQL editor: query text extraction was fixed (issue with trailing comment after query text)
  • Database backup/restore: issue with external tools running was resolved (Linux)
  • Application fonts were unified. Now we have only Main and Monospace fonts configuration
  • Data transfer: data type mapping now respects type name case (for databases with different default case)
  • Variables support in database tasks was fixed
  • Database tools wizard: redundant task configuration page was removed
  • SQL generator dialog now show progress to avoid UI freeze on big schemas
  • Issue with opening ERD files from disk ws resolved
  • Clickhouse: DDL for array columns was fixed
  • Databricks: additional metadata was added
  • Exasol: default connection parameters were updated (thanks to @allipatev)
  • IRIS (ex Cache): driver version was updated
  • Oracle: stored procedures invocation syntax was improved
  • Snowflake: driver now uses single database connection for all editors (configurable)
  • SQL Server:
    • Driver version was updated to 11.2.3. Trust server certificate option was moved to the main connection page
    • Server messages (printed on raiserror) reading was fixed
    • Multiple resultsets reading was fixed (extra error handling was added)
    • VARCHAR(MAX) data type support was added
  • SQLite: converting binary columns into string representation was fixed
Posted in Releases

DBeaver 22.3.4

  • ChatGPT integration for smart completion and code generation (as optional extension)
  • Accessibility:
    • Text reader for entity editor was improved
    • Text reader for data grid was improved
  • SQL editor:
    • Query generation from human language text was added
    • Server output log levels configuration was improved
    • Global metadata search was fixed
    • Variables resolution is fixed in strings and comments
    • Issue with queries with invalid line feeds was resolved
  • Data editor:
    • Grouping panel messages were improved
    • Datetime calendar editor was fixed (in panel and inline editor)
  • Database navigator: issue with rename/refresh was resolved
  • Dashboards were fixed for inherited databases
  • Project import now sets DBeaver nature (thanks to @froque
  • ERD: custom diagram editor was fixed (issue wth missing notes and connections was resolved)
  • Databricks: table DDL reading was fixed, extra SQL keywords were added (thanks to @mixam24)
  • DB2 BigSQL: table with RID_BIT columns data reading was fixed (thanks to @bkyle)
  • MySQL: numeric identifiers quoting was fixed
  • Netezza: tables/views search query was improved
  • PostgreSQL:
    • Procedures invocation was improved (thanks to @plotn)
    • Filter by enum was fixed (thanks to @plotn)
  • Redshift: triggers DDL reading was fixed
  • Snowflake: table constraints reading was fixed
  • We switched to Java 17 so now DBeaver supports all newest JDBC drivers
Posted in Releases

DBeaver 22.3.3

  • SQL editor:
    • Output logs viewer now respects log levels and supports log search
    • Auto-completion for mixed case schema name was fixed
    • Result tabs count message was fixed
    • Auto-completion of cell values is now configurable
    • Query execute time is now populated in statistics (thanks to @bob27aggiustatutto)
    • Mixed-case variables resolution was fixed
    • Execute statistics UI was fixed (redundant info was removed)
    • NPEs during auto-completion were fixed
  • Data editor:
    • Column name ordering in record mode was fixed
    • Chart type configuration added to the context menu
    • Issue with column focus in context menus was fixed
  • General UI:
    • Database navigator now respects font size customization
    • Dashboard graphs now support dark themes
  • DB2: client application name population was fixed
  • Exasol: privileges reading was fixed for SaaS (thanks to @allipatev)
  • MySQ:/MariaDB: schema privileges save was fixed (issue with UI refresh)
  • Oracle: complex data types resolution was fixed for resultsets
  • PostgreSQL:
    • Full backup with roles and groups is now supported
    • View triggers DDL was added
    • Procedure debugger was fixed
    • Issue with URL-baes connections backup was resolved
    • Vector data types support was fixed
    • Aggregate functions DDL was fixed
  • Redshift: incorrect schemas info read in different databases was fixed
  • Snowflake:
    • Java 17 support has been added
    • Complex DDL statements parser was improved
  • SQL Server: procedures and functions rename was fixed
  • Vertica: comments read can e disabled for all metadata (for performance)
Posted in Releases

DBeaver 22.3.2

  • SQL editor:
    • Execution plain visualization was improved
    • Variables binding was fixed for query execution plan explain
    • SQL templates completion was fixed
    • Auto-completion of complex names was fixed (issue with missing schema name)
    • Hippie auto-completion was disabled for complex identifiers
  • Data editor:
    • Drop-down menu icon rendering was fixed
    • Filter panel ordering was fixed
    • Filter values save/restore was fixed
    • Column context menu was enhanced
    • Context menu now respects column in focus
    • Pinned columns scrolling was fixed
  • General UI: host info was fixed for URL-based connections
  • SSH: issue with host validation popup was fixed
  • Exasol:
    • Driver version was updated to 7.1.16
    • Connection encryption support was improved
  • MariaDB: json data type support was fixed
  • MS Access: identifiers quoting was fixed
  • Snowflake: SQL procedures parser was improved (IF statements support)
  • SAP HANA:
    • Schema create/delete/rename functions were added
    • Tables statistics read was added
    • Additional keywords highlighting was added
    • Case-sensitive schema names support was fixed
  • SQLite:
    • Utility tables (sqlite_autoindex_%) support was fixed
    • View DDL generator was fixed
  • Vertica: expired password change was implemented
Posted in Releases

DBeaver 22.3.1

  • Data editor:
    • Columns filtering/ordering menu was redesigned
    • Virtual key definition behavior was redesigned
  • SQL editor:
    • Script statistics visualization was fixed
    • NullPointer error during new script opening was fixed
  • Data transfer: variables resolve in saved tasks was fixed
  • Folders drag-n-drop was improved. Drop into root is now possible
  • Drag-n-drop from navigator window was fixed for GTK
  • Native SQL script execute wizard UI was improved
  • Debug log file rotation was added, solves problem with huge log files
  • Errors during driver files download are now handled properly
  • SSL certificates configuration on Windows was fixed
  • Proxy settings are saved between app installations (Windows installer)
  • Confirmation dialogs were redesigned
  • “Reset UI settings” and “Reset workspace” behavior was redesigned.
  • Tasks view now shows tooltips
  • Data export in SQL INSERT format now supports custom target table name configuration
  • Issue with columns visibility in metadata editor was resolved
  • Chinese localization was extended (thanks to @bianyun1981)
  • Eclipse plugin now supports the latest Eclipse IDE version
  • DBeaver base platform was changed to Eclipse 2022-12
  • AWS Athena driver version was upgraded
  • PostgreSQL:
    • SSL keys automatic conversion was added
    • Template databases duplication was fixed
    • Object dependencies read query was fixed
  • Azure SQL Server driver configuration was fixed (multi-factor authentication support)
  • MySQL NDB driver configuration was fixed
  • MySQL: user name quoting was fixed
  • Multiple minor UI bugs were fixed
Posted in Releases

DBeaver 22.3.0

Changes since 22.2.5:

  • Data editor:
    • Data export button UI was enhanced
    • Fetch all data and fetch size controls were returned to status bar
    • Lasso tool was added to spatial viewer
    • Bug in spatial viewer initialization was fixed
    • BLOB contents opening in external editor was fixed for MacOS and Linux
    • Browser-based image viewer control was fixed (null or invalid images handle)
  • SQL editor:
    • Big SQL files support was improved (automatic disablement of syntax validation)
    • Table auto-completion tooltips UI was redesigned
    • Error on unassociated script opening was fixed
  • General:
    • Default SSL truststore selection was fixed (it is now configurable)
    • Connection edit/create dialog performance was improved
    • Database server version is now shown in connections’ tooltip
    • Object delete dialog was redesigned
    • Database create button was removed from the connection dialog for databases which don’t support it
    • Security patch for packaged drivers (additional validation of zip archives was added)
  • SSH: tunnel invalidation was fixed for SSHJ
  • Tasks: problem with tasks operating with missing (deleted) tables was fixed
  • Clickhouse: identifiers quoting was fixed (for non ASCII characters)
  • Intersystems Cache: community driver was added again
  • MySQL:
    • Hyperlinks navigation was fixed for procedures
    • Complex identifiers quoting was fixed
  • Netezza: columns metadataread ws improved
  • PostgreSQL:
    • Role create/edit command was fixed
    • PostgreSQL 15 support was improved (new data type category)
Posted in Releases

DBeaver 22.2.5

  • Data editor:
    • Top and bottom action toolbars were redesigned
    • Action buttons now show hints
    • Data export toolbar button is now configurable
    • Image viewer was switched to embedded web-browser mode (configurable)
    • The issue with spatial data viewer was fixed (“no more handles” error)
    • Errors in virtual column definition now handled properly
    • “Count nulls” function was added to the Calc panel
  • SQL editor:
    • Auto-completion with TAB key was implemented (!)
    • Hyperlink navigation was fixed for quoted identifiers and identifiers with spaces
    • The issue with keyword case auto-conversion was solved
    • Editor tabs now shows connection state icon (connected/failed)
    • Client-side commands prefix configuration was fixed
    • The issue with cursor position change on mouse right-click was resolved
  • Data transfer: tables/column mapping dialog was improved, problems with target column name were fixed
  • Database drivers:
    • License information was added to the most drivers
    • It is no longer need to restart DBeaver after driver settings change (bug in recent versions)
  • Connections:
    • SSH jump servers support was added for SSHJ implementation
    • Network profile edit UI was fixed
    • Connection error messages
  • General UI:
    • Dark theme support was added to XML editor
    • Dialog font settings is now applied to most popup dialogs
    • Database navigator quick filter now supports composite identifiers (thanks to @plotn)
  • Clickhouse: driver version was updated, this resolves many issues with different data types support
  • Oracle: DATE data type rendering is now configurable
  • PostgreSQL: auth role editor was moved to the database level
  • SQL server: it is now possible to disable TOP clause in select queries
Posted in Releases

DBeaver 22.2.4

  • SQL editor:
    • SQL script active database/schema restore was fixed
    • Parameters prefix configuration was fixed
    • Issue with cursor change on context menu invocation was fixed
    • Option to disable all code completions/foldings was added
    • Auto completion inside SQL package was fixed
    • Table aliases auto-completion was fixed
    • SQL blocks auto-completion was fixed
    • SQL variables/parameters disable configuration was fixed
  • Data editor:
    • Table columns resolution was improved for custom SQL queries
    • Hidden columns restore was fixed
  • Data transfer:
    • Columns mapping dialog was redesigned and improved
    • Columns scale/precision mapping was fixed
    • Import from XML format was fixed
  • Multiple MFA attempts were resolved (in drivers with MFA authentication)
  • Tasks: variable value prompt was added (configurable)
  • SSH tunnels: issue with private key password prompt was fixed
  • RPM package: issue with remaining symlinks after uninstall was fixed
  • UI perspective customization was fixed
  • Clickhouse: driver version was updated (solves many data type conversion problems)
  • PostgreSQL: inherited roles support was added
  • Snowflake:
    • Java 17 support was added
    • Stored procedure and functions management was added
  • SQLite: table column delete was fixed
Posted in Releases

DBeaver Community splash screen contest

Want to see your name on the splash screen of DBeaver Community 22.3? Unleash your creativity and participate in our contest to get this opportunity!

What do you need to do?

  • Create the PNG image with your design for the splash screen. The required image resolution is 601×301 pixels (or higher with the same aspect ratio).
  • Send your version to support@dbeaver.com by the end of November.
  • Wait for the results of the contest.

At the end of the month, we will choose the best image, and it will become our new Community splash screen for the next three months. The winner will get the DBeaver Ultimate license for one year, and his name will appear on the splash screen. We wish you good luck and look forward to seeing your designs!

Posted in News