DBeaver 5.2.4

  • Results viewer:
    • Ordering confirmation config was fixed (issue with “unsortable” results fixed)
    • Toolbars layout was changed
    • Grid presentation: columns width stretching (fit screen/value) commands were added
    • Plaintext presentation: tabs support was fixed
  • SQL editor:
    • Associated connection info can be placed in the first line of script (can be shared between different users)
    • Unnecessary objects information reading was disabled (completion performance was greatly improved)
    • Auto-completion was fixed (identifier replacement)
    • Use different syntax for store functions and procedures invocation
    • Fix for the “Search inside names” option support
  • Object editor:
    • Property editor form was redesigned/fixed
    • Glitch with jumping cursor fixed
    • Grid visibility config was added
  • Read-only connections detection was fixed
  • Light theme is now default DBeaver theme (instead of Classic)
  • Preferences pages were reorganized. SQL scripts processing pref page was added.
  • Driver selection page: new design (optional)
  • Linked folder/file handling was fixed (do not delete broken links)
  • Data transfer wizard: progress monitor was fixed
  • Greenplum:
    • Functions header/footer was added to DDL
    • Table DDL generation was enhanced
  • SQL Server: procedure names fixed in auto-completion
  • AWS Athena: connection page was fixed
  • ORacle: do not use DBA_* views by default
  • Mock data generation wizard was improved:
    • Possibility to skip columns
    • Column generator settings save/load was fixed
    • Skip auto-generated columns by default
  • Darkest Dark theme support was fixed
  • German language localization update (thanks to Bullnados)
  • Chinese language localization update (thanks to fengchao)
  • Maven configuration was redesigned (now Maven project nature can be used in Eclipse)
  • A lot of minor UI fixes
Posted in Releases

DBeaver 5.2.3

  • Object (tables, columns, etc) editor was redesigned
  • Statistics/misc tab was added to object editors
  • Data transfer supports document-oriented databases now
  • Table rename procedure is available from the table editor (MySQL, PG, Oracle, DB2)
  • Long operations canceling was fixed
  • “Tip of the day” popup was added
  • Java 11 support was added
  • Azure SQL driver was added
  • AWS Athena support was significantly improved
  • AWS Redshift:
    • Spectrum and external tables support was added
    • Columns and foreign keys metadata reading was fixed
  • Cockroach: foreign keys reading was fixed (for ERD)
  • Vertica: performance for data reading from big tables was improved
  • PostgreSQL: support transactions in tools (Truncate and others) was added
  • Oracle: TIMESTAMPTZ and TIMESTAMPLTZ data types support was fixed
  • Greenplum: session manager was added
  • SQL Server: sequences info reading was fixed
  • Clickhouse: GROUP BY/ORDER BY functions in grouping panel were fixed
  • Eclipse 2018-09 is now the default platform.
  • Extra command line parameters were added
  • German and Russian localizations were significantly improved
  • A lot of minor UI fixes
Posted in Releases

DBeaver 5.2.2

Release notes:

  • Google BigQuery extension was added
  • DBF files driver was added
  • SOCKS proxy: support for proxies on localhost
  • New version release checker was fixed (NPE)
  • SQL editor:
    • Selection occurrences highlighting was improved
    • Auto-completion: fuzzy completion is now used for all database objects
    • Extra formatting configuration was added
    • Active query tab switch bug was fixed
    • SQL joins auto-completion was fixed (quote column names)
  • Results viewer:
    • Filtering + ORDER BY was fixed
    • All long string editors now support xml/json formatting
    • Native date/time formatting support was added
    • Date/time columns justify config was added
    • Bit string values support was fixed
  • Data transfer:
    • Max string column length is respected when generating DDL
    • TXT format support was fixed (column widths)
  • Query/long tasks canceling was improved (configuration)
  • Connection default transaction isolation level configuration was fixed
  • Driver version selector was fixed (MacOS)
  • Apache Hive/Spark/Impala:
    • Table data edit support was added
    • Table/view source reading was implemented
    • Driver version was upgraded (2.6.5)
  • Firebird: table columns rename/reorder/edit is now supported
  • PostgreSQL:
    • Indexes predicate support was added
    • Domain data types (timestamp) resolve was fixed
  • Oracle 11: NULL timestamp bug was fixed
  • Clickhouse: driver config was fixed (catalogs)
  • SQL Server: native driver version upgrade (7.0.0)
  • Generic driver connection page UI was fixed (long URLs problem)
  • Many minor UI fixes
Posted in Releases

DBeaver 5.2.1

Release notes:

  • SQL editor: highlighting all occurrences of selected word (configurable)
  • DBeaver extensions installer was improved: admin permissions are not required any more
  • Color Theme extension support was added including Solarized Dark/Light themes
  • Problem with upgrade from DBeaver 3.x was fixed
  • Server session manager was improved:
    • UI was redesigned
    • Session manager is now present in Tools menu
    • “Explain execution plan” tab was added
    • Long operations panel was added
    • Oracle: many additional session properties were added
  • RPM package was fixed (with newer RPM packager)
  • Data transfer: option “Selected columns/rows only” were fixed
  • “Read data in SQL console” behaviour was fixed (use SQL scripts instead of console)
  • Extra commands were added to Database navigator context menu: for data edit, ERD, etc
  • Grouping panel was improved: default ordering, duplicates finder, SQL Server syntax support
  • UI for the connection selection dialog was improved
  • Procedures editor was fixed (Generic driver)
  • Results viewer:
    • Columns widths resize issue was fixed
    • Row deletion for custom SQL without unique key was fixed
  • SQL Editor:
    • Paste from source code
    • formatting was improved (line feeds)
    • SQL indentation was fixed (DDL statements)
    • Formatter preferences page was redesigned
    • SQL Workbench formatter was added
  • ERD editor: note delete command was fixed
  • Generic connections (Impala and some others) create was fixed (buttons enablement)
  • Oracle: “Connections has timed out” error was fixed
  • SQL Server: IPv6 hosts support was added
  • Vertica: tables metadata reading performance was greatly increased
  • PostgreSQL: generic (Legacy) driver metadata reading was fixed
  • Redshift/PostgreSQL: array data types support was improved (NULL arrays)
  • Added localization for many UI strings
  • Many minor UI fixes
Posted in Releases

DBeaver 5.2

Long waited major release. There are lots of bug fixes and improvements.
Changelist:

  • New connection wizard was significantly simplified
  • Database navigator now loads long table lists by segments (configurable)
  • Problem with data transfer wizard and connection wizard auto-resize was fixed
  • Results viewer:
    • Show error when cell value can’t be read from a database (instead of NULL)
    • Plaintext renderer was fixed (NULL values render)
    • Actions enable/disable state was fixed
    • Export to Excel now respects filters and orderings
  • Mock data:
    • Wizard was fixed (error with missing native client)
    • Batch size configuration was added
    • UUID data type support was added
    • String generator was fixed
  • CSV import:
    • Column mappings were fixed
    • Support literal for NULL mark
  • SQL editor:
    • Problem with procedures/views editor cursor reset on save was fixed
    • SQL formatter was fixed (spaces after brackets)
    • Completion of fully-qualified names was fixed
    • Error position highlight was improved
  • Long LOB values editor fix
  • New version check dialog can be suppressed for a particular version
  • ERD: show table/constraint comments
  • CockroachDB extension was added
  • PostgreSQL:
    • Active database switch was fixed
    • Native client selector was fixed. Binaries were upgraded to PG 10.5 version.
    • Improved support of PostgreSQL 7.x and 8.x
    • Allow to select directory in restore wizard
  • MySQL:
    • Problem with zeroDatetimeBehavior property was fixed
    • Duration data type support
  • Elasticsearch: driver version updated to 6.4
  • Redshift:
    • Native Redshift table DDL generator was added
    • Driver version update to 1.2.16 (now use Maven artifact)
  • SQLite: custom unique key editor was fixed
  • Vertica: SELECT INTO limit problem was fixed
  • H2: schema browser was fixed
  • MSSQL and Generic driver: support filters for procedures/packages
  • Misc minor UI problems were fixed
Posted in Releases

DBeaver 5.1.6

Release notes:

  • Generic driver: new objects creation was fixed
  • Foreign keys creation was fixed
  • Schema loading was fixed (Generic driver)
  • Native client download feature was added (MySQL, MariaDB, PostgreSQL)
  • Database objects search was fixed
  • Long CLOB value editor was fixed
  • Configuration for edit toolbar visibility was added (toolbar is disabled by default)
  • Keyboard shortcuts activation was fixed
  • Security:
    • SSH tunnel initialization fix (NPE)
    • SSH keyboard-interactive method: now use saved password
    • Advanced security (BouncyCastle) is now used for SSL/SSH cryptography by default (if present)
    • ed25519 support was updated
  • SQL editor:
    • Auto-completion was improved (fully-qualified names)
    • Source code paste transformer was improved
    • Indentation was fixed
  • Redshift:
    • PostgreSQL driver is used for connection
    • Data editor was fixed (read-only state)
  • Vertica: table list loading performance issue was fixed
  • MySQL: zeroDateTime configuration was fixed (solves performance issue)
  • PostgreSQL:
    • Table DDL was fixed (GRANT commands)
    • Foreign table DDL was fixed (OPTIONS clause)
  • SQL Server: BIT data type editor was fixed
  • SQLite: datatime/numbers formatting support was added
  • Many minor UI fixes
  • After all we have reverted to Eclipse 4.7 platform. There were too many bugs and problems with latest version. Especially with Linux platforms
Posted in Releases

DBeaver 5.1.5

Release notes:

  • Data import from CSV was added
  • Connection edit dialog was redesigned (General page)
  • SSH tunnel:
    • Support of SOCKS proxy for tunnel connections was added
    • Support of ‘keyboard interactive’ authentication was added
  • Results viewer:
    • SQL script generation was fixed
    • Number -> Epoch time transformer was fixed
    • Plaintext presentation render was fixed
    • Tab name detection for new tabs was fixed
    • Panel and dialog value editors now use monospace font
  • SQL and ERD editors glitch was fixed on Linux (GTK)
  • SQL editor:
    • File rename glitch was fixed
    • Auto-complete was fixed (string replace)
    • Parameters binding dialog additional configuration was added
  • Configuration for connection/schema selectors was added
  • Metadata search page was fixed
  • Basic edit actions toolbar was added
  • Data export in plaintext format was added
  • PostgreSQL:
    • Database create function was fixed
    • Databases refresh function was fixed
    • Error position extraction was fixed for localized client drivers
    • Dump restore (from directory) option was fixed
  • SQL Server: synonyms reading was added
  • Hive: driver was updated (get rid of huge and unstable Maven driver)
  • Vertica: connection page was fixed
  • Snowflake:
    • Connection page was fixed
    • Valid table/view DDL extraction was added
  • SQLite connection dialog was updated (get rid of user/password fields)
  • All jar files are now signed with code-sign certificate (important for Eclipse plugin version)
  • Meta-information (appdata) was added in Debian packages
  • Big number of minor UI and localization fixes
  • Posted in Releases

    DBeaver 5.1.4

    Release notes:

    • Data viewer:
      • Foreign keys/references navigation was improved
      • Unique key detection was changed (ROWID is used only if no natural key was found)
      • String filter editor was fixed
    • Full-text search history navigation was fixed
    • SQL formatter was fixed/improved
    • ERD: self-referencing tables rendering was fixed
    • Error dialog was enhanced (scrollable text for all errors, default focus is on Ok button)
    • Database navigator double-click behavior was extended (open new editor)
    • Database driver search was improved (search in descriptions)
    • Snowflake connection configuration UI was added in CE
    • Elastic Search driver configuration was added
    • AWS Athena driver configuration was added
    • Exasol extension now relies on v6 driver
    • PostgreSQL:
      • Multiple databases filter was fixed
      • Active database detection was fixed
      • Function list reading was fixed for PG < 8.4
      • Foreign server user mapping was added (thanks to @johnatanDM)
      • Permission editor UI was fixed
      • Many minor UI fixes
    • MariaDB/Galera: users editor was improved
    • MySQL/MariaDB: view creation was fixed
    • Oracle:
      • DATE data type support was fixed
      • Table statistics/storage information was added
      • Synonyms support was added in metadata extraction
      • Extra columns were added to Explain Plan nodes
      • Multiline editor for table/column comments
    • Firebird: sequences and triggers reading was fixed for older FB versions
    • Phoenix: metadata reading bug was fixed (databases with single schema)
    • Shortcuts with Ctrl+Alt were changed on Ctrl+Shift
    • DBeaver was migrated to Eclipse 4.8 platform. Besides other improvements this fixes a few old UI bugs on MacOS and Linux.
    Posted in Releases

    DBeaver 5.1.3

    Release notes:

    • Database objects search fixed (GoTo object dialog)
    • Database full-text search was improved (state loading, bug were fixed, search history was fixed)
    • Default error dialog was redesigned (allow message copy-paste and scrolling)
    • Drivers download errors was fixed (missing Maven artifacts handling)
    • ERD looks-and-feel was fixed. Extra configuration was added.
    • SQL editor:
      • Query comments processing was fixed
      • Left toolbar rendering was fixed (background color issue)
      • SQL formatter for sub-selects was fixed
    • Results viewer:
      • Presentation switch error was fixed
      • Sorting by ambiguous columns was fixed
      • Visualize read-only columns in grid header (different background color + tooltip)
      • Value view panel read-only state handling was fixed
      • Search in value view panels was added
      • Execution log and output panel toggle shortcuts were changed
    • PostgreSQL:
      • Driver version updated to 42.2.3
      • Multi-database support was improved (no need to switch active database on access)
      • Foreign table DDL was fixed
      • Materialized view DDL was fixed
      • Domain data types resolution was fixed (problems with date/time types)
      • Debug perspective switch was fixed
    • MySQL:
      • New driver for MySQL 8.x was added
      • Timestamp time zone issue was resolved
    • Oracle:
      • Tablespace storage information was fixed
    • Yellowbrick driver configuration was added
    • Timescale driver connection page was fixed
    • SAP HANA: activate database switch was added
    • Data export in SQL: null table name issue was fixed
    • Data transfer by segments + table truncate was fixed
    • Database output log contents filtering was added (zero characters)
    • Database navigator: icons position was fixed
    • New table columns rename was fixed
    • MacOS installer was fixed (CE and EE version on the same machine issue)
    • Debug logging was fixed (do not log secure information)
    • Many minor UI fixes
    Posted in Releases

    DBeaver 5.1.2

    Release notes:

    • SQL editor:
      • Commands toolbar was redesigned
      • SQL formatting for JOINs was fixed
      • Indentation in auto-formatter was fixed
      • Vertical editor selection bug was fixed
      • Support multiple values in @SET command
      • Command shortcut processing was fixed
    • Results viewer:
      • Filter editor behavior was fixed (Enter key processing)
      • Glitch with text edit panel (CLOBs) was fixed
      • Column (row) drag-n-drop in record mode is now supported
    • ERD:
      • Entity render was improved
      • Associations (foreign keys) resolution was fixed
    • PostgreSQL:
      • Active database switching was fixed
      • Metadata editor was improved (materialized views tablespace, table extra options)
      • Materialized views refresh tool
      • Explain plan conditions formatting was added
      • Index columns view was improved
    • MariaDB/MySQL:
      • Server time zone selected add in connection edit page (MySQL only)
      • Show view algorithm in metadata viewer
      • Save view was fixed
      • Save Trigger was fixed
      • Permissions grant was fixed for HISTORY privilege (MariaDB)
    • Oracle:
      • Show used/available space for tablespaces
      • View source extraction was fixed (extra semicolon issue)
      • Procedures auto-completion was fixed
    • DB2: sequence creation was fixed
    • SQLite: sequence reading was fixed
    • SAP HANA: procedures and functions were separated
    • Timescale: driver configuration was added
    • GoTo database object dialog: connection health checking was added
    • Row count calculation for custom queries was fixed
    • Metadata editor supports dialog with multiline editor for comments/remarks
    • Output log viewer auto-clear option was added
    • Connection invalidate was fixed (do not show notifications for alive connections)
    • Many minor UI and localization fixes
    Posted in Releases