- 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
DBeaver 21.1.4
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
DBeaver 21.0.2
- SQL Editor:
- Configuration of open editor action was added
- Smart auto-completion of column values was improved
- Problem with ambiguous column name resolution was fixed
- Hyperlinks detection was fixed
- Problems with SQL templates view freeze was fixed
- SQL formatter of case and conditional operators was improved
- Syntax highlighting for single and double quotes was fixed
- SQL folding state is now saved for each script
- Trim spaces command was added
- Problem with double save/commit confirmations was fixed
- Database navigator:
- Quick schema filter was fixed
- Metadata changes save: single transaction processing was improved
- Delete object(s) dialog UI was improved
- Data transfer:
- Export to flat files now supports columns configuration
- BOM support was added to CSV import
- Data viewer:
- BLOB viewer now respects content type of cell value
- Grouping panel: queries with trailing comment now handled properly
- Custom resultset ordering support was fixed
- PostgreSQL:
- Serial data types selector was fixed
- Column default value editor was fixed
- Numeric arrays rendering was fixed (number formatting removed)
- SAP HANA (thanks to @wernerdaehn):
- Smart completion was improved
- Public synonyms read was added
- Metadata object search was redesigned
- SQL Server:
- Default delimiter was changed to ; instead of GO
- Synonyms support was improved
- Check constraints added to table DDL
- Unicode string literals generation was fixed
- Informix: SQL error position detector was added
- Snowflake: active catalog/schema selector was fixed
- DB2 LUW: extra embedded routines support added
- Google Spanner driver configuration was updated
- MariaDB: TIME data type support was fixed
- Vertica: column comments read and update support was added
- Redshift: table permissions read in table DDL was fixed
- APM Jenifer driver configuration was added
- Automatic version upgrade: app restart procedure was improved
- Application icons were updated
Posted in Releases
DBeaver 21.0.1
- Connection management:
- Automatic ending of idle transactions was added
- Network profiles configuration page was fixed
- Filters in the connection selector dialog were fixed
- Data transfer:
- Possibility to disable foreign keys was added (PostgreSQL, Oracle)
- Numeric data types mappings were improved
- “Skip all errors” button added in the error dialog
- Metadata editor:
- Column delete now checks for dependent objects
- Constraint/index create command now available in the columns edit tab
- Problem with deleted object dup was fixed
- SQL editor:
- Script selector popup panel UIX was improved
- Hex constants and scientific numbers formatting was fixed
- Columns alias generation was improved
- Multi-line comments support was fixed
- Data editor:
- Column filter UI was improved (value count column)
- Extra configuration was added to SQL script generator
- Better support of IE browser in the spatial viewer (GIS)
- Virtual columns support (rows add/delete) was fixed
- Cells selection was fixed (MacOS)
- Automatic app version upgrade was implemented
- Notification popup rendering in dark theme was fixed
- Perspective customization UI was fixed
- ERD:
- Export as image: image cropping problem was fixed
- Export in SVG format was improved
- Diagram save now forces UTF encoding
- Tables coloring was fixed
- Show/hide system object option is now respected
- Print command enablement was fixed
- PostgreSQL:
- PgBouncer support was fixed (problem with prepared statements)
- Data types read queries were fixed for older (8.4 and earlier) versions
- Role permissions editor was fixed
- Infinity timestamp values support was added
- Auto-generated columns support was added
- Role name DDL was fixed
- Teradata:
- Triggers management was added
- Views metadata read was fixed
- Informix: foreign key DDL was fixed
- Clickhouse:
- Table data edit support was added
- Tables and indexed create/drop DDL was fixed
- Sybase IQ support (server version detection) was fixed
- Vertica: view create/edit was fixed
- Firebird:
- Procedure parameters’ default value read was fixed
- View metadata read was improved
- Data Virtuality driver was added (thanks to @sebcom-gmbh)
- Preferences localization was updated
Posted in Releases