DBeaver 21.3.3

Posted on by Serge
  • Data editor:
    • Date/time editor now supports calendar-like UI
    • Column names quoting was fixed in filter clauses
    • Filter for array columns was fixed
    • Gis viewer: SRID switch behavior was fixed
    • Save/cancel button are now disabled during data save process
    • Column filter now uses exact match for numeric values
    • Status message now shows execute timestamp
    • Advanced copy now respects quoted column names
  • SQL Editor:
    • Multiple result tabs refresh was fixed
    • Import file now supports multiple files selection
    • Client-side commands (@set, @include) parser was fixed
    • Auto-completion fix for SELECT .. INTO queries
    • Auto-completion now uses “hippie” completion algorithm by default
    • Copy as source code: Delphi format was fixed
    • “Copy selected query” command was added
    • Variables and parameters deletion was improved
    • SQL formatting was fixed (redundant empty lines eliminated)
    • Tab context menu was improved (additional items were added)
    • Code folding restore was fixed
    • Multi-cursor edit mode was added
  • Data transfer:
    • XLSX import was improved (problem with column mapping was fixed)
    • Import from CSV now uses approximate column length calculation
    • Append to file mode was fixed
  • Navigator: tree state loading was fixed
  • SSH tunnel:
    • Advanced tunnel configuration UI was improved (window auto-resize)
    • Tunnel test dialog now supports test interruption
    • Private key configuration was fixed for jump servers
  • Task execute status now shows more detailed information
  • Eclipse plugin: history navigation shortcuts support was fixed
  • MacOS: application termination on detached window close was fixed
  • Localizations:
    • Simplified Chinese localization was significantly updated (thanks to @bianyun1981)
    • Italian localization was updated (thanks to @capitanfuturo)
    • Japanese localization was fixed and updated (thanks to @yoshinorin)
  • Oracle: native quoting parser was fixed
  • PostgreSQL:
    • Error (NullPointerException) in explain execution plan was fixed
    • Role DDL was fixed (connection limit)
  • SAP HANA: hyperlink navigation ws fixed
  • SQL Server: Database metadata read fix (problem with is_external column)
Posted in Releases

DBeaver 21.3.2

Posted on by Serge
  • Data editor:
    • Auto-completion was fixed in filters panel
    • XML auto-format was fixed (elements sort was disabled)
    • Filter by column with alias was fixed
    • Numeric type transformer was fixed
    • Extra tab close action were added (close to the left/right)
    • Arrays presentation in record view was fixed
  • Files drag-n-drop (between DBeaver and OS file explorer) support was added in the project explorer
  • SQL editor: “hippie” auto-completion support was added (beta)
  • SSHJ implementation now included in DBeaver Community by default
  • Problem with DBeaver crash was fixed (when workspace path contains spaces)
  • Driver management:
    • New Java11 modules were added to support new JDBC drivers (java.net.http)
    • Drivers copying was fixed (keep advanced driver settings)
    • Maven artifacts edit dialog was fixed
  • Data transfer:
    • CSV parser performance was significantly improved
    • Identifiers case configuration was added in SQL export format
    • Option to append results to an existing file was added
    • Date formatting was fixed for JSON format
    • Variables support in saved tasks was fixed
    • Support of arrays import from CSV was added
    • Problem with export wizard buttons enablement was fixed
  • Session manager: column grouping was added
  • Command line support: default connection now set for opened SQL scripts
  • SalesForce driver was added
  • AWS Athena: driver version was updated, problem with column filters was resolved
  • Babelfish:
    • Synonyms, sequences and triggers were removed from metadata navigator
    • Cross-database access was disabled, only default database is visible
  • Clickhouse: typed arrays support was added
  • Derby: check constraints support for remote server driver was fixed
  • SAP HANA: public schema presentation was changed (thanks to @kai-morich)
  • SQL Server: external tables support was added
Posted in Releases

Log4Shell vulnerability is NOT dangerous for DBeaver users.

Posted on by Serge

Lately, we have received many requests about a dangerous bug in the Log4j library, and we hasten to reassure you:
none of DBeaver products use log4j for any program needs. It is entirely safe to use the latest DBeaver versions.

A few days ago, it became known about a dangerous Log4Shell vulnerability in the Log4j logging tool, which is distributed in the form of a library along with the Apache Logging Project.

The issue with log4j is applicable for server applications that receive HTTP requests, not for desktop applications such as DBeaver.
You can find more information about the vulnerability here.

Please, feel free to contact our support team if you have additional questions at https://github.com/dbeaver/dbeaver/issues .

Posted in News

DBeaver 21.3.1

Posted on by Serge
  • SQL editor:
    • Auto-completion for tables without alias was fixed
    • Script file name template support was added
  • Data editor: column filters edit dialog UI was improved
  • Resource manager: cross-project connection drag-n-drop was fixed
  • Task manager: task statistics read was fixed
  • SQL query generator: string values quotation was fixed
  • Driver manager: Maven artifacts import/edit UI was improved
  • Connection lock password support was fixed
  • Navigator:
    • Object filters now support backslash escape
    • Multiple minor UI bugs were fixed
  • DB2: table organization property was added
  • PostgreSQL, Greenplum, Redshift:
    • Permission editor UI was fixed (redundant GRANT/REVOKE commands merge)
    • Composite data types support was fixed
    • Execution plan rendering was fixed (“Parallel” scan)
    • Partition tables statistics read was fixed
  • SQL Server: column data type modifiers generator was fixed
  • SQLite: table foreign keys editor was added
Posted in Releases

DBeaver 21.3.0

Posted on by Serge
  • Data viewer:
    • Filters configuration dialog UI was fixed (MacOS)
    • Found occurrences highlighting was fixed (find/replace)
    • Problem with long columns resize was fixed
    • Problem with overlapping column icons was fixed
  • Diagram viewer: connections auto-layout was fixed
  • Problem with SQL script preview dialog was fixed on MacOS
  • Error “PKIX path building failed” was fixed on Windows (OS certificate storage is now the default)
  • Dark theme: bug with mismatching colors was fixed on MacOS
  • Problem with missing file extensions was fixed (Windows)
  • Metadata editor: editor flickering after mode change was fixed
  • Full-text search now keeps original table filters
  • Currupted projects auto-recovery feature was added
  • Legacy error/warning icons were replaced with new ones
  • Version auto-upgrade:
    • Incorrect package type detection was fixed
    • Incorrect architecture (M1/ARM/x86) detection was fixed
  • Driver editor:
    • URL template edit support was added for all drivers
    • Maven artifacts import/edit UI was improved
  • SSH tunnel test: system variables support was added
  • New database drivers:
    • Babelfish driver was added (thanks to @okeuday)
    • OceanBase driver was added (thanks to @LuckyLeoZZ)
  • Greenplum: permission editor was fixed for older GP versions
  • MySQL/MariaDB/PostgreSQL: backup/restore tasks create wizard was fixed (NPE)
  • ODBC: app crash on editor open was fixed
  • PostgreSQL:
    • Database structure was redesigned (all cluster-level entities moved to the top level)
    • Multirange data types support was added
    • Exclusive schema filters support was fixed
    • Support of JSON columns in unique keys was added
  • SQLite: table indexes create/delete support was added
  • SQL Server: auto-completion and hyperlinks were fixed in stored procedures
Posted in Releases

DBeaver 21.2.5

Posted on by Serge
  • Data editor:
    • Spatial viewer now saves proper SRID for tables and columns
    • Find/replace for BLOB/CLOB columns was fixed
  • Metadata editor:
    • Navigator refresh was fixed
    • Schema-level index create was fixed
  • ERD editor: columns search was implemented
  • SQL editor:
    • Files copy into new project was fixed
  • Backup/restore wizard UI was fixed (MySQL and PostgreSQL)
  • Task wizard buttons enable/disable was fixed
  • SQLite: driver updated to version 3.36
  • Greenplum/Redshift: session and lock managers were added
  • MariaDB/MySQL: tables metadata load performance was improved
  • Oracle:
    • Full-text search for functions and procedures was implemented
    • Option “show only current schema objects” was implemented
  • PostgreSQL:
    • Foreign key settings edit was implemented
    • Array value parser was fixed
    • Roles names quote was fixed in grant/revoke commands
  • Snowflake: driver version was updated (fixes problems with MFA)
Posted in Releases

DBeaver 21.2.4

Posted on by Serge
  • Task management UI was redesigned for data transfer, admin tasks and SQL tasks
  • Data transfer:
    • Bulk load (COPY) support was added for PostgreSQL
    • Cross-database data type mapping was improved for PostgreSQL, Oracle and Sybase
    • Additional variables were added for file name patterns (${year}, ${month}, ${day}, etc)
    • Several fixes in data transfer wizard
  • Data editor:
    • Geometry values copy-paste operation was fixed
    • Gis viewer: object tooltips were fixed
    • Problem with invalid SRID was resolved
    • Copy from row above/below command was added
    • JSON function were added to virtual columns definition
    • Image viewer flickering was fixed
    • Row count calculation was fixed (bug with distinct select)
    • Composite data types support was fixed (arrays of composite type)
  • SQL editor:
    • New script template was added (configurable)
    • Tooltip for execution plan explain tab was fixed
  • Shared jar libraries confioguration was added
  • Navigator:
    • Quick filter value is now saved between application starts
    • Command line handler was fixed (problem with -reuseWorkspace)
    • Boolean editor UI was fixed (trimmed labels)
    • UI freeze during metadata editors re-open was fixed
  • Clickhouse:
    • Table statistics read was fixed (thanks to @den-crane)
    • SQL dialect definition was improved (extra keywords)
  • CockroachDB: query results limit was added
  • CSV, Athena: database metadata is now read-only
  • Redshift: geometry edit support was added
  • Snowflake: driver version is now hardcoded (to avoid problems with MFA authentication)
  • SQL Server: auto-completion for synonyms was added
  • Sybase: database statistics info was added
Posted in Releases

DBeaver 21.2.3

Posted on by Serge
  • SQL editor:
    • Schema detection for auto-complete was fixed
    • Intelli-sense proposals detection was fixed for queries with variables
  • Data editor:
    • Dark theme support was improved
    • Booleans editor rendering was fixed
  • Data transfer:
    • Data export now respects columns order and visibility
    • Exported files are highlighted in OS file explorer
    • XML export/import support between Oracle and PostgreSQL was added
    • CSV parser was fixed (unexpected input file read termination)
    • CSV export format: column header format configuration was added
    • CSV export: quotation of NULL values was fixed
    • Import from XML: column mapping was improved
    • Additional variables were introduced for target file name pattern
    • Redundant table name quotation was fixed
    • Output files split option was fixed (problem with extra empty file)
    • XLSX format: column values are now trimmed to 32kb
  • Navigator:
    • Create new connection from JDBC URL command was added
    • Database metadata refresh was fixed
  • ERD:
    • Palette icons were updated
    • Dark theme support was improved
  • CSV driver: aggregated functions support was fixed
  • Exasol: geometry data types support was fixed
  • ODBC driver: app crash during database connection was fixed for several drivers
  • PostgreSQL:
    • Composite data types support was improved
    • Database backup wizard UI was fixed
  • SQL Server: square brackets escape was fixed
  • Command-line support: running app instance detection was fixed
  • Booleans view was improved (font weight is now configurable)
  • SSL encryption algorithms were replaced by BouncyCastle
  • TLS 1.0/1.1 support was fixed
  • XML-parser related security issues were fixed
  • Base platform was changed to Eclipse 2021-09
Posted in Releases

DBeaver 21.2.2

Posted on by Serge
  • DBeaver for MacOS X for M1/Silicon/ARM was released
  • SQL editor:
    • Client-side command @include was fixed
    • Bug with hanging SQL parser on long queries was fixed
    • Auto-completion was fixed for a number of cases
    • Schema selector in SQL consoles was fixed
    • Statement text extraction was fixed in “block selection” mode
  • Data editor:
    • Expression parser was fixed in grouping panel
  • Navigator: database metadata refresh speed was significantly increased
  • Generic drivers: problem with wrong table schema recognition was fixed
  • Exasol: extra keywords were added to SQL dialect
  • HANA:
    • Begin/end blocks parser was fixed
    • Alter table syntax was fixed
  • Hive: backslash escape support was added
  • Netezza:
    • Table editor for non-default database was fixed (problem with wrong schema recognition was resolved)
    • Import/export to/from non-default database support was added
  • PostgreSQL:
    • Composite value editor was improved (for composite data types)
    • Version 13 support was improved (rare problem with data types metadata read was fixed)
  • Redshift:
    • Driver 2.x support was fixed (proper data types handle was added)
    • Table truncate command was fixed
  • Sybase: “Encrypt password” option was added to the connection page
  • Teradata: default schema detection was fixed
  • Windows installer: default install location was changed to current user
  • UI rendering for HighDPI monitors was fixed
  • Properties editor UI was fixed (possibility to delete custom property)
  • Tables UI was fixed for multiline cells (Linux)
  • Bundled Java was upgraded to OpenJDK 11.0.12
Posted in Releases

DBeaver 21.2.1

Posted on by Serge
  • Data viewer:
    • Boolean value render configuration was redesigned
    • Special format for “time/timestamp with timezone” types was added
    • Advanced paste: configuration dialog was added
    • Radix transformer was fixed
    • Numeric transformer was added
    • Geometry data type editor was fixed (Exasol, Oracle)
    • Value panel now saves last used content viewer settings
  • Data transfer:
    • Output settings configurator was fixed
    • External process execute was fixed (backslash escape)
    • Import from XLSX: column mapping was fixed
    • Database dump configuration page was fixed (Mysql, PostgreSQL)
    • Data load performance was improved (thanks to @deepaksenthilkumar)
  • SSH tunnel: jump server configurator was fixed (port number)
  • Windows shortcuts (lnk) resolution was added
  • ERD: columns sort support was added
  • Confirmation dialog UI was redesigned
  • Metadata search:
    • Search in object comments configurator was fixed
    • Search page was fixed for cross-database search PostgreSQL
  • Database session manager refresh was fixed
  • DB2: columns, procedures and functions search support was added
  • Firebird: calculated fields support was added
  • Greenplum: table DDL was fixed (unique keys)
  • H2: procedure aliases support was added
  • PostgreSQL:
    • Composite data type support was fixed
    • UDF parameters support was fixed
    • Foreign table comments support was added
  • Redshift:
    • External table columns metadata read was fixed
    • Char data type support was fixed
    • Timeout error recovery was added
    • Driver version was upgraded to 2.0
    • Geometry data types support was improved
  • SQL Server: cross database metadata search support was added
  • Vertica: metadata search and full-text search support was added
  • Linux installers (deb, rpm) were improved. App shortcut links were fixed
  • Eclipse 2021-06 is new base platform
  • DBeaver now requires Java 11
  • MacOS X M1 installer was added (beta)
Posted in Releases