Software update: DBeaver 6.0.4

DBeaver is a tool to manage databases. It can perform queries, display, filter and edit data, among other things. Support for the well-known databases, such as MySQL, Oracle, DB2, SQL Server, PostgreSQL, Firebird and SQLite, is available. It is available in a CE and EE flavour, with the former being open source at no cost. The enterprise flavor adds support for several nosql databases such as MongoDB, Apache Cassandra, and Apache Hive, as well as additional plugins and jdbc drivers. The developers have released version 6.0.4 with the following changes:

DBeaver 6.0.4

• data editor:
  • Value transformers for custom queries and pseudo columns
  • Advanced data coloring configuration
  • Logical entity structure editor
  • Gradient colors for numerical/datetime columns
  • Navigate to FK/references: multiple rows support
  • Extra shortcuts were added
• Spatial (GIS) viewer:
  • CRS (SRID) transformations support was added
  • Inverted coordinates support was added
  • Support of geography data type was added
  • Support of curved geometries was added
  • Open folder in browser command
  • Maximum geometry objects limitation was added
  • Numerous bug fixes (tooltips, actions)
• SQL editor:
  • Indentation was fixed (keyword-based indents were disabled)
  • Process @set commands in data export
  • “Format” context menu was fixed
• Schema selector toolbar was fixed (missing database name)
• Global native clients configuration was added
• Shortcuts for connection/schema selectors were fixed
• PostgreSQL:
  • Full schedule DDL generation was added
  • Function create was fixed (function body)
  • Trigger create support was added
  • Columns DDL was added
• MySQL: query metadata extraction was fixed (bug with wrong database name)
• Oracle: metadata reading was fixed
• SQL Server:
  • Procedures auto-completion was fixed
  • Support of older Azure versions was added
• Redshift: external tables (spectrum) data reading was fixed
• Clickhouse additional array data type support was added
• Korean localization was added (thanks to Seongbae Chang)
• Many minor UI bug fixes