DBeaver 21.2.0

Posted on by Serge
  • Data transfer:
    • Value binding mode switcher was added (affects performance)
    • Automatic columns mapping was fixed
    • Import from files/relational tables into document oriented databases was fixed
    • Column length detection was improved
  • SSH tunnel: jump server support was added
  • Tasks management view: task folders were added
  • Navigator: show tables from different schemas in a single list (optional)
  • Connection driver settings: problem with non-editable properties was fixed
  • Data editor:
    • Toolbar commands enablement handler was fixed
    • Detached text/binary editor was fixed
    • Row coloring: LIKE and REGEX filter value editor was fixed
  • SQL editor:
    • Extraction of queries from source code on paste: problem with line feeds was fixed
    • Multibyte unicode numbers handler was improved (app hang fixed)
    • Main windows title now shows proper information about the current editor
  • Greenplum: stored procedures auto-completion and navigation was fixed
  • PostgreSQL:
    • Multi-column foreign keys navigation was fixed
    • Auto-completion for quoted identifiers was improved
    • Active schema detection was fixed
    • Floating point numbers formatting was fixed
  • Redshift:
    • Data transfer performance was significantly increased (up to x10000)
    • Tables and procedures DDL was improved (security definer was added)
    • Stored procedures search and auto-completion was fixed
    • Timestamp value editor was fixed (in native date formatting mode)
  • Snowflake: driver configuration was fixed (JNA dependencies)
  • Many minor UI and database-specific bugs were fixed
Posted in Releases

DBeaver 21.1.5

Posted on by Serge
  • ERD editor:
    • Properties panel was added for diagram elements
    • Diagram drag tool was added
    • Entity search UI was improved
    • Diagram refresh now asks confirmation
    • Table column navigation was fixed
    • GraphML export was improved (notes, styles)
    • Arrange diagram now respect grid alignment
    • Export ERD in XML (.erd) format was added
    • Cross-project entity drag-n-drop was restricted
  • Data editor:
    • Row insert with default values was improved
    • Data filter popup now visualizes loading process
    • Pin column now works for multiple selected columns
    • Filters dialog now supports column pin/unpin
    • Auto-complete in grouping panel was fixed
    • Plaintext record mode switch was fixed
    • Excel import was fixed (NULL cells support was added)
  • SQL editor: action buttons tooltips were fixed (keyboard shortcuts)
  • SQL Server: user management was added
  • Oracle: View triggers read was fixed
  • PostgreSQL:
    • Additional PostGIS data type support was added
    • Connection user role handle was fixed
  • Procedure body read now re-established connection on demand
  • Shell commands now support quoted parameters (Linux, MacOS)
  • Debian/RPM package installers now use different directories for community and commercial versions
  • Simple schema compare wizard UI was fixed
  • SQL queries which contains passwords were removed from logs
  • Driver editor dialog enhancements
  • Minor UI bugfixes
Posted in Releases

DBeaver 21.1.4

Posted on by Serge
  • Data transfer:
    • Multi-row insert support was added
    • Data transfer performance significantly improved
    • Unnecessary commit/rollback in source connection were removed
    • Table/column name case conversion was fixed
    • Ambiguous column name mapping was fixed
  • Data viewer:
    • Data filter for enum data types was fixed
    • Data edit support for queries with joins
    • Row insert with default values support was added
    • Timestamp value render: timezone configuration was added
    • Value transformers: save last transformer configuration
    • Cell color highlight add/reset was fixed
    • Data refresh was fixed in multi-row record mode
  • MySQL:
    • TLS 1.0 and 1.1 support added
    • User password change was fixed
  • PostgreSQL:
    • Bit string editor was fixed
    • PG 13 backup/restore support was added
    • Column rename DDL was fixed
    • INSERT queries for OID data types were fixed
    • Composite data type edit was fixed
  • SQL Server: active schema selector was fixed
  • Several minor UI bugs were fixed
Posted in Releases

DBeaver 21.1.3

Posted on by Serge
  • SQL editor:
    • Output/Execution Log panels layout was changed
    • Variables/parameters management panel was added
    • SQL template variables completion was fixed
    • Command for assigning query results to variable was added
  • Data transfer:
    • Custom transformations were added for table column mapping
    • Referential integrity disablement was added for MySQL, SQL Server and Exasol
    • Column mappings page supports reordering now
    • Data export task editor was fixed (task re-configuration support)
    • Query based data export task now supports query editing
    • Export in HTML format was fixed (extra line breaks)
    • Columns auto-assign button behavior was fixed
    • Execute process after data transfer supports multiple tables export now
    • Mixed case columns auto-mapping was fixed
    • Several problems with NullPointerException during editor opening were fixed
  • Navigator:
    • Open file: last opened folder is saved between app launches
    • Object filter: special characters escaping was added
  • MySQL:
    • Data import performance was significantly improved
  • Oracle:
    • View indexes reading was fixed
    • TNS aliases resolution was improved
    • Data export in SQL format was fixed
  • PostgreSQL:
    • Database backup/restore in custom format was fixed
    • Database backup validates output file existence
  • Firebird: query execution plan explain was fixed
  • Several minor UI bugs were fixed
Posted in Releases

DBeaver 21.1.2

Posted on by Serge
  • Data viewer:
    • Record mode now supports multiple records view
    • Double-click behavior in filters popup was fixed
    • Spatial viewer now allows to copy point coordinates
    • Source tables resolution was fixed for CTE queries and sub-selects
  • Navigator:
    • Quick filter was fixed (show connected only)
    • “Set connection from navigator” action behavior was fixed
  • SQL editor:
    • Auto-completion for identifiers with special characters was fixed
    • SQL console now opens for selected schema
    • Table columns are shown in original order for auto-completion
    • Formatting of queries with embedded comments was fixed
    • Local variables coloring was added (Sybase, SQL Server, MySQL)
  • Metadata editor:
    • Metadata search now supports search in procedures/views definition
    • Object info refresh was fixed
    • Table triggers loading performance was significantly improved for most databases
  • Clickhouse:
    • Table DDL was fixed
    • Nested comments support was added
    • Data edit (update/delete) queries generator was fixed
  • DB2 iSeries: schemas with long names loading was fixed
  • Hive: constraints definition was fixed
  • MySQL:
    • Execution plan explain for CTE queries was fixed
    • Use password escape was fixed
  • PrestoDB/Trino: data and metadata editors were improved
  • PostgreSQL:
    • Data type fully-qualified name now used instead of scale/precision
    • Custom data types (including geometry) resolution was improved
  • SAP HANA: stored procedures results loader was improved (multiple cursors + atomic values)
  • Snowflake: $$ parser was improved
  • SQL Server:
    • Temporary table support was improved (metadata load, SQL auto-suggest)
    • datetime data type DDL was fixed
    • Active schema selector was fixed
    • BEGIN/END blocks support was added
  • Vertica:
    • Flex tables metadata was fixed
    • Function body parser was fixed
Posted in Releases

DBeaver 21.1.1

Posted on by Serge
  • Navigator:
    • Quick search now supports multiple object names
    • Entity editor preferences for active tab configuration were improved
    • Object rename dialog was fixed
    • Metadata refresh UI was fixed
  • Data editor:
    • Row coloring now supports LIKE and other operators
    • Read-only columns mark was redesigned
    • Confirmation dialog was added for column filters
    • References panel UI was fixed (rows highlighting)
    • Spatial data viewer now remembers selected SRID for particular columns
  • Data export: special characters escape was fixed in HTML and JSON formats
  • SQL editor:
    • Problem with active schema reset after connection invalidate was fixed
    • Problem with focus lost on query execution was fixed
    • Auto-completion for quoted identifiers was fixed
    • Embedded SQL editors performance was greatly improved
    • Problem with @set command was fixed
    • Problem with Find/Replace window and NullPointerException was fixed
    • Several problems with hanging UI after complicated SQL execute were fixed
  • Greenplum: materialized views DDL was fixed
  • MySQL: foreign key edit support was added
  • Oracle:
    • Table DDL was fixed (missing semicolons)
    • Timestamp columns editor was fixed
    • Function-based indexes column read was fixed (duplicated rows removed)
    • Package loading performance was greatly improved
  • PostgreSQL:
    • Column data type editor was redesigned
    • Infinity timestamps handler was fixed
    • Array and interval data types editor was fixed
    • Foreign tables DDL was fixed (missing OPTIONS)
    • Cross-schema references rendering was fixed
  • Redshift:
    • Permission editor was added
    • Problem with case-sensitive object names was fixed
  • SQL Server:
    • Cross-schema foreign keys support was fixed
    • Detailed triggers metadata read was added
  • Teradata: triggers and procedures DDL was fixed (extra linefeeds were removed)
  • Taiwan localization was added (thanks to @ralic)
  • Test connection dialog now shows connection detailed information
  • Last workspace location is now restored after DBeaver version upgrade
  • Redundant P2 plugins were removed from the standalone version
  • TLS 1.0 and TLS 1.1 support configuration was fixed
    • Posted in Releases

    DBeaver 21.1

    Posted on by Serge
    • Connection recovery was improved. SSH tunnel infinite reopening cycle was fixed
    • Data transfer:
      • Insert/replace method configuration was fixed
      • Cross-database column data type mapping was improved
    • Project settings: corrupted folders configuration fix was added
    • Legacy status icons were updated
    • Application launch time was reduced
    • SQL Editor:
      • Problem with results tab collapse was fixed
      • Dummy NullPointerException and StackOverflowError errors were fixed
    • Data editor: LOB viewer shows error dialog on data load errors now
    • CLI: reuseWorkspace parameter handler was fixed
    • SQL Server:
      • Extended properties editor was added
      • New row insert for tables with calculated columns was fixed
    • Oracle: synonyms search is now configurable
    • PostgreSQL:
      • User password change feature was added
      • Domain arrays support was fixed
      • Role DDL now contains permissions information
      • Sequences DDL was fixed
      • VARBIT data type support was fixed
      • Default database switch was fixed
    • MySQL: user rename feature was added
    • Exasol: schema refresh was fixed
    • Informix:
      • Table statistics feature was added
      • Function parameters read was fixed
    • Snowflake: metadata read was fixed for case-sensitive schema names
    • BigQuery: driver version was upgraded
    • Bundled Java updated to version 11.0.11
    • Many minor UI bugs were fixed
    Posted in Releases

    DBeaver 21.0.5

    Posted on by Serge
    • Navigator:
      • Boolean properties editor behavior was redesigned
      • Broken shortcuts (F2, F4, etc) in object editor were fixed
      • Redundant help icons removed from standard dialogs
      • Language change validation and documentation was added
      • Quick filter now supports triggers
    • SQL Editor:
      • Auto-completion was fixed for table aliases, joins and asterisks
      • Smart commit now ignores EXPLAIN statements
      • Big updated row count (>2gb) support was added
      • Output log enable/disable button was added
    • Data editor:
      • Selected rows highlight was fixed
      • Bug with overlapping timestamp and FK values was fixed
      • Find/replace dialog now respects number formatting
    • ERD viewer: property view support was fixed, entity/attributes context menu was fixed
    • PostgreSQL:
      • Constraints and indexes support was added
      • Problem with constantly growing search_path was fixed
      • Fully-qualified table names in foreign keys DDL was fixed
      • PGPASS authentication now can be used with empty user name
      • NaN and Infinity numbers formatting was fixed
      • Data transfer: ON DUPLICATE query generation was fixed
      • Database size statistics was added (configurable, off by default)
      • CREATE DOMAIN DDL was fixed
    • DB2: BEGIN/END blocks support was added
    • Greenplum: DDL for replicated tables was fixed
    • Oracle:
      • Procedure body formattign was fixed (for encoded procedures)
      • Procedures/triggers/packages DDL statements processing was fixed
    • Redshift: view columns metadata read was fixed, extra data type aliases were added
    • Vertica:
      • Table columns read was fixed for older Vertica versions
      • Sequences support was added
    • BigQuery driver version was upgraded
    • Eclipse plugin: bug with redundant .dbeaver folders was fixed
    • System notifications support was added on Linux
    • Jar code sign certificate was updated
    • Big number of minor bigfixes
    Posted in Releases

    DBeaver 21.0.4

    Posted on by Serge
    • Navigator:
      • Database statistics in simple mode was fixed
      • Legacy search icons were updated
      • Legacy edit toolbar and main toolbar items was removed
      • Columns reorder now supports multiple columns
      • Object lookup function now supports search in comments
      • DBeaver main menus are visible in DBeaver perspective only
    • SQL editor:
      • Collapsed results panel expand was fixed
    • Data editor:
      • Find/replace dialog was improved
      • Virtual unique key create dialog was redesigned
      • References panel was fixed for custom SQL queries
    • SSH:
      • SSH Agent support was fixed
      • SSHJ extension install was fixed
    • MySQL:
      • Column editor was fixed (DEFAULT_GENERATED clause removed)
      • Index editor was added
    • PostgreSQL:
      • Schema data types read was fixed
      • Sequence editor was implemented
      • Data type rename support was added
    • SQL Server:
      • Calculated columns support was added
      • Extended properties were added to table DDL
      • Default precision and scale for numeric data types was fixed
      • View triggers support was added
    • Oracle:
      • Functions folder was added (in addition to Procedures)
      • Jobs support was added (read-only)
      • Data type compile action was fixed
      • Synonyms read was fixed for partitioned tables
      • Table triggers loading performance was improved
      • Trigger disable/enable tool was added
      • Procedure/function dependencies were added
      • Comments for views and view columns were added
      • Data type DDL was fixed for predefined types
    • Redshift: problem with read-only resultset was fixed
    • SAP HANA:
      • Table columns was fixed for table names with special symbols
      • Hex literal formatting was fixed
    • Sybase IQ: SQL dialect support was improved
    • Snowflake: drop procedure function was fixed
    • DB2: stored procedures call generator was improved
    • Vertica:
      • Table column create/edit was fixed
      • View constraints read was implemented
      • Unique key creation was fixed
    • DuckDB driver configuration was added
    • RMI server waas fixed (no more public port listeners)
    Posted in Releases

    DBeaver 21.0.3

    Posted on by Serge
    • Dark theme support was improved (Windows 10 and GTk)
    • Data viewer:
      • Copy As: format configuration editor was added
      • Extra configuration for filter dialog (performance)
      • Sort by column as fixed (for small fetch sizes)
      • Case-insensitive filters support was added
      • Plaintext view now support top/bottom dividers
      • Data editor was fixed (when column name conflicts with alias name)
      • Duplicate row(s) command was fixed for multiple selected rows
      • Edit sub-menu was returned to the context menu
      • Columns auto-size configuration was added
      • Dictionary viewer was fixed (for read-only connections)
      • Current/selected row highlighting support was added (configurable)
    • Metadata search now supports search in comments
    • GIS/Spatial:
      • Map position preserve after tiles change
      • Support of geometries with Z and M coordinates was added
      • Postgis: DDL for 3D geometry columns was fixed
      • Presto + MySQL geometry type support was added
      • BigQuery now supports spatial data viewer
      • Binary geo json support was improved
      • Geometry export was fixed (SRID parameter)
      • Tiles definition editor was fixed (multi-line definitions + formatting)
    • SQL editor:
      • Auto-completion for objects names with spaces inside was fixed
      • Database objects hyperlinks rendering was fixed
    • SQL Server: MFA (multi-factor authentication) support was added
    • PostgreSQL: array data types read was fixed
    • Oracle: indexes were added to table DDL
    • Vertica: LIMIT clause support was improved
    • Athena: extra AWS regions added to connection dialog
    • Sybase IQ: server version detection was improved
    • SAP ASE: user function loading was fixed
    • Informix: cross-database metadata read was fixed
    • We migrated to Eclipse 2021-03 platform
    Posted in Releases