• Eclipse 2019-03 is now the default platform
• Embedded editor activation problem fixed (Linux)
• SQL editor:
  • SQL errors now shown in results panel instead of modal dialog (configurable)
  • Certain long strings visibility problem was fixed
  • Auto completion was fixed for CALL/EXEC keywords
  • Tables/schemas were removed from columns proposals
  • Context menu was improved (redundant items were removed)
  • Numerous NPE errors were fixed
  • Multi-statements scripts formatter was improved (adding statement delimiters)
  • Database-specific named parameters prefix was added
  • SQL formatting was fixed
  • Morph delimited list formatter was fixed (spaces in tokens)
• Data editor:
  • Unnecessary focus changing was fixed
  • Calc panel: strings/numbers aggregation toggle was added
• Data transfer: fetch size was added in export settings (may significantly improve performance)
• ERD (custom diagrams):
  • Additional styles were added for notes (colors, transparency, border, font settings)
  • Notes now can be connected with entities
• Dashboards:
  • Timeseries dashboards rendering was fixed.
  • New dashboards extraction model was added (statistics reading by intervals)
  • Exasol dashboards were added
• PostgreSQL:
  • Alpha version of GIS/spatial data viewer (maps) was added
  • Explain for queries with parameters was fixed
  • Database description reading was fixed (PG < 9.4)
• Greenplum: tables reading for GP 4.x was fixed
• Oracle:
  • Public synonyms in auto-completion
  • Session manager now shows instance ID (for clusters)
• MySQL/MariaDB:
  • New database dialog now uses server charset/collation defaults
  • Native client was updated (problems with dump/restore compatibility)
• MS SQL Server/Azure: driver version was updated, support of AD MSI authentication was added
• Elasticsearch: metadata reading was fixed (schema/table names escaping)
• Pervasive SQL driver configuration was added
• MySQL NDB cluster driver configuration was added
• Google BigQuery driver was updated
• Numerous localization bugs were fixed
• Many minor UI bug fixes

• Eclipse 2018-12 is now the default platform
• 32-bit versions were obsoleted
• Charts colors configuration
• Navigator resource folders visibility configuration
• Mock data: new random texts generators were added
• Data editor: inline editor focus handler was fixed
• Plaintext format: show Western European characters
• Data transfer: new connection close fix
• Snowflake: tables and columns comments edit support was added
• Oracle:
  • Session manager now tracks global sessions (RAC)
  • Procedures/packages save/compile command was fixed
• PostgreSQL:
  • Multi-tenant databases support was improved
  • Database description reading was added
• MySQL: execution plan build fix

DBeaver 6.0 is our new major release.

• Database health monitoring dashboards were added (for PostgreSQL, MySQL and MariaDB)
• Bookmarks: navigate to object action was added
• Content editor (XML, JSON): contents formatting was added (Ctrl+Shift+F)
• Charts: copy image to clipboard action was added
• SQL editor:
  • Morph to delimited text action was fixed (spaces processing)
  • Delete file action was added in tab context menu
  • Intelligent bracket auto-close was improved
  • Variables resolution was fixed (mixed letters case)
  • Script Save As in non-UTF encoding was fixed
  • Files delete: keep local history by default
  • Statistics panel rendering was fixed
• Data editor:
  • JSON auto-format was fixed (null values)
  • Standalone editor of NULL values was fixed
  • Date-time editor in native format was fixed
  • Plaintext renderer was fixed (extra spaces)
• SSH tunnel: keyboard-interactive AND publickey auth support was added
• Open resources in embedded text editor support was added
• Dark theme support was improved
• Tips of the day dialog font was fixed (HighDPI)
• PostgreSQL:
  • Arrays editor was fixed (new array create)
  • Indexes statistics was fixed (rel size)
  • Table dependencies info was added
• SQL Server:
  • SQL errors processing was fixed (error inside stored procedures)
• Oracle:
  • Objects search was fixed (synonyms resolution)
  • Procedures/packages compile was fixed (trailing delimiter, log error position)
• CockroachDB:
  • Database schema browser was fixed (aggregate functions, rules)
  • Permissions reading was fixed (CRDB style)
• MySQL: database dump without DROP statement option was fixed
• Firebird: sequences metadata reading was fixed
• Sybase:
  • Stored procedure reading was fixed (multiple databases)
  • Query processing was fixed (trailing semicolon issue)
  • Synonyms tab removed
• Many minor UI bugfixes

• Data viewer:
  • New UI for view switching (grid/text, record)
  • Columns search was added in data filter settings
  • Numeric data types rendering was fixed
  • Plaintext mode renderer was fixed
• SQL Editor:
  • Action toolbar design was improved
  • Context menu was simplified
  • “Find paired bracket” command was added
• Databse navigator: double-click behavior config was fixed
• Quick object search dialog UI redesign (object types selector)
• Data transfer:
  • Export from multiple SQL queries was added
  • Export into single file from multiple tables was added
  • Target file name generation was improved
• Transaction log: history loading was fixed
• Dark theme support was improved
• Optional extensions install was fixed (Eclipse 2018-09 support)
• Stored procedures calling was fixed for most databases
• Auto-completion was added to selector controls (comboboxes)
• New databases:
  • Apache Ignite driver was added
  • MapD (OmniSci) driver was added
  • Dremio database driver was added
• PostgreSQL: sequences DDL was fixed
• Greenplum: (thanks to GP team)
  • External tables create/edit support was added
  • GP functions DDL was improved
• SQL Server: better support of SQL Server 2008 and earlier
• Oracle: materialized view create/edit/refresh was added
• DB2 iSeries: driver config was fixed (object descriptions read enabled)
• SQLite: table DDL reading was fixed (indexes)
• Eclipse plugin: older Eclipse versions (4.4-4.6) support was fixed
• Interface localization was improved
• Many minor UI bugfixes

• Connection wizard was completely redesigned.
• Database driver icons were updated.
• “Tip of the day” dialog was redesigned, tips were added
• SQL editor:
  • Parameters binding was improved
  • @set command now supports variables
• Data transfer:
  • Tables/columns mapping UI was enhanced
  • Auto-mapping button was added
  • Summary page was redesigned
• ERD: attributes visibility configuration was fixed
• SQL Server:
  • Active directory and Kerberos authentication were added
  • Server sessions/connections manager was added
  • Error position highlighting was added
  • Auto-completion and object search was fixed
  • Schema list reading was fixed
  • Views, triggers and stored procedures editor was added
  • Foreign key navigation was fixed
  • Metadata read was improved
• Sybase: stored procedures reading was fixed
• Greenplum:
  • External tables browser was added
  • Greenplum-specific tables DDL was added
• PostgreSQL:
  • Problem with RDS/SSL connections was resolved
  • Data types reading was fixed
  • Extra tables and indexes statistics was added
  • Debugger break-point toggle command was fixed
• Exasol: comments edit support was added
• SQLite: metadata editor was fixed
• MS Access: metadata reading was fixed
• CSV: export/import settings save/load was fixed
• SAP HANA: native table DDL reading was added
• Dark theme: data editor colors were fixed
• Windows installer now supports silent instalation (/S and /D flags
• see WIKI)
• Unexpected editors “modified” mark was removed (Linux Mint)
• CSV: export/import settings save/load was fixed
• Older Eclipse (Mars) now supported by plugin version
• Object delete confirmation message was fixed
• Dangerous confirmation popups were removed
• Workspace switching (from menu) was fixed
• Numerous localization bugs were fixed
• Many minor UI bugfixes

• Data editor:
  • Open With menu was added (web browser and Excel)
  • Next page auto-fetch was fixed
• UUID/GUID generate function was added
• ERD:
  • Save as picture function was fixed (case-insensitive file path)
  • Attributes visibility configuration was improved
• Data transfer: “truncate target table before load” function was fixed
• SQL editor:
  • Parameters biding dialog + results scrolling glitch was fixed
  • Glitch with first time reading of proposal was fixed
  • Stored procedure auto-completion was fixed
  • Syntax coloring: Color Themes support was fixed
• SQL Server:
  • Default schema detection was fixed
  • Column data type resolution was fixed
  • Identifiers auto-completion was fixed
  • NVarchar(MAX) data type resolution was fixed
• Exasol:
  • Exasol V6.1 support was added
  • Metadata reading performance was significantly improved
  • Partitions information was added
  • Security management was improved (roles, priority groups, policies, etc)
• PostgreSQL:
  • Rules support was added (read-only)
  • Stored procedures (PostgreSQL 11) support was added
  • Aggregate functions meta information support was added
  • Database tablespace edit support was added
  • Reserved keywords update was added
• Greenplum:
  • External table DDL generation fixes were added
• Redshift: column encoding information was added
• Oracle: PS/SQL blocks parser was fixed
• Huge code refactoring was made (separation of model and UI plugins)
• Many minor UI bugfixes

Merry X-Mas everyone!

DBeaver 5.3.1 release notes:

• Java 11 support was added
• Data transfer: saving for tables/columns mappings was added
• Extensions installation/update were fixed on Windows (infinite restart loop)
• Object editor:
  • Actions toolbar UI was fixed
  • Expand/collapse actions for all list items were added
  • Foreign key creation dialog was fixed
• Data editor:
  • Dictionary value viewer/editor was fixed (null values, SQLite foreign keys)
  • Tooltips for foreign key links were added
  • Shortcuts for data view panels were added (customizable)
  • Results pagination now supports full data refresh (configurable)
  • Grid columns width calculation was fixed
• SQL editor:
  • Query timing was fixed
• Linked files/folders rename was fixed
• PostgreSQL:
  • UI for active database switching was improved
  • Interval data type support was improved
  • Database backup was fixed (schema name quote)
  • Support for table triggers comment view/edit was added
• Greenplum:
  • Tables DDL show GP-specific options now
  • Partition tables view was fixed
• DB2 z/OS: views definition reading was added
• Sybase/SAP ASE/SQL Anywhere: stored procedure list reading was fixed
• Vertica: projection columns comments view/edit support was added
• MonetDB: driver configuration was added
• Many minor UI bugfixes

DBeaver 5.3 is ready. Mostly it is a bugfix or “stabilizing” release so there were no new major features.
Changelist:

• Data editor:
  • Dictionary tables lookup/search was added
  • Grouping panel now supports different presentations
  • Unpin all tabs command was added
• SQL editor:
  • Auto-completion algorithm was improved
  • SQL formatter was improved (UPDATE, BEGIN/END)
  • Multi-tab context menu was fixed
• Connection wizard: settings page UI was redesigned
• Foreign key creation dialog: unique indexes usage was added
• SQL processing: LIMIT usage was fixed
• Connection ping (keep-alive) was improved (ping CALLED only during idle periods)
• FireBird: SQL execution plan analyzer was added (thanks to tomas303)
• SQL Server:
  • Database objects search was fixed
  • Metadata reading (unique keys) was fixed
  • Table comments editor was fixed
  • DateTimeOffset data type support was fixed
  • New extension requires Microsoft driver only
• Oracle:
  • Timestamp handling was fixed (for some Oracle server versions)
• PostgreSQL:
  • Non-default databases are disabled by default
  • Native psql invocation was fixed (for old PG versions)
• CSV files: columns and foreign keys reading was fixed
• H2: embedded database shutdown procedure was fixed
• A lot of minor fixes in UI and metadata processing

• SQL Server (MSSQL) database extension was added:
  • Native SQL Server metadata
  • Table/columns/indexes/constraints editor
  • View/edit objects’ comments
• Connection invalidate/reconnect action was redesigned (now forces reconnect always)
• Data viewer:
  • Cell rendering was fixed in the plaintext view
  • Data save/reject key bindings were fixed
  • Support of right align for numbers and dates in plaintext view was added
• SQL editor:
  • Tabs management was redesigned (now all tabs are pinnable and closeable)
  • SQL completion was significantly improved/fixed
  • Additional configuration for SQL formatter
• Object editor:
  • Problem with “jumping” focus was fixed
  • Links rendering was fixed
  • Checkboxes are now grouped together
• Data transfer: problem with multiple tables mappings was fixed
• Read-only connections now restrict metadata edit
• Driver properties editor UI was improved (password properties masking)
• Project explorer UI was fixed (header column sizes)
• PostgreSQL:
  • View and functions rename support was added
  • PostGIS support improved (now supports creation of new geometry values)
  • Data type DDL was added
  • Functions DDL was improved (comments)
  • JDBC driver default version changed to 42.2.5
• MySQL:
  • Multiple/excluding schema filters were fixed
  • Presto: table elements reading was fixed (performance)
  • DB2 z/OS: driver config was fixed (foreign keys reading)
  • A lot of minor UI fixes
  Tweet