- 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
DBeaver 21.2.0
Posted in Releases
DBeaver 21.1.5
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Permission editor was added
- Problem with case-sensitive object names was fixed
- Cross-schema foreign keys support was fixed
- Detailed triggers metadata read was added
Posted in Releases
DBeaver 21.1
- 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
- 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
- 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
- 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