DBeaver

Camel1965 · 3 Sierpień 2020

DBeaver 7.1.4

What's new in DBeaver 7.1.4
August 3, 2020

Database navigator:

Connection status icons and tooltips were redesigned

Icon decorations added for Git-integrated projects

Navigator view options were added in the context menu

Simple view support was improved (redundant objects removed from the navigator tree)

Icons for “Create new objects” action were fixed

Data editor:

Unique key detection was fixed (for data editor)

Advanced paste of multiple rows was fixed (redundant rows create was removed)

Column filter dialog move/resize was fixed on Linux

Grid data rendering performance was improved

Auto-complete of column names was fixed in the filter panel

SQL editor:

Search/replace/undio/redo shortcuts were fixed in embedded editors (view/procedure sources)

Parameter binding was fixed for multiple occurrences of the same parameter

Smart commit mode behavior was fixed for PostgreSQL (post-error transaction recovery)

Delete indent with single backspace was enabled by default

Server log panel now works for data modification triggers

Extract query from source code now shows notification popup

Multiple queries execution is now allowed (in separate tabs)

ERD editor: extra coloring was added for multi-schema diagrams

Oracle:

Metadata read performance was increased (Tables, materialized views)

Columns and constraints were added in materialized view editor

Numeric data type precision read was fixed

Support of implicit cursors in query results was added

View DDL reading was improved (view comments are included in DDL)

PostgreSQL:

Default schema detection and search_path overwrite was fixed

Multi-dimension arrays support was added

Table DDL for inherited tables was fixed

MySQL:

Active database change in read-only connections was fixed

CHECK constraints support was added

Table copy operation was fixed

User password management was improved (to avoid FLUSH PRIVILEGES)

Sybase:

Support of text editing in views was added

Schema indexes reading was fixed

New table columns create was fixed

CockroachDB: direct table data edit support was fixed

HSQLDB: UUID data type support was added

Query cancelling was improved (force cancel for hanging connections)

Transaction isolation level settings save was fixed

Error and debug logging was fixed

A large number of minor UI improvements and bugfixes

Zaloguj lub Zarejestruj się aby zobaczyć!

Ircus · 16 Sierpień 2020

DBeaver 7.1.5

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 31 Sierpień 2020

DBeaver 7.2.0

What's new in DBeaver 7.2.0
August 30, 2020

Major changes since 7.1:

Simplified database structure view was added

Database maintenance tools can be saved as tasks now

Table and schema size statistics were added in the database navigator

Import from multiple CSV files was added. Files can be imported into new or existing tables

Many problems with UI freeze on disconnect or query cancel were fixed

Database navigator rendering was redesigned

A number of problems with keyboard shortcuts were fixed

Git integration was improved: now we show file status in the Project Explorer view

New database drivers were added: YugabyteDB and SQreamDB

Changes since 7.1.5:

Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server)

Metadata editor: edit property form rendering was improved (non-applicable fields are hidden)

Performance for table statistics reading was improved

Data viewer:

Column ordering was fixed (for custom SQL queries)

UUID transform: version 2 support was added

Default database name and default user name were added for many database drivers

Data export: custom data type formatting support was fixed

PostgreSQL:

Cursor fetch was fixed

Native client was upgraded to version 12

Table OID support was fixed (PG 12)

PgPass parser was improved (support for escaped characters was added)

Oracle:

Materialized view comment editor was fixed

View definition reading was fixed (for non-DBA users)

Table reading now uses DBA views (optional)

Profile resources metadata reading was fixed

MariaDB/MySQL: table column resolving was fixed

CockroachDB: connectivity problem was fixed

Greenplum:

Metadata search was fixed (for procedures)

Table metadata reading was fixed

Dark theme support was improved (tab folders, toolbars)

A large number of minor UI bugfixes

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 21 Wrzesień 2020

DBeaver 7.2.1

What's new in DBeaver 7.2.1
September 20, 2020

Preference pages structure was reorganized (in the standalone and plugin versions)

Database navigator:

Filters now support masks escape (_ and % characters)

Connection state icons were replaced and adapted to dark themes

SQL Editor: editor tab title now can include active database/schema name

MySQL: driver “MySQL 8” is now the default driver. “MySQL 5” driver can be used for older server versions.

Oracle: tables/views load performance was improved on some systems

PostgreSQL:

Latest PostGIS driver mapping was added

Geometry data types export was improved (proper SQL format + SRID)

Hidden databases can be loaded in the database navigater

CockroarchDB: role manager was fixed

DB2: runstats utility support was fixed (wrong syntax)

SQL Server: extra T-SQL dialect keywords were added

CUBRID driver configuration was fixed

Several UI freeze issues were fixed (deadlocks)

Import from CSV/XLSX:

Wrong rows can be skipped (with disabled “Batch import” option)

Import parameters documentation was updated

Several minor bugs were fixed (NPE and UI glitches)

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 5 Październik 2020

DBeaver 7.2.2

October 4, 2020

Database navigator:

View only connected data sources filter was added

Quick search in connections/schemas options were added

Multiple objects delete confirmation dialog was redesigned

Tooltips visibility configuration was added in preferences

Windows installer: shortcuts for “All Users” were fixed

SSH tunnels:

Support for OpenSSH key format was added

Problem with dobule password prompt was fixed

Data viewer:

Grouping panel now supports column reordering

Column modifier icons (key, read-only) were updated

JSON/XML viewer performance was significantly improved

SQL editor: toolbar buttons enablement was fixed

Data transfer:

Native client selector was fixed

Extra file name pattern variables were added

Native date/timestamp format support was added to the SQL INSERTS export

Extra formatting options were added to the SQL INSERTS format

MySQL: user credentials of mysqldump overwrite local configuration now

SQL Server:

SSL support was added

Database create/drop/rename features were added

PostgreSQL:

Interval data type DDL was improved

Table storage parameters were added to DDL

“Connect as role” option was added in the connection settings

Materialized view comment edit was fixed

Trigger comment editor was added

Oracle: extra NLS parameters were added on the connection settings page

Snowflake: active schema set command was fixed

Derby: unique indexes metadata read was implemented

SQLite: column autoincrement option support was added

Firebird: data types information read was fixed

Several other minor UI bugs were fixed

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 19 Październik 2020

DBeaver 7.2.3

October 18, 2020

Data transfer:

Data preview was fixed for custom SQL queries

Binary format mapping was fixed (BLOB->binary)

Target table name mapping was improved

Context data context menu item visibility was fixed

SQL format: extra options were added (including INSERT OR REPLACE support)

HTML format: additional export options were added

DbUnit format support was improved

SQL editor:

“Auto-save on edit” option was added

Procedures auto-completion was improved (use signature or parameter names depending on context)

Query cancel on editor close was fixed

Disable auto-formatting inside comments

PostgreSQL:

Serial data types support was improved

Trigger DDL was fixed

$$ rule parser was fixed

Informix:

Driver was updated to the latest version

Schemas/tables metadata extraction was fixed

Error in database switch in transactional mode was fixed

MySQL:

Zerofill flag support was added

NULL values of “text” type rendering was fixed

Oracle:

Expired password change feature was fixed

Connectivity problem (“ONS configuration failed”) was fixed

Data viewer: minimum fetch size now limited by 100 rows

SSH configuration: bug with variables in connection parameters was fixed

Column reordering UI was fixed

SQLite: column drop feature was added

SQL Server: data read from clustered tables was fixed

Number of minor bugs were fixed

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 2 Listopad 2020

DBeaver 7.2.4

What's new in DBeaver 7.2.4
November 2, 2020

Data transfer:

REPLACE/UPSERT support was added in SQL export format

Target format selector was fixed (Linux)

Bug in dump/restore credentials save was fixed

Data viewer:

Contrast color now used as foreground color

Bug with results fetch size disable was fixed

Preference pages structure was re-organized (get rid of Eclipse legacy)

Database navigator:

SQL editor context menu was enhanced

“Link wit editor” command was fixed for SQL scripts

Problem with empty/redundant tooltips was fixed

SQL editor: active query cancel on editor close

ER diagrams: table comments loader was fixed

Sample database now can be created from the main menu

Transaction deadlocks viewer was fixed

PostgreSQL:

Data type handler detection was fixed (uuid, name and other types)

Array editor was fixed (proper array item type discover).

Oracle:

Oracle 8 support was fixed (metadata read queries)

Ref cursors support was added

Multi-row INSERT support was added (for export in SQL format)

View and materialized view DDL was fixed (comments)

MySQL:

Dump/restore credentials override option was added

“Disable foreign key checks” option was added in database restore wizard

SQL Server: national charsets support was added for table/column comments

Informix: check constraints read was added

Hive: LIMIT clause support was added

Intersystems IRIS driver was added

Number of minor bugs were fixed

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 15 Listopad 2020

DBeaver 7.2.5

DBeaver 7.2.5
November 15th, 2020

SQL Editor:

Folding support was improved and enabled by default

Current/selected word highlighting support was improved

SQL formatting was fixed for DDL queries (like CREATE TABLE)

"Find in Google" command was added

SQL-related preference pages were redesigned

Parser of complex SQL blocks (e.g. PL/SQL) was significantly improved

Problem with missing query results for some DDL queries was fixed

Data editor:

ROWID columns support was fixed

Binary values copy-paste support was added

Column auto-completion in the filter panel was fixed

Data transfer:

Automatic columns mapping added for CSV without header column

Import from CSV/XLS: timezone parameter was added for date/time columns

Export from SQL query with custom variables: UIX was improved

Boolean value editor UI was changed (text instead of icons)

User authentication UI was fixed when "Save password" option is off

SSH: private key format transform was improved on Linux

PostgreSQL:

Arrays edit support was fixed

Inet and other custom data types edit was fixed

"Generate SQL" action for varchar arrays was fixed

Create/alter trigger functions were fixed

Partition create/drop/alter actions were added

Hive:

Indexes metadata read was added

Index create/drop functions were added

Column add/delete support was added

Table rename support was added

Oracle:

Extra metadata read performance options were added

Foreign key metadata read was fixed (ON DELETE rules)

View DDL was fixed (column comments)

Many other minor bugs were fixed

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 30 Listopad 2020

DBeaver 7.3.0

November 30, 2020

ERD: table copy-paste was fixed

Project delete now requires confirmation of project files delete

Command line: connection credentials now can be passed along with connection name/id

SSH: private key format conversion was improved (Linux)

SQL INSERT query generator now skips auto-generated columns

SQLite: table column delete feature was added

Teradata: active schema selector was added

Firebird: problem with missing views was fixed. View source editor was fixed

Exasol: table index create UI was fixed

SQL Server: index create UI was improved (index type selector)

Hive: SQL dialect was improved (extra keywords)

MySQL/MariaDB: privileges editor UI was fixed

HANA: triggers metadata reading was fixed (bug with wrong schema)

Many minor UI bugs were fixed

A lot of improvements for MacOS:

Problem with toggle checkboxes was fixed

Problems with inline value editors were fixed

Problem with connection editor open on single click was fixed

Problem with metadata viewer in BigSur was fixed

SQL editor:

Complex SQL queries parser was improved

Query folding now respects active SQL dialect

Problem with focus loss after query execute was fixed

Data transfer:

Imports from CSV/XLS: date columns support was added

Export in SQL INSERT format: support of various INSERT/REPLACE/UPSERT dialects was added

Problem with active schema switch during task execute was fixed

Export from query: task UI configuration was fixed (active schema select)

PostgreSQL:

Table DDL was fixed (serial columns)

Role members/permissions viewer was fixed

Permission editor now supports sequences and materialized views

Bug with partition list read was fixed

Oracle:

PL/SQL parser was significantly improved

View DDL read was fixed

Session manager now supports Oracle 9 and 8

BigQuery:

Problem with missing resultsets was fixed

Driver version was upgraded

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 21 Grudnia 2020

DBeaver 7.3.1

December 21, 2020

Installers:

Windows installer packager was reworked

MacOS PKG installer was deprecated, DMG installer now includes JDK

Linux installers (DEB and RPM) now include JDK

All zip archives now include JDK

MacOS (BigSur):

Problem with lines disappear in SQL Editor was fixed

Problem with connection driver properties editor were fixed

Problem with data filter history dropdown was fixed

Native client selector was fixed (MySQL, MariaDB, PostgreSQL)

Data transfer:

Data import now supports INSERT OR REPLACE mode (Oracle, MySQL, PostgreSQL, SQLite, Firebird)

Column mapping is now saved between different runs (no need to make the same assignments multiple times)

Data editor:

Resultsets ordering configuration was added (client/server side or smart mode)

Columns pin flag now saved across different data filters

SQL editor:

Tabs management was redesigned and improved (naming, pins, reordering)

SQL folding performance was significantly improved

SQL auto-completion was improved for procedures

Problem with unicode characters in script file names was fixed

Problem with parameters binding dialog was fixed (bad performance during parameter value change)

SQL generation: extra options were added

PostgreSQL:

Permission grant queries were fixed

New schema + new table + new column create UI was fixed

Oracle:

Session manager now supports Oracle 9

Dependencies information was added for tables, views and packages

Redshift: geometry/geography types support was added

SQL Server: user data type list was fixed (redundant types were removed)

Firebird: procedure parameters domain type names were fixed

Popup errors during theme change were fixed

New connection driver selector was improved (performance)

DBeaver was migrated to Eclipse platform 2020-12

DBeaver build system was migrated to Tycho 2.0

Many minor UI bugs were fixed

Note: if you experience any problems starting dbeaver after the version upgrade

please try to reset workspace

Zaloguj lub Zarejestruj się aby zobaczyć!

Ircus · 3 Styczeń 2021

DBeaver 7.3.2

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 18 Styczeń 2021

DBeaver 7.3.3

What's new in DBeaver 7.3.3
January 18, 2021

Oracle: dependencies information was enhanced (+dependents)

SAP HANA: connection editor waa enhanced (port numbers)

Greenplum: partitions and child tables read was fixed

Informix: stored procedures DDL formatting was fixed

Spanish localization was significantly improved (thanks to @ adamantike)

Several minor UI bugs were fixed

SQL Editor:

Server Output and Execution Log panels were redesigned

Server Output auto-show was added (configurable)

SQL formatting was fixed (IN clause)

Data editor:

Export in TXT (plaintext) format was improved (proper formatting added)

Documentation for date/time format patterns was added

Import from file: file selector wizard page was fixed

Connection editor:

Password field is disabled when it is not used

Driver selector page was redesigned

Driver properties editor was fixed (empty property values save)

MySQL:

GIS data types support was fixed

Table columns mapping was improved in data transfer

SQL Server:

Composite indexes metadata read was fixed

Database delete was improved (close other connections before delete)

MERGE queries support was improved (erroneous row count limit was removed)

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 1 Luty 2021

DBeaver 7.3.4

February 1, 2021

Metadata editor: support of pure unicode identifiers was added

Content assistant was fixed for drop-down selectors

Connection configuration import now supports target folders

Trino (ex-PrestoSQL) driver was added (thanks to @mosabua)

MariaDB: default driver version upgraded to 2.7.1

Redshift: driver version was upgraded (bug with “session is read-only”)

Presto/Trino: GIS transformers support was added

Number of errors with wrong focus tracking fixed on MacOS

Clear message for Java version mismatch errors was added

Now DBeaver can be installed without bundled Java (Windows and Linux)

Problem with Eclipse Marketplace extension was fixed

Several minor UI bugs were fixed

SQL editor:

“Open SQL console” action was added to the main toolbar and context menu

Support of very long sql scripts was improved

Parser hanging was fixed (partially) for queries with a lot of parenthesis

Auto-completion performance was improved

Data editor:

Drop-down inline editor was fixed (Linux)

Epoch time transformer now supports timezones

Copy As SQL: now uses correct SQL dialect

GIS (spatial) data viewer:

MapBox tile configuration was fixed

3D geometry objects now can be displayed on map

Geometry transformer for binary format (WKB) was added

SQLite:

Spatial (gis) data viewer was added

Metadata refresh was fixed (wrong foreign key name)

PostgreSQL:

SQL formatting for custom data types was fixed (geometry and others)

Backup/restore now support non-standard authentication (e.g. IAM)

Redundant data types removed from navigator tree (arrays)

Nested multiline comments support was added

Database template list now contains all databases

Firebird:

SQL parser was fixed (code blocks)

Table/view type recognition was improved (for older FB versions)

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 15 Luty 2021

DBeaver Portable 7.3.5

February 15, 2021

Data viewer:

Advanced paste was fixed (multiple row paste)

SQL editor:

SQL script toolbar was redesigned

Omit empty results tab for new editor

Copy as source code was fixed

Auto-completion disable was fixed

Query cancel UI was fixed (force cancel confirmation was removed)

Data transfer:

Export in TXT format: max column length detection was improved

Import from CSV format: column length detection was improved

Database to database transfer: tables order now depends on existing foreign keys

Manual tables reorder support was added

Bug with binary columns + copy to clipboard was fixed

Table/column mapping type selector was fixed

Driver editor dialog was redesigned

Clickhouse:

Driver download was fixed

Table column comments support was added

Redshift: driver version was updated (“session is read-only” issue was resolved)

MariaDB: sequences support was added

MySQL:

JSON columns copy was fixed

mysqldump parameters are set according to the client version

SQLite: column delete script was fixed

PostgreSQL:

Data types cache read was improved

Cross-schema type resolution was fixed

Database settings navigator was added

Column options were added for foreign tables

Google Cloud PostgreSQL driver was added (thanks to @olavloite)

SQL Server: jTDS driver support was fixed (problem with schema list load)

Exasol: grants refresh was fixed

Ubuntu PPA update was resolved

New tips of the day were added

All application jars are signed with DBeaver code sign certificate

Many minor UI bugs were fixed

Zaloguj lub Zarejestruj się aby zobaczyć!

Camel1965 · 28 Luty 2021

DBeaver 21.0.0

February 28, 2021

Main changes since 7.3:

Big number of improvements in data transfer tool (insert or update, types mapping, ordering, etc)

Spatial viewer: 3D objects support, custom tiles, SQLite support

SQL editor panels (log, output, result tabs, toolbars) were significantly redesigned

MacOS: a lot of UI rendering bugs were fixed, BigSur support added

A lot of database-specific issues were resolved and new features were added

All packages now include Java (no need to install it separately)

New databases: Trino, PostgreSQL for Google Cloud

Changes since 7.3.5:

MacOS: data grid renderer was fixed (bug with mess coloring)

Linux: package for ARM arch was added

Data transfer:

Multiple tables export ordering was improved

Tables manual reorder support was added

MySQL:

Events editor was added

mysqldump command line parameters now respect client and server versions

Oracle: tables statistics calculation was fixed

PostgreSQL: array data types resolution was fixed

Firebird: system objects detection was improved

BigQuery: driver version was upgraded

Exasol: SQL editor now supports LUA scripts (thanks to @Sargul)

Clickhouse: driver version was upgraded (SQL parser fix)

Redshift: bug with data types reading was fixed

Problem with “Tip of the day” popup was fixed

ERD: bug with broken notes layout after refresh was fixed

Action icons rendering was fixed on Linux

Many minor UI bugs were fixed

Zaloguj lub Zarejestruj się aby zobaczyć!

DBeaver

Camel1965

Bardzo aktywny

Ircus

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Ircus

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny

Camel1965

Bardzo aktywny