- 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
DBeaver 21.2.3
Posted in Releases
DBeaver 21.2.2
- 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
- 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
DBeaver 21.2.0
- 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
- 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