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

DBeaver 22.2.3

  • Data editor:
    • Value display format option was added to grid data view
    • Dictionary view panel now saves its ordering state
    • Row number in the record mode was fixed
    • Ability to open external editors for BLOB values was added
  • Database backup: variable ${schema} was added
  • SSH:
    • Problem with redundant password prompt was fixed
    • Tunnel config tab is now hidden for databases which don’t support SSH
  • Drivers:
    • Driver version auto-update feature added
    • Issue with driver download dialog was fixed (non-clickable dialog)
    • Driver license info button was added to the connection edit page
  • Data transfer:
    • Export to XLSX now support different modes for spreadsheet rows append
    • Description column was added to XLSX format (configurable)
    • An additional confirmation is shown if output file will be overwritten
    • Fallback directory was added for data export tasks
  • Tasks:
    • Tasks viewer now shows tasks only for the active project
    • New task create command enablement was fixed
    • Running tasks are now checked and confirmation is shown on DBeaver app shutdown
    • Additional logging was added for tasks execution
  • Clickhouse: SSL support was fixed
  • Greenplum: table list read was fixed for recent GP server versions 6+.
  • MariaDB: UUID data type support was fixed
  • MySQL/MariaDB: problem with grave accent quoting was fixed
  • Oracle: DATE data type rendering was fixed (time part was removed)
  • PostgreSQL:
    • Problem with result sets fetch was fixed (OutOfMemory on big results)
    • Driver version was updated to 42.5.0 (security update)
    • Issue with numeric fields formatting in struct types was fixed
  • OpenSearch driver configuration was added
  • General:
    • Multi-connections behavior configuration was improved. Possibility to forcibly disable or enable additional metadata or SQL editor connections was added.
    • Additional localization was done in many places of application
    • We switched to a new Eclipse platform version (2022-09)
Posted in Releases

DBeaver 22.2.2

  • Data editor:
    • “Hide all empty columns” action was added
    • References panel now has a button to open target table
    • Ordering by multiple columns was fixed
    • Filtering by spatial columns was fixed
    • URL transformer was fixed (original value edit is now supported)
    • LOB editor opening performance was significantly improved
    • SQL terminal now shows server output log
    • Column comments are now visible in record mode
    • Complex data types visualization was fixed for record mode
  • Data transfer: bug in CSV export with custom header format was fixed
  • SQL editor:
    • Problem with NULL column names in custom queries was fixed
  • Database drivers:
    • Problem with driver jars re-download was fixed
    • It is now possible to disable Windows certificate storage usage
  • Athena: driver version updated to 2.0.30
  • Clickhouse: datetime64 data type support was added
  • DB2: driver version was updated to 11.5.7
  • Exasol: user list read read was fixed (thanks to @allipatev)
  • Greenplum: prepared statements usage was disabled
  • MySQL:
    • Default database client was changed onto version 8+
    • JSON columns now can be used in filters and as keys
  • Oracle: schema full DDL was added
  • PostgreSQL:
    • Problem with missing primary key in new tables was fixed
    • Table DDL for partitioned tables was fixed
    • Role comments are now visible/editable
  • German localization was improved (thanks to @dan-schneider)
Posted in Releases