DBeaver Changelog

What's new in DBeaver 24.0.1

Mar 24, 2024
  • Connectivity:
  • Shared SSH sessions support was added
  • Connection via native proxy was fixed
  • Dark theme support on the Connection page was improved
  • SQL Editor:
  • Highlighting, validation, and outline for INSERT, UPDATE, and DELETE were supported
  • Incorrect cursor position during autocomplete was fixed
  • QUALIFY keyword was supported (thanks to @ashu7896)
  • Metadata editor: automatic reference column creation for a new foreign key was implemented
  • Data Editor:
  • Opening of a table with empty data was fixed
  • SRID editing was fixed
  • General:
  • SVG icons support was added
  • Error when checking checkboxes in the Formatting page in Preferences was fixed
  • Disappearance of renamed project was fixed (thanks to @saikotek)
  • Databases
  • Dameng: Sequence creation was fixed
  • DuckDB:
  • Sequences, views, and table definitions were supported
  • Ability to add comments via UI was added
  • MySQL: link to the driver documentation was fixed
  • RisingWave: non-working functions and folders were removed
  • PostgreSQL: issues with scheduled jobs was resolved
  • SQLite: errors when creating table was fixed
  • SQL Server: redundant authentication types were hidden
  • Sybase: stored procedures support was improved
  • Teradata: procedures and functions DDLs reading was enhanced
  • Localization:
  • Romanian language support was added (thanks to @v613)
  • French translation was updated (thanks to @Jean-BaptisteC)

New in DBeaver 24.0.0 (Mar 4, 2024)

  • SQL Editor:
  • Nested CASE statements were supported
  • Deleting queries from Outline was fixed
  • Type casts support was improved
  • Handling of right-click on collapsed query was fixed
  • Expanding collapsed group after the code execution was fixed
  • Metadata editor: changing the key name when a constraint is changed
  • Data Editor: SRID switching in the Spatial data viewer was fixed
  • ER Diagram:
  • Missing connection lines were fixed
  • Mikami-Tabuchi routing type was disabled
  • AI:
  • Comment presentation was improved
  • Sending unique keys and indexes was fixed
  • Data Transfer:
  • Export statistic was fixed
  • Import blocking in case of table creation restriction was fixed
  • Stack overflow on Linux was fixed
  • Connectivity: closing timeout for an idle connection was increased and disabled for embedded drivers
  • Security:
  • Vulnerabilities display in Elasticsearch was fixed
  • PosgtreSQL driver was upgraded due to CVE-2024-1597
  • General:
  • Smart commit mode was enhanced: if the manual commit mode was enabled and just after it the query failed, the smart commit mode is enabled again
  • Links between preference pages were fixed
  • Issue with not found tables was fixed
  • Release note display was corrected
  • Driver libraries download was fixed
  • Previous workspace format was supported
  • Usage statistics popup was redesigned
  • Databases:
  • DuckDB: WSL paths handling was fixed
  • Greenplum: STRICT keyword was added to function definition
  • Hana: Switch to the Kerberos authentication in the Connection page was fixed
  • MariaDB: The exported JSON format was fixed
  • MySQL and MariaDB:
  • “Disable Triggers” option was added to the Context menu
  • “Case-sensitive” option was added to the metadata search
  • Databases with the same name but different name case are considered as different databases
  • Oracle: generating DDL for triggers was fixed
  • SQL Server: additional table properties were added for tables and views in the properties editor
  • Yellowbricks icons and link to the website were changed

New in DBeaver 23.3.5 (Feb 19, 2024)

  • SQL Editor:
  • Syntax highlighting was improved
  • Highlighting in nested queries and on query editing was fixed
  • Scrolling with opened Outline was fixed
  • Applying settings to Outline was fixed
  • Order by i.* was supported in Outline
  • Joined tables presentation in Outline was fixed
  • AI: Ability to send object descriptions to OpenAI was added
  • Data Editor:
  • Scrolling multiple tab result was improved. You can scroll all result sets using Ctrl
  • Fetch next page shortcut was changed to CTRL+ALT+N
  • ER Diagram: Connections rendering was improved
  • Data transfer:
  • The Proceed button at the last step became more visible
  • On conflict expression was added to INSERT statements
  • Crash when importing CSV file was fixed
  • Extra space before the semicolon in export to SQL was removed
  • General:
  • Close idle connection setting saving was fixed
  • Application launch was improved
  • Unexpected transaction ending was fixed
  • Settings are applied to new connections without a restart
  • User credential dialog was fixed
  • Issue with the background task of the dashboard update was fixed
  • Temporary directory creation was fixed
  • Security: Added warning when trying to open an encrypted project and risk losing all connection credentials
  • New driver:
  • StarRocks database support was added
  • Databases:
  • MariaDB driver was updated to version 3.3.2
  • Oracle:
  • Keywords and schemes highlighting was improved
  • Default subpartition type was added
  • PostgreSQL:
  • Creating a new table from the user interface was fixed
  • Duplication of procedures was fixed
  • Snowflake: VIEW keyword highlighting and validation was improved
  • SQL Server: syntax highlighting was fixed
  • Sybase:
  • Stored procedure creation was added
  • Using create view instead of Alter view was fixed
  • Import with table mapping was fixed
  • Localization:
  • French translation was updated (thanks to @Jean-BaptisteC)
  • Babel version was updated

New in DBeaver 23.3.4 (Feb 5, 2024)

  • Metadata Editor:
  • Constraint creation was fixed
  • Editor performance on Linux was enhanced
  • SQL Editor:
  • Autocomplete for aggregate functions was added
  • Arrays highlighting was added
  • SELECT query validation was fixed
  • Color and font settings with enabled semantic analysis was fixed
  • Small font in the editor and result set was fixed
  • Creating multiple parsing jobs was fixed
  • Outline viewer:
  • Composite types and arrays support and validation was added
  • Data type decorations were added
  • Error when saving SQL console as a script was fixed
  • AI: Issue with using chat format in completion dialog was fixed
  • Data Editor:
  • Ignoring quotes option was added to Advanced paste
  • Issue with multiple checks in filters was fixed
  • ER Diagram: Self-connection rendering was enhanced
  • Data Transfer:
  • Delimiter selection when exporting in TXT format was added
  • Target table change on the mapping page was fixed
  • General: Idle connections behavior has changed, now they are automatically closed by default after some time
  • New drivers:
  • RisingWave driver support was added
  • Cubrid driver support was significantly enhanced (thanks to @longhaseng52)
  • Databases:
  • Altibase:
  • Adding and renaming constraint in metadata editor was fixed
  • Reading data in columns with quote names was fixed
  • Clickhouse: Legacy driver was fixed
  • MySQL and MariaDB: ‘Grant option’ is checked only if grant permission exists
  • Snowflake:
  • Snowflake driver was updated to version 3.14.4
  • Double-dash single-line comments highlighting was fixed
  • Functions words were added to SQL Editor
  • SQLite driver was updated to version 3.44.1.0
  • TDengine: Unqoted table names presentation was fixed
  • PostgreSQL: Option ‘Show all databases’ was moved to the main page in the Connection settings
  • Redshift: Added extended support for stored procedures for early Redshift versions
  • Misc:
  • Links to download PRO version were added
  • Ability to use waffle-jna in MariaDB, PostgeSQL, and Oracle was added
  • Flipped splash screen on macOS Sonoma was fixed

New in DBeaver 23.3.3 (Jan 22, 2024)

  • Metadata editor:
  • Object creation dialog was redesigned
  • SQL Editor:
  • Autocomplete for INSERT statements was fixed
  • Case sensitivity on highlighting and validation was fixed
  • Duplicated table aliases in autocomplete were fixed
  • Column aliases highlighting was fixed
  • Dot character is not allowed again in variable name
  • Data Editor: Column descriptions are displayed again
  • Database Tasks: Display of task execution time was fixed
  • ER Diagram: One-to-one connection rendering for unique/primary key was fixed
  • Data Transfer:
  • All columns can be marked as skipped when exporting data
  • Statistics was excluded from exported data
  • General:
  • Changing the monospace font was fixed
  • Unique key creation was fixed
  • Finding local clients on Linux and macOS was improved
  • Databases:
  • Altibase support was added (thanks to @zennken)
  • BigQuery: Structs and arrays are supported
  • Dameng:
  • Dameng driver was updated
  • Users, roles, and categories are supported (thanks to @Stkai)
  • MySQL: Path to the local client was fixed
  • MySQL and MariaDB: Rendering columns with unique identifiers was fixed
  • PostgreSQL:
  • Schema permissions display was fixed
  • Confirmation message for clean option of restore wizard was fixed
  • SQLite: Import with ‘truncate target tables before load’ option was fixed
  • SQL Server:
  • Check constraint option was removed from primary/unique key creation page
  • Displaying source in the index properties was fixed (thanks to @HansenChristoffer)
  • SQL Server driver was updated
  • Localization:
  • Japanese localization was updated (thanks to @doew)
  • Misc:
  • Microsoft Store version was fixed
  • Starting application when the workspace directory is a link was fixed

New in DBeaver 23.3.2 (Jan 7, 2024)

  • Metadata editor:
  • New database objects wizard was redesigned
  • Primary/unique key can be created automatically along with new columns
  • SQL Editor:
  • Outline viewer of SQL queries structure was added
  • Execution time format was improved
  • Toolbar customization page opening was fixed
  • Identifiers coloring was improved
  • Autocomplete was fixed for multiline comments
  • Accessibility: notifications can be read with a screen reader (JAWs, NVDA or Narrator)
  • ER Diagram: connection errors handling was added
  • Data Transfer: Incorrect links in settings were fixed
  • AI: legacy OpenAI models were removed
  • General:
  • Incorrect links to help articles were fixed
  • Redundant items were deleted from the Context menu
  • Global network settings preferences page is available again
  • Databases:
  • ClickHouse: leagacy driver configuration was fixed
  • Dameng: tablespaces are supported (thanks to @Stkai)
  • Google Cloud SQL: redundant options were removed from the context menu
  • MySQL: TLS 13 support was added
  • MySQL and PostgreSQL: local native database clients can be found on macOS and Linux
  • Teradata: metadata search was significantly enhanced
  • Localization:
  • Ukrainian localization was added (thanks to @CrazyTapok-bit)
  • Italian translation was improved (thanks to @coluzziandrea)
  • Portuguese localization was fixed

New in DBeaver 23.3.1 (Dec 25, 2023)

  • SQL Editor:
  • New highlighting and script validation were enabled by default
  • SQL highlighting performance was improved
  • Connection variables and system environment variables now accessible from SQ Leditor
  • Handling of special characters was fixed
  • Data Editor:
  • Value selector panel was improved: you can switch the active panel with ‘Ctrl+Tab’ and change the active value in the context menu
  • Advanced paste of multiple records was enhanced
  • Spatial data zooming was improved (thanks to @kalkun)
  • ER Diagrams:
  • Diagram layout was enhanced
  • Data Transfer:
  • Users can change the data export task output format
  • Data export from table to table was fixed
  • Security:
  • Oracle driver version was updated to 23.2.0.0
  • General:
  • We switched to Eclipse 2023-12
  • Language detection for locale containing language and country was fixed
  • Workspace opening was fixed
  • ‘Statistic’ tab display was fixed
  • Broken links in connection dialogs were fixed
  • New foreign key name generation was fixed
  • Databases:
  • DB2: Loading schema statistics was fixed
  • EDB: Packages duplicating schemas in the Database Navigator were removed
  • Firebird: Function and procedure presentation was enhanced
  • Google Bigtable name was corrected
  • Greenplum: Rows policies were supported
  • MariaDB: Result fetch size was fixed
  • PostgreSQL:
  • Indexes and constraints are displayed in partition DDL
  • Backup of several schemas and several tables was enhanced

New in DBeaver 23.3.0 (Dec 3, 2023)

  • A number of minor UI bugs were fixed
  • Security: database drivers were updated due to security reasons: DB2, Google BigQuery, Athena, and YugabyteDB
  • SQL Editor:
  • Autocompletion of column names with special characters was fixed
  • Output panel display in the statistics tab was fixed
  • Selected query execution was fixed
  • Queries with CTE execution was fixed
  • Data Editor:
  • Filter value search was fixed
  • Advanced Copy as HTML with spaces in the column names was fixed
  • Numeric value “infinity” representation was fixed
  • ER Diagrams:
  • Diagram update on metadata changes was fixed
  • Automatic re-layout on notation or routing change was fixed
  • General:
  • Tips of the day were updated
  • Constraints rename was fixed
  • Idle transaction rollback notification was fixed
  • Data Transfer:
  • “Native clients” were renamed into “Local clients”
  • Update on conflict behavior was improved (now it respects indexes too)
  • Database restore was fixed
  • List of supported variables was updated
  • Database tasks: missing line break was added to the task log file
  • Connections:
  • Driver download error handle was fixed was fixed
  • ‘Check for new driver version’ setting save was fixed
  • Databases:
  • Firebird: default values for procedure parameters are now displayed
  • PostgreSQL/Greenplum: foreign key creation was fixed
  • MySQL5 driver is available again
  • Oracle: comments were added to the newly created columns

New in DBeaver 23.2.5 (Nov 19, 2023)

  • SQL editor:
  • Syntax coloring and code completion: smart columns abd aliases recognition was added (experimental)
  • Numerous improvements in single-tab results visualization
  • Quoting of identifiers with special characters was fixed
  • Issue with read-only column in queries with comments was resolved
  • COMMIT/ROLLBACK statements are now recognized as transaction state change statements
  • Data transfer:
  • Issue with unquoted column names was resolved (data import)
  • File import toolbar was redesigned
  • Library for XLSX export/import was updated, many minor issues were resolved
  • Accessibility:
  • Screen-readers support was improved (JAWS)
  • Editor tab names reading was fixed
  • ER diagrams: issues with notation switch were resolved
  • General:
  • Issue with output file name after multiple executions of data export task was resolved
  • Error “Data transfer IO error” was resolved
  • Comments in generated DDL now can be disabled (configurable)
  • Countdown visualization before auto-close was added for idle transactions
  • Extra tips added in connection keep-alive configuration
  • Database navigator: click in empty space handle was fixed (thanks to @itsyfx)
  • Databases:
  • MySQL:
  • Driver version was upgraded to 8.
  • Legacy MySQL 5.x driver was deprecated and replaced with MySQL 8 driver
  • Oracle:
  • Materialized views indexes management was supported
  • Materialized views permissions and dependencies view was added
  • Column alter DDL was fixed (NULL clause)
  • PostgreSQL:
  • Issue with VARCHAR limit change was fixed
  • Function comment delete support was added
  • SQL Server: extra dialect keyword were added (thanks to @brunodmartins)

New in DBeaver 23.2.4 (Nov 6, 2023)

  • SQL editor:
  • Code completion for update statements was added
  • Smart completion and replacements of quoted expressions was fixed
  • Redundant errors on opening SQL Editor for the first time were removed from the logs
  • Database Navigator:
  • Filtered objects visualization was added
  • Script folder opening was fixed
  • Data transfer:
  • Attributes names for quoted attributes are handled correctly
  • “Copy as HTML” result presentation is improved
  • Data editor:
  • Background color reset was fixed
  • Message about content representation size limit was fixed
  • App freeze in binary editor was fixed (MacOS)
  • ER diagrams: one-to-one connection rendering was fixed
  • Connections:
  • SSH connection page validation is enhanced for jump servers
  • Complex JDBC driver support was improved (context classloader + driver cache)
  • General:
  • Script names are sorted alphabetically
  • Refresh button was added to the “Generate DDL” dialog
  • Issue with app launch was fixed (rare case)
  • Databases:
  • Oracle: search package bodies as packages was supported
  • PostgreSQL:
  • Default privileges presentation and editing was supported
  • Sequences permissions reading for quoted roles was fixed
  • SQLite: required columns creating was fixed

New in DBeaver 23.2.3 (Oct 22, 2023)

  • Misc: we switched to Eclipse 2023-09
  • Data editor:
  • Excel (XLSX) export now supports columns auto-fit
  • Copy from row bellow/above command was fixed
  • Shortcut for “Got to column” column was changed to Ctrl+Shift+G
  • SQL editor:
  • Script statistics configuration was extended
  • AI completion bugs were fixed and configuration UI was redesigned
  • Tabs close in horizontal mode was fixed
  • Script to connection association save was fixed
  • Data export:
  • Data import tasks wer fixed for schema-less databases
  • Columns value transform expressions evaluation was fixed
  • All data transfer were migrated to a new IO API
  • Export functionality now can be disabled completely
  • Tasks loading for missing database objects was fixed
  • ER diagrams: one-to-one connections rendering was fixed
  • General:
  • Default file encoding was changed to UTF-8. IT affects all external tools integration.
  • Web based authentication is now opened in external browser by default
  • Version update functionality now can be disabled completely
  • Databases:
  • Clickhouse: map data type visualization was fixed
  • Databricks: issue with national encodings was resolved
  • Greenplum:
  • Issue with case-sensitive table names was resolved
  • FFL for function parameters was fixed
  • MySQL: session manager now shows info from performance_schema
  • OpenEdge: root catalog is now hidden; data export was fixed
  • PostgreSQL: foreign key DDL was fixed (MATCH FULL)

New in DBeaver 23.2.2 (Oct 8, 2023)

  • SQL editor:
  • Aut-completion for complex SQL queries was improved
  • Reconnecting of open editors when switching between Simple and Advanced view was fixed
  • SQL console now can be saved as script
  • ER diagrams:
  • Diagrams notations switcher was added
  • Connections rendering was improved
  • Crow’s foot notation was added
  • Data editor:
  • Multiple query results now can be displayed vertically
  • `Go to column` (Ctrl+F) action was added
  • Column search was added to Metadata panel
  • Numeric formatting was fixed for floating point numbers
  • Issue with empty table after opening the Calc panel was resolved
  • Setting row color for the result set was fixed
  • Data transfer: columns automating mapping is now configurable
  • General:
  • `Restore defaults` on preference pages now resets to actual default preferences
  • Eclipse 2023-09 plugin API is now supported
  • Reset UI settings was fixed on macOS
  • App crash when running on Wayland was fixed
  • java.compiler and java.scripting modules were included in bundled Java
  • Databases:
  • Dameng database extension was added
  • Clickhouse: array map representation was fixed
  • Google Spanner: table DDL generation was fixed
  • DB2 LUW: trigger editor was fixed
  • Exasol: customer group creation was fixed
  • Fireberd: several keywords were added
  • Materialized: system schemas loading was fixed
  • PostgreSQL:
  • Backup/restore native tools execution was fixed
  • `Europe/Kyiv` timezone support was fixed
  • Redshift:
  • Schemas loading was fixed
  • Spectrum tables loading was fixed (for custom driver configurations)

New in DBeaver 23.2.1 (Sep 25, 2023)

  • SQL Editor:
  • Aliases proposals for tables with joins were improved
  • SQL console can now be saved as a script
  • Enhanced smart completion is enabled (configurable)
  • Issue with big string contents (json, xml) edit was resolved
  • JSON formatting in the separate editor was fixed
  • Ctrl+Alt+6 shortcut was changed to Ctrl+Alt+T
  • JSON functions keywords were added to the SQL Assist
  • Representation of errors on query execution was fixed
  • ER Diagrams:
  • Crow’s foot and Bachman diagram notation styles were added
  • Issue with duplicate relations on the diagram was fixed
  • Data Editor:
  • Big content representation end editing was limited to 1MB (configurable)
  • User can now add a shortcut for setting row color
  • Issue with hiding the wrong column from the context menu was resolved
  • Grouping panel now shows actual executed SQL
  • Decimal rounding error was fixed
  • General UI:
  • When exporting a project, a warning about replacing an existing project was added (thanks to @MontejoJorge)
  • Scroll bars were added on the connection page, and other wizards
  • Issue with broken quotes in localization files was resolved
  • Connectivity:
  • Driver download UI was improved: already downloaded driver files are colored in grey
  • JDBC drivers maven artifacts resolve was fixed
  • The “Propagate driver properties” option was added to the driver settings
  • New drivers:
  • JDBCX driver was added (thanks to @zhicwu)
  • Databases:
  • Clickhouse: IPv4 data representation was fixed
  • Greenplum: External tables representation was fixe
  • MySQL: Unsupported engine types are replaced with the default one
  • Oceanbase:
  • Views editor was supported
  • Routines and procedure parameters read was fixed
  • PostgreSQL:
  • Foreign tables folder was added
  • Enum data types reading performance was enhanced
  • Redshift: Backup/Restore tools were deprecated and removed from UI
  • Snowflake:
  • Driver was updated to 3.13.25
  • Materialized views are now supported
  • Schema create UI was enhanced was enhanced
  • Trino: Views DDL support was added

New in DBeaver 23.2.0 (Sep 4, 2023)

  • Changes since 23.1.5:
  • Data Editor:
  • Spatial values rendering was fixed
  • Spatial images capture was fixed
  • Special characters rendering was improved
  • Grouping panel icons were improved
  • ER Diagrams: saved diagrams now can be opened on another computers
  • Data transfer: import settings handling was improved
  • Accessibility:
  • Connection dialog now supports screen readers
  • Cell value reading was improved
  • Ctrl+Shift/Alt+PageDn: vertical tabs switch
  • Ctrl+ALT+6: SQL editor and results tab switch
  • Ctrl+Shift+Enter now opens ER diagram entities
  • Ctrl+Shift+N: new connection dialog open
  • Database drivers:
  • Bigquery: DDL for tables, views and stored procedures was added
  • Clickhouse: arrays and structures visualization was fixed
  • Greenplum: external tables reading was fixed
  • Teradata: issue with the missing templates was fixed
  • Many minor UI and database issues were resolved

New in DBeaver 23.1.5 (Aug 21, 2023)

  • Data editor:
  • Dictionary viewer panel UI was redesigned
  • Spatial data types: curved geometries linearizing was fixed
  • Issue was result tab close on data save was resolved
  • Column tooltips was fixed
  • Charts rendering errors visualization was improved
  • SQL editor:
  • Autocompletion in single-line comments was fixed
  • Variable value editor was fixed
  • Smart completion for CTE queries (WITH/SELECT) was fixed
  • @include command handler was fixed (reuse the console for the same included script)
  • INSERT SQL query generation was fixed (identity columns)
  • Issue with text search/replace in hidden files was fixed
  • ERD editor: grid foreground color was fixed
  • General UI:
  • Objects sorting in tables now can be reset to the original ordering
  • Network handlers (SSH, SSL, etc) UI was redesigned
  • New object creation shortcut was added (Alt+Insert)
  • External files opening was fixed on MacOS and Linux
  • Command line connection opening was fixed
  • User name/password prompt dialog as fixed for SSH tunnels
  • Issue with preference pages in Eclipse plugin was resolved
  • Accessibility:
  • JAWS and Narrator support was improved for data editor and vertical tabs
  • High contrast theme support was significantly improved
  • Databases:
  • Clickhouse: map and array data types visualization was added
  • Greenplum: tables DDL was fixed (for version 7)
  • OpenGauss DB: json data types support was added
  • PostgreSQL: default native clients (pgsql, pg_dump) version was changed to 15
  • Yellowbrick: stored procedures drop query was fixed
  • Localization:
  • Chinese localization was updated (thanks to @bianyun)

New in DBeaver 23.1.4 (Aug 7, 2023)

  • SQL editor:
  • Table alias generation was fixed (issue with duplicated aliases)
  • Auto-proposals now respect option “empty line is a query delimiter”
  • Auto-proposals calculation performance was significantly improved in some cases
  • Aliases completion was fixed (issue with redundant spaces)
  • Table name completion was fixed for invalid SQL queries
  • Spelling errors and other annotations now work in console mode
  • @import command behavior is now configurable
  • Data editor:
  • Filters/orderings/colors reset UI was significantly improved
  • Spatial viewer now hides empty labels
  • Copying of spatial viewport/selection bounds was fixed
  • Drag-n-drop in grouping panel fixed on Linux
  • Data transfer: previous export settings loading was fixed
  • General:
  • Auto-commit mode switch behavior was fixed
  • CLI processing was fixed in multi-workspace environment
  • “Tip of the day” now shows OS-specific shortcuts corectly
  • Redundant logs of SSH tunnel closing were removed
  • Logical database structure settings can be disabled or reset in the connection editor dialog
  • Driver search UI was fixed on MacOS
  • Number of minor UI bugs were resolved
  • Database:
  • Athena: multi-catalog support was added
  • Derby: grouping queries generation fixed
  • DuckDB: time/timestamp data types support was added
  • MySQL: issue with missing table partitions folder was resolved
  • Oracle: table DDL shows permission grants in “full” mode
  • PostgreSQL: issue with duplicated tables was resolved
  • Redshift: SQL dialect was enhanced with extra keywords
  • Yellowbrick: execution plan visualization was fixed

New in DBeaver 23.1.3 (Jul 23, 2023)

  • Spatial data viewer:
  • Geometry object labels were added to the map (configurable)
  • Curves rendering was implemented
  • Coordinates and viewport bounds copy was implemented
  • EWKT format support was added
  • Toolbars and lasso visibility toggle was fixed
  • Data transfer:
  • Import of multiple tables from an XLSX was implemented
  • Lazy initialization of configuration pages was implemented
  • Issue with duplicated file selector dialog was fixed
  • Export in XML format was fixed (doctype section is not optional)
  • Issue long filenames on Windows was fixed
  • Data Editor:
  • Find/Replace dialog and shortcut in the Value view panel were fixed
  • Column description was added to the Metadata panel
  • Folding in the XML presentation was fixed
  • Displaying of images in the the value view panel was fixed on Linux
  • Confirmation dialog for the result set filtering was improved
  • Accessibility:
  • JAWs screen reader can now read data in the Data grid
  • General UI:
  • Tips of the day were updated
  • Creation of objects with mixed-case identifiers was fixed
  • DDL generation for sequence was fixed
  • Logical project deletion was fixed
  • Issue with opening of a local project was fixed
  • AI:
  • New GPT 3.5 Turbo 16К model was added
  • Issue with long metadata information sending was fixed
  • Connections:
  • Duplicates on driver creation were removed
  • Issue with maven artifacts editing was fixed
  • Certificate management UI was improved
  • New drivers:
  • Materialize database driver was added (thanks @bobbyiliev)
  • Crate DB via PostgreSQL driver was improved (thanks @proddata)
  • Databases:
  • DB2: users can see Column Mask Objects
  • TimescaleDB branding was updated
  • Localization:
  • Chinese Simplified localization was improved (thanks @bynyun)
  • German localization was improved (thanks @fjf2002)

New in DBeaver 23.1.2 (Jul 9, 2023)

  • Connections: kerberos support in legacy JDBC drivers (Hive) was fixed
  • Data transfer: table information for tasks with broken connection was fixed
  • PostgreSQL: enum columns alter was fixed
  • Misc: internal app controller server now uses HTTP instead of RMI
  • SQL editor:
  • Mouse hovering over editor annotations was fixed
  • Trailing DDL query delimiter processing was fixed
  • Data editor:
  • References panel refresh was fixed
  • XML presentation was fixed (NULL value handler)
  • General UI:
  • Settings reset UI and behavior were redesigned
  • Editor tab tooltip now contains information abut resource’s project
  • CLI parameter for app version print was added
  • Objects with mixed case names caching was fixed
  • Issue with program launch with wrong Java version was fixed
  • Preferences export/import UI was improved
  • Maven snapshot repository was added to default configuration
  • Databases:
  • BigQuery: driver version was upgraded to 1.3.3 (thanks to @fredlegaucher)
  • DuckDB: LIST data type support was added
  • Firebird: filters and sorting in grouping panel were fixed
  • IBM i: driver download was fixed
  • Oracle:
  • Partitions cache refresh was fixed
  • Stored procedures edit/save was fixed
  • Snowflake:
  • Client application name set was fixed
  • Quoted identifiers auto-completion was fixed

New in DBeaver 23.1.1 (Jun 26, 2023)

  • SQL Editor:
  • Autocomplete now supports [ ] and ` as quotes for identifiers
  • Shortcut confict on macOS was fixed
  • JSQLParser was reverted to the version 4.5 and is now faster
  • Issue with substitution variables in text with n line feeds was fixed
  • Autocomplete case with FROM right after SELECT is now handled
  • Autocomplete for SELECT query without FROM was fixed
  • ‘Go to Matching Bracket’ shortcut was changed to CTRL+SHIFT+[
  • Autocomplete for columns in tables without alias was fixed
  • Completion analyze errors are now written to the debug log
  • Comment with a tab after a double dash is now handle
  • Issue with hiding cursor position after resizing the editor was fixed
  • Exeption when updating editor annotations was fixed
  • Data Editor:
  • Data ordering was improved
  • General UI:
  • Changing the size and position of the connection dialog is now saved
  • Issue with the application freezing when creating a table when the connection hangs was fixed
  • Tips of the day were revised
  • Connectivity:
  • Option to disable SSHJ hostname verification was added (thanks to @ryanc-me)
  • Issue when switching from Community to PRO version and vice versa was fixed
  • Databases:
  • ClickHouse: display of large numbers was fixed
  • MariaDB: partition support was added
  • Oracle:
  • Issue issue with native clients hanging when running SQLPlus scripts was fixed
  • Issue with setting the wrong schema after connecting or changing the Data Editor was fixed
  • PostgreSQL:
  • Issue with an exception when loading attribute information was fixed
  • Reading a numeric array was fixed
  • Trino: error handling was improved
  • Localization:
  • German localization was improved (thanks to @hype11)
  • Italian localization was improved (thanks to @Gnafu)
  • Misc:
  • Images for all DBeaver Eclipse extensions were added
  • Legacy ODBC driver based on the obsolete Java 7 was deprecated due to many issues

New in DBeaver 23.1.0 (Jun 5, 2023)

  • SQL Editor:
  • Autocomplete now supports [ ] and ` as quotes for identifiers
  • Shortcut confict on macOS was fixed
  • JSQLParser was reverted to the version 4.5 and is now faster
  • Issue with substitution variables in text with n line feeds was fixed
  • Autocomplete case with FROM right after SELECT is now handled
  • Autocomplete for SELECT query without FROM was fixed
  • ‘Go to Matching Bracket’ shortcut was changed to CTRL+SHIFT+[
  • Autocomplete for columns in tables without alias was fixed
  • Completion analyze errors are now written to the debug log
  • Comment with a tab after a double dash is now handle
  • Issue with hiding cursor position after resizing the editor was fixed
  • Exeption when updating editor annotations was fixed
  • Data Editor:
  • Data ordering was improved
  • General UI:
  • Changing the size and position of the connection dialog is now saved
  • Issue with the application freezing when creating a table when the connection hangs was fixed
  • Tips of the day were revised
  • Connectivity:
  • Option to disable SSHJ hostname verification was added (thanks to @ryanc-me)
  • Issue when switching from Community to PRO version and vice versa was fixed
  • Databases:
  • ClickHouse: display of large numbers was fixed
  • MariaDB: partition support was added
  • Oracle:
  • Issue issue with native clients hanging when running SQLPlus scripts was fixed
  • Issue with setting the wrong schema after connecting or changing the Data Editor was fixed
  • PostgreSQL:
  • Issue with an exception when loading attribute information was fixed
  • Reading a numeric array was fixed
  • Trino: error handling was improved
  • Localization:
  • German localization was improved (thanks to @hype11)
  • Italian localization was improved (thanks to @Gnafu)
  • Misc:
  • Images for all DBeaver Eclipse extensions were added
  • Legacy ODBC driver based on the obsolete Java 7 was deprecated due to many issues

New in DBeaver 23.0.5 (May 21, 2023)

  • SQL Editor:
  • Autocomplete for WHERE and SELECT shows aliases with the aliased table
  • Hovering information for SQL errors and spelling annotations was added
  • Variable and parameter names in the binding dialog are now displayed in their original case
  • Information about assigning a non-dynamic variable was added to the binding dialog
  • Issue with incorrect icon for Execute SQL Statement after opening Output tab was fixed
  • Query Manager: ‘Restore Default’ button behavior was improved
  • Ability to directly execute SQL scripts in native clients was added
  • Data transfer:
  • Ability to trim string values when exporting to XLSX was added
  • Handling of datetimeoffset was added
  • General UI:
  • Part divider UI was redesigned
  • Option to increase formatting time was added in Preferences
  • Issue with closing pinned tabs using ‘Close Tabs to the Left’ was fixed
  • Connectivity:
  • Issue with driver fallback not being updated was fixed
  • Databases:
  • ClickHouse: driver was updated to 0.4.6 (thanks to @zhicwu)
  • Databricks: handling of data types without parameters was added
  • Hana: comments handling was fixed
  • MySQL: partitions are now supported
  • Oracle: TNS import was fixed
  • PostgreSQL:
  • Issue with duplicate tables with generated columns in Database Navigator was fixed
  • Error message about line on the map created with a single point was added
  • Schema refresh was fixed
  • SQLite: ability to open ER Diagram in the Simple View was added
  • Localization:
  • German localization was improved (thanks to @hype11)
  • Italian localization was improved (thanks to @Gnafu)

New in DBeaver 23.0.4 (May 7, 2023)

  • Data Editor:
  • Bottom toolbar became customizable
  • Disconnected editors can be easily reconnected
  • Issue with Ctrl+1 shortcut not working was fixed
  • SQL Editor:
  • Issue with refresh button closing active resul tab was fixed
  • Issue with not correct dislaying of rn sequence was fixed
  • Issue when generating the same UUID for all rows was fixed (thanks to @SiyaoIsHiding)
  • Data Transfer:
  • Ability to change the target column type on import to BIGINT was added
  • Export from query to CSV was fixed
  • Git: Missing git buttons and menus were added on macOS (Apple Silicon)
  • Databases:
  • ClickHouse: Catalog support was added
  • Informix: issue with extra spaces in table name was fixed
  • MySQL:
  • Event reading for quoted schemas was fixed
  • Time handling in MySQL was improved
  • Oracle:
  • Issue with parcing IF EXISTS statements was fixed
  • The display of DATE with additional settings in the Result Set was fixed
  • Inromation about latest statistics update was added
  • PostgreSQL:
  • Generation of ALTER table SQL for foreign tables was improved
  • Role settings were added in generated DDL
  • IDENTITY SEQUENCE were added in generated DDL
  • Snowflake: issue with incorrect import with BIGINT, INT, REAL, FLOAT, DOUBLE PRECISION, and DECIMAL data types was fixed
  • Trino: issue with import files with varchar data type was fixed
  • Misc:
  • SalesForce driver was updated
  • ODBC connection error was fixed
  • Java native libraries were added to DBeaver installation directly to avoid app crash cased by system restrictions.
  • DBeaver started to collect user statistics. It is anonymous and optional

New in DBeaver 23.0.3 (Apr 23, 2023)

  • General UI:
  • Issue with zoom in and out with Ctrl++ and Ctrl+
  • in SQL Editor and Data gird was fixed
  • ER Diagram font now depends on the Main font
  • A lot of UI rendering improvements were made
  • SQL Editor:
  • Moving with Ctrl+Right/Left now considers words with an underscore and a dollar as a whole word (configurable)
  • Autocomplete for mixed-case was improved
  • Issue with crashing when closing the SQL Editor tab was fixed
  • Order by parsing was improved
  • AI: issue with changing settings was fixed
  • Data Editor:
  • Data filters support in the Grouping panel was added
  • Opening TXT, JSON, and XML files in external editors was improved on macOS and Linux
  • Rendering of non-display characters was improved
  • Issue with disappearing filter option, when a query returns nothing, was fixed
  • Microseconds epoch transformer was added (thanks to @BobrPetr)
  • Database Navigator: issue with creating a new view was fixed
  • Data transfer:
  • Issue with set max column length when exporting in TXT was fixed
  • Issue with export JSON to TXT was fixed
  • Databases:
  • Firebird: recognition of procedure parameter data types was improved
  • SQLite: issue with database synchronization with the server was fixed
  • Redshift: issue with renaming a view in Database Navigator was fixed
  • MySQL: issue with the empty privileges list was fixed
  • Snowflake: displaying the creation time of Snowflake views was added
  • TiDB Cloud: telemetry support was added (thanks to @Icemap)
  • PostgreSQL: array presentation was improved
  • Localization of Brazilian Portuguese was improved (thanks to @brlarini)

New in DBeaver 23.0.2 (Apr 10, 2023)

  • ER Diagrams:
  • Accessibility support (text reader) was added
  • Many keyboard shortcuts were added
  • Issue with diagram re-layout after options change was resolved
  • Issue with moving focus when searching was fixed
  • General UI:
  • Database editors remain open after disconnect (configurable)
  • Clickable hints are now displayed as links
  • Issue with missing icons in the toolbar on MacOS was fixed
  • Font and color changes in the Result Set were improved
  • Large fonts now display correctly on MacOS
  • SQL Editor:
  • Auto-completion for INSERT/UPDATE/DELETE queries was improved
  • Font changes are now applied without a restart
  • Data Editor:
  • Show numeric values (e.g. infinity) rendering was improved
  • Issue with opening images from value panel in external editor was fixed
  • Connectivity:
  • Legacy SSH algorithms support was added
  • Confirmation dialogs now remember user selection
  • The number of attempts to reopen the connection was reduced
  • Ability to connect via SSHJ with unsaved password was added
  • Maven artifacts configuration now supports classifier
  • Data transfer: column description support was added for CSV and XLS formats
  • AI (ChatGPT): unsupported AI models were replaced with new ones
  • Databases:
  • Firebird: default parameters in procedure definitions were added
  • PostgresSQL: materialized views dependencies were added
  • Databricks: support of table comments were added
  • Oracle: issue with cropped ‘q’ at the end of the string was fixed
  • SQLite: triggers delete was implemented
  • SQL Server: issue with duplicated data types was resolved
  • Localization:
  • Traditional Chinese localization was updated (thanks to @hwhsu1231)
  • Traditional Chinese language was added to Windows installer
  • Misc:
  • Microsoft store: issue with application installation was fixed on most machines
  • We switched to Java 17 (again)
  • We switched to Eclipse 2023-03 as a base platform

New in DBeaver 23.0.1 (Mar 26, 2023)

  • SQL editor:
  • Results tab now can be detached
  • Editor toolbar now can be customized in preferences
  • Query statistics tab now can be turned off
  • Table metadata search was improved
  • SSH:
  • Support of new crypto ciphers was added
  • SHH agents now works properly in Linux
  • General UI:
  • Zoom in text editors and data editors was fixed
  • Navigator tree refresh after metadata change was fixed
  • Default font size was increased for MacOS
  • Text font configuration was fixed in multiple dialog windows
  • Connection type settings change now affects UI properly
  • Data export: exporting of BLOB values in TXT format was improved
  • Native network proxy configuration was fixed
  • TiDB: new driver was added (thanks to @Icemap)
  • Clickhouse: driver version was updated to 0.4.2
  • Firebird: procedure parameters defualt values support was added
  • Oracle: additional properties in table info were added
  • PostgreSQL: composite data type support was improved
  • SQLite: STRICT mode support was added
  • Sybase/SQL Anywhere: result set size limitation in SQL was fixed
  • Vertica: expired password change feature was added

New in DBeaver 23.0.0 (Mar 5, 2023)

  • SQL editor:
  • Column metadata resolution was fixed for quoted column names
  • SQL console now respects “open separate connection” option
  • Variables resolve in @set and other commands was fixed
  • Copy/paste command was fixed for editors without associated connection
  • Data editor:
  • Spatial viewer: lasso tool was fixed for Safari browser
  • Support of WKT format stored in BLOB columns was added
  • Issues with image viewer and BLOB columns was fixed (NullPointer error))
  • Selected columns/rows data export was fixed (issue with BLOB value turning into NULL in UI)
  • Accessibility:
  • Font settings are now respected in all editors/popups
  • New keyboard shortcuts schema was added “DBeaver Keyboard Only”
  • Many new keyboard shortcuts were added
  • Catalog/schema selector now supports keyboard only mode
  • Results tab pin/unpin command is now accessible from keyboard (thanks to @hawthorne3341)
  • Reader texts were localized
  • Database dashboard create wizard UI was fixed
  • Generate SQL dialog now supports connection invalidation
  • Clickhouse: driver version was updated to 0.4.1
  • Dremio: driver version was updated to 24.0
  • Firebird: table colum comments support was added
  • PostgreSQL:
  • Issue with URL-based connections was resolved (invalid host name)
  • Execution plan parameters are now saved
  • Redshift: varbyte datatype suport was fixed
  • SQL Server:
  • UI for Kerberos authentication configuration was fixed
  • Table colum comments support was added
  • French localization was fixed (thanks to @alexgille)
  • Problems with Kerberos were resolved (we have reverted to Java 11)

New in DBeaver 22.3.5 (Feb 19, 2023)

  • ChatGPT smart completion:
  • Completion popup UI was improved
  • Metadata scope configuration was added
  • Redundant config options wer removed
  • Data editor:
  • Accessibility support was significantly improved (context menu, additional keyboard shortcuts)
  • Filtering and ordering icons visibility configuration was added again
  • Dictionary viewer was fixed (issue with missing dictionary values)
  • “Save filters” button was removed from custom SQL queries results
  • App crash on geometry viewer opening was resolved in the latest version of MacOS
  • SQL editor: query text extraction was fixed (issue with trailing comment after query text)
  • Database backup/restore: issue with external tools running was resolved (Linux)
  • Application fonts were unified. Now we have only Main and Monospace fonts configuration
  • Data transfer: data type mapping now respects type name case (for databases with different default case)
  • Variables support in database tasks was fixed
  • Database tools wizard: redundant task configuration page was removed
  • SQL generator dialog now show progress to avoid UI freeze on big schemas
  • Issue with opening ERD files from disk ws resolved
  • Clickhouse: DDL for array columns was fixed
  • Databricks: additional metadata was added
  • Exasol: default connection parameters were updated (thanks to @allipatev)
  • IRIS (ex Cache): driver version was updated
  • Oracle: stored procedures invocation syntax was improved
  • Snowflake: driver now uses single database connection for all editors (configurable)
  • SQL Server:
  • Driver version was updated to 11.2.3. Trust server certificate option was moved to the main connection page
  • Server messages (printed on raiserror) reading was fixed
  • Multiple resultsets reading was fixed (extra error handling was added)
  • VARCHAR(MAX) data type support was added
  • SQLite: converting binary columns into string representation was fixed

New in DBeaver 22.3.4 (Feb 5, 2023)

  • Redshift: triggers DDL reading was fixed
  • Snowflake: table constraints reading was fixed
  • We switched to Java 17 so now DBeaver supports all newest JDBC drivers
  • ChatGPT integration for smart completion and code generation (as optional extension)
  • Database navigator: issue with rename/refresh was resolved
  • Dashboards were fixed for inherited databases
  • Project import now sets DBeaver nature (thanks to @froque
  • ERD: custom diagram editor was fixed (issue wth missing notes and connections was resolved)
  • Databricks: table DDL reading was fixed, extra SQL keywords were added (thanks to @mixam24)
  • DB2 BigSQL: table with RID_BIT columns data reading was fixed (thanks to @bkyle)
  • MySQL: numeric identifiers quoting was fixed
  • Netezza: tables/views search query was improved
  • Accessibility:
  • Text reader for entity editor was improved
  • Text reader for data grid was improved
  • SQL editor:
  • Query generation from human language text was added
  • Server output log levels configuration was improved
  • Global metadata search was fixed
  • Variables resolution is fixed in strings and comments
  • Issue with queries with invalid line feeds was resolved
  • Data editor:
  • Grouping panel messages were improved
  • Datetime calendar editor was fixed (in panel and inline editor)
  • PostgreSQL:
  • Procedures invocation was improved (thanks to @plotn)
  • Filter by enum was fixed (thanks to @plotn)

New in DBeaver 22.3.3 (Jan 22, 2023)

  • SQL editor:
  • Output logs viewer now respects log levels and supports log search
  • Auto-completion for mixed case schema name was fixed
  • Result tabs count message was fixed
  • Auto-completion of cell values is now configurable
  • Query execute time is now populated in statistics (thanks to @bob27aggiustatutto)
  • Mixed-case variables resolution was fixed
  • Execute statistics UI was fixed (redundant i
  • Data editor:
  • Column name ordering in record mode was fixed
  • Chart type configuration added to the context menu
  • Issue with column focus in context menus was fixed
  • General UI:
  • Database navigator now respects font size customization
  • Dashboard graphs now support dark themes
  • DB2: client application name population was fixed
  • Exasol: privileges reading was fixed for SaaS (thanks to @allipatev)
  • MySQ:/MariaDB: schema privileges save was fixed (issue with UI refresh)
  • Oracle: complex data types resolution was fixed for resultsets
  • PostgreSQL:
  • Full backup with roles and groups is now supported
  • View triggers DDL was added
  • Procedure debugger was fixed
  • Issue with URL-baes connections backup was resolved
  • Vector data types support was fixed
  • Aggregate functions DDL was fixed
  • Redshift: incorrect schemas info read in different databases was fixed
  • Snowflake:
  • Java 17 support has been added
  • Complex DDL statements parser was improved
  • SQL Server: procedures and functions rename was fixed
  • Vertica: comments read can e disabled for all metadata (for performance)

New in DBeaver 22.3.2 (Jan 9, 2023)

  • SQL editor:
  • Execution plain visualization was improved
  • Variables binding was fixed for query execution plan explain
  • SQL templates completion was fixed
  • Auto-completion of complex names was fixed (issue with missing schema name)
  • Hippie auto-completion was disabled for complex identifiers
  • Data editor:
  • Drop-down menu icon rendering was fixed
  • Filter panel ordering was fixed
  • Filter values save/restore was fixed
  • Column context menu was enhanced
  • Context menu now respects column in focus
  • Pinned columns scrolling was fixed
  • General UI: host info was fixed for URL-based connections
  • SSH: issue with host validation popup was fixed
  • Exasol:
  • Driver version was updated to 7.1.16
  • Connection encryption support was improved
  • MariaDB: json data type support was fixed
  • MS Access: identifiers quoting was fixed
  • Snowflake: SQL procedures parser was improved (IF statements support)
  • SAP HANA:
  • Schema create/delete/rename functions were added
  • Tables statistics read was added
  • Additional keywords highlighting was added
  • Case-sensitive schema names support was fixed
  • SQLite:
  • Utility tables (sqlite_autoindex_%) support was fixed
  • View DDL generator was fixed
  • Vertica: expired password change was implemented

New in DBeaver 22.3.1 (Dec 25, 2022)

  • Data editor:
  • Columns filtering/ordering menu was redesigned
  • Virtual key definition behavior was redesigned
  • SQL editor:
  • Script statistics visualization was fixed
  • NullPointer error during new script opening was fixed
  • Data transfer: variables resolve in saved tasks was fixed
  • Folders drag-n-drop was improved. Drop into root is now possible
  • Drag-n-drop from navigator window was fixed for GTK
  • Native SQL script execute wizard UI was improved
  • Debug log file rotation was added, solves problem with huge log files
  • Errors during driver files download are now handled properly
  • SSL certificates configuration on Windows was fixed
  • Proxy settings are saved between app installations (Windows installer)
  • Confirmation dialogs were redesigned
  • “Reset UI settings” and “Reset workspace” behavior was redesigned.
  • Tasks view now shows tooltips
  • Data export in SQL INSERT format now supports custom target table name configuration
  • Issue with columns visibility in metadata editor was resolved
  • Chinese localization was extended (thanks to @bianyun1981)
  • Eclipse plugin now supports the latest Eclipse IDE version
  • DBeaver base platform was changed to Eclipse 2022-12
  • AWS Athena driver version was upgraded
  • PostgreSQL:
  • SSL keys automatic conversion was added
  • Template databases duplication was fixed
  • Object dependencies read query was fixed
  • Azure SQL Server driver configuration was fixed (multi-factor authentication support)
  • MySQL NDB driver configuration was fixed
  • MySQL: user name quoting was fixed
  • Multiple minor UI bugs were fixed

New in DBeaver 22.3.0 (Dec 4, 2022)

  • Data editor:
  • Data export button UI was enhanced
  • Fetch all data and fetch size controls were returned to status bar
  • Lasso tool was added to spatial viewer
  • Bug in spatial viewer initialization was fixed
  • BLOB contents opening in external editor was fixed for MacOS and Linux
  • Browser-based image viewer control was fixed (null or invalid images handle)
  • SQL editor:
  • Big SQL files support was improved (automatic disablement of syntax validation)
  • Table auto-completion tooltips UI was redesigned
  • Error on unassociated script opening was fixed
  • General:
  • Default SSL truststore selection was fixed (it is now configurable)
  • Connection edit/create dialog performance was improved
  • Database server version is now shown in connections’ tooltip
  • Object delete dialog was redesigned
  • Database create button was removed from the connection dialog for databases which don’t support it
  • Security patch for packaged drivers (additional validation of zip archives was added)
  • SSH: tunnel invalidation was fixed for SSHJ
  • Tasks: problem with tasks operating with missing (deleted) tables was fixed
  • Clickhouse: identifiers quoting was fixed (for non ASCII characters)
  • Intersystems Cache: community driver was added again
  • MySQL:
  • Hyperlinks navigation was fixed for procedures
  • Complex identifiers quoting was fixed
  • Netezza: columns metadataread ws improved
  • PostgreSQL:
  • Role create/edit command was fixed
  • PostgreSQL 15 support was improved (new data type category)

New in DBeaver 22.2.5 (Nov 21, 2022)

  • Data editor:
  • Top and bottom action toolbars were redesigned
  • Action buttons now show hints
  • Data export toolbar button is now configurable
  • Image viewer was switched to embedded web-browser mode (configurable)
  • The issue with spatial data viewer was fixed (“no more handles” error)
  • Errors in virtual column definition now handled properly
  • “Count nulls” function was added to the Calc panel
  • SQL editor:
  • Auto-completion with TAB key was implemented (!)
  • Hyperlink navigation was fixed for quoted identifiers and identifiers with spaces
  • The issue with keyword case auto-conversion was solved
  • Editor tabs now shows connection state icon (connected/failed)
  • Client-side commands prefix configuration was fixed
  • The issue with cursor position change on mouse right-click was resolved
  • Data transfer: tables/column mapping dialog was improved, problems with target column name were fixed
  • Database drivers:
  • License information was added to the most drivers
  • It is no longer need to restart DBeaver after driver settings change (bug in recent versions)
  • Connections:
  • SSH jump servers support was added for SSHJ implementation
  • Network profile edit UI was fixed
  • Connection error messages
  • General UI:
  • Dark theme support was added to XML editor
  • Dialog font settings is now applied to most popup dialogs
  • Database navigator quick filter now supports composite identifiers (thanks to @plotn)
  • Clickhouse: driver version was updated, this resolves many issues with different data types support
  • Oracle: DATE data type rendering is now configurable
  • PostgreSQL: auth role editor was moved to the database level
  • SQL server: it is now possible to disable TOP clause in select queries

New in DBeaver 22.2.4 (Nov 6, 2022)

  • SQL editor:
  • SQL script active database/schema restore was fixed
  • Parameters prefix configuration was fixed
  • Issue with cursor change on context menu invocation was fixed
  • Option to disable all code completions/foldings was added
  • Auto completion inside SQL package was fixed
  • Table aliases auto-completion was fixed
  • SQL blocks auto-completion was fixed
  • SQL variables/parameters disable configuration was fixed
  • Data editor:
  • Table columns resolution was improved for custom SQL queries
  • Hidden columns restore was fixed
  • Data transfer:
  • Columns mapping dialog was redesigned and improved
  • Columns scale/precision mapping was fixed
  • Import from XML format was fixed
  • Multiple MFA attempts were resolved (in drivers with MFA authentication)
  • Tasks: variable value prompt was added (configurable)
  • SSH tunnels: issue with private key password prompt was fixed
  • RPM package: issue with remaining symlinks after uninstall was fixed
  • UI perspective customization was fixed
  • Clickhouse: driver version was updated (solves many data type conversion problems)
  • PostgreSQL: inherited roles support was added
  • Snowflake:
  • Java 17 support was added
  • Stored procedure and functions management was added
  • SQLite: table column delete was fixed

New in DBeaver 22.2.3 (Oct 24, 2022)

  • Data editor:
  • Value display format option was added to grid data view
  • Dictionary view panel now saves its ordering state
  • Row number in the record mode was fixed
  • Ability to open external editors for BLOB values was added
  • Database backup: variable ${schema} was added
  • SSH:
  • Problem with redundant password prompt was fixed
  • Tunnel config tab is now hidden for databases which don’t support SSH
  • Drivers:
  • Driver version auto-update feature added
  • Issue with driver download dialog was fixed (non-clickable dialog)
  • Driver license info button was added to the connection edit page
  • Data transfer:
  • Export to XLSX now support different modes for spreadsheet rows append
  • Description column was added to XLSX format (configurable)
  • An additional confirmation is shown if output file will be overwritten
  • Fallback directory was added for data export tasks
  • Tasks:
  • Tasks viewer now shows tasks only for the active project
  • New task create command enablement was fixed
  • Running tasks are now checked and confirmation is shown on DBeaver app shutdown
  • Additional logging was added for tasks execution
  • Clickhouse: SSL support was fixed
  • Greenplum: table list read was fixed for recent GP server versions 6+.
  • MariaDB: UUID data type support was fixed
  • MySQL/MariaDB: problem with grave accent quoting was fixed
  • Oracle: DATE data type rendering was fixed (time part was removed)
  • PostgreSQL:
  • Problem with result sets fetch was fixed (OutOfMemory on big results)
  • Driver version was updated to 42.5.0 (security update)
  • Issue with numeric fields formatting in struct types was fixed
  • OpenSearch driver configuration was added
  • General:
  • Multi-connections behavior configuration was improved. Possibility to forcibly disable or enable additional metadata or SQL editor connections was added.
  • Additional localization was done in many places of application
  • We switched to a new Eclipse platform version (2022-09)

New in DBeaver 22.2.2 (Oct 24, 2022)

  • Data editor:
  • “Hide all empty columns” action was added
  • References panel now has a button to open target table
  • Ordering by multiple columns was fixed
  • Filtering by spatial columns was fixed
  • URL transformer was fixed (original value edit is now supported)
  • LOB editor opening performance was significantly improved
  • SQL terminal now shows server output log
  • Column comments are now visible in record mode
  • Complex data types visualization was fixed for record mode
  • Data transfer: bug in CSV export with custom header format was fixed
  • SQL editor:
  • Problem with NULL column names in custom queries was fixed
  • Database drivers:
  • Problem with driver jars re-download was fixed
  • It is now possible to disable Windows certificate storage usage
  • Athena: driver version updated to 2.0.30
  • Clickhouse: datetime64 data type support was added
  • DB2: driver version was updated to 11.5.7
  • Exasol: user list read read was fixed (thanks to @allipatev)
  • Greenplum: prepared statements usage was disabled
  • MySQL:
  • Default database client was changed onto version 8+
  • JSON columns now can be used in filters and as keys
  • Oracle: schema full DDL was added
  • PostgreSQL:
  • Problem with missing primary key in new tables was fixed
  • Table DDL for partitioned tables was fixed
  • Role comments are now visible/editable
  • German localization was improved (thanks to @dan-schneider)

New in DBeaver 22.2.1 (Sep 26, 2022)

  • Data editor:
  • URL transformer was fixed (for edit mode)
  • Grouping panel behavior was fixed
  • BLOB/CLOB viewer now shows smart warnings
  • NullPointer error was fixed in spatial viewer
  • SQL editor: “Open in new tab” behavior was fixed
  • Connections:
  • URL-based configuration support was added to PostgreSQL, SQL Server and Generic drivers
  • SSH user name is now optional (current user name is used)
  • SSH: problems with credentials prompt were resolved
  • Data transfer: columns auto-mappings was improved (case-insensitive search)
  • Diagrams: association creation was fixed
  • Metadata editor: schema refresh performance was significantly increased
  • Eclipse plugin: a lot of DBeaver-related warnings in error log were resolved
  • i18n:
  • Chinese localization was improved (thanks to @fengchao)
  • German localization was improved (thanks to @bulldog98)
  • Apache Hive: default schema detection was implemented
  • Clickhouse:
  • SSL connection configuration support was added
  • UUID data type support was added
  • Greenplum: proper client app name is now sent to the server
  • MariaDB: problem with data transfer was fixed
  • PostgreSQL: box data type support was improved
  • SQL Server: problem with sequence value selection was fixed
  • Vertica: default driver upgraded to version 12
  • Many minor UI bugfixes

New in DBeaver 22.2.0 (Sep 5, 2022)

  • Data editor:
  • Embedded browser (Edge vs IE) configuration was added
  • Custom data types rendering in record mode was improved
  • Console viewer toggle was fixed on Linux/MAcOS
  • Arrays view/edit UI was improved
  • Multidimensional arrays support was fixed
  • Data transfer:
  • Column auto-mapping was fixed for databases with different identifiers case
  • Problem with old configuration load was fixed
  • Statistics calculation was fixed
  • SQL editor:
  • Query parser was fixed (issue with single line comments in select items)
  • Screen coloring by connection type was fixed
  • SSH:
  • SSHJ now is the default tunnel implementation
  • SSHJ version was upgraded, ASN1 decoder was added
  • Connection:
  • Issue with double authentication in web browser was resolved (all drivers with MFA auth)
  • Clickhouse:
  • Boolean data type support was added
  • Issue with timestamp data edit was resolved
  • Firebird: overloaded procedures loading issue was resolved
  • MS Access: diagram loading was fixed
  • Oracle: password expiration warning was added
  • PostgreSQL:
  • Extra options were added to explain plan dialog
  • Data type constraints loading was improved
  • Data type DDL generation was fixed

New in DBeaver 22.1.5 (Aug 21, 2022)

  • SQL editor:
  • Script to connection association problem was fixed
  • Data editor:
  • Major memory leak in data editor was fixed
  • Issue with grouping panel cleanup was resolved
  • Hex editor now respects read-only status of columns
  • Find/replace dialog now respects focused control
  • General:
  • Issue with connection configuration load and edit was fixed
  • Dialog buttons layout was fixed in different dialogs
  • Authentication profiles configuration UI was fixed
  • SQL Server:
  • View definition read was fixed for Azure databases
  • Nvarchar/nchar column length detection was fixed
  • MySQL:
  • Issue with numeric schema names was fixed
  • Oracle:
  • Trigger DDL was fixed (CREATE keyword)
  • Data type DDL generation was fixed
  • PostgreSQL:
  • Filters for composite data types were fixed

New in DBeaver 22.1.4 (Aug 8, 2022)

  • Data editor:
  • Dangerous operation detector was improved (delete … returning)
  • Export of sorted rows was fixed
  • Status messages formatting and UI were improved
  • Filter by enum value was fixed
  • Collection editor was improved (UI in value panel)
  • Problem with statistics tab open was fixed
  • Console view:
  • Non-SELECT queries support was added
  • Errors messages are now printed in console
  • Driver editor: possibility to set property value to NULL was added
  • SQL formatting settings save and preview was fixed
  • Data transfer: task settings loading was fixed
  • Azure SQL Server, Babelfish: multiple databases support was redesigned
  • Clickhouse:
  • Table list load was fixed for older server versions
  • Data type mapping was improved for cross-database data transfer
  • Multirow insert support was added
  • 64-bit integers support was fixed
  • H2: table metadata and DDL read was fixed
  • PostgreSQL, CocroachDB:
  • Row security policy support was added
  • PgPass authentication now support SSH hosts and host redefine
  • Routines privileges DDL was fixed
  • General UI:
  • Default embedded browser was changed to Microsoft Edge
  • Properties editor: value save on focus change was fixed
  • Tip of the day dialog layout was fixed (thanks to @troizet)
  • Many minor UI bugs were fixed

New in DBeaver 22.1.3 (Jul 25, 2022)

  • SQL editor:
  • Autocomplete of variables with prefix @ was fixed
  • Problem with columns aliases in grouping panel was resolved
  • SQL console text now can be saved as project script
  • Data editor:
  • Collection string representation was improved
  • Problem with data read performance was fixed
  • Data transfer:
  • Target table properties (such as engine, charset, etc) were added in import wizard
  • CSV import was fixed for files with invalid value quotation
  • Import from string to geometry columns was fixed
  • Issue in full text search wizard (NullPointer) was resolved
  • General UI: tab quick search was improved (find by substring, fuzzy search)
  • Connections: multiple connection mode was disabled for non-relational databases
  • Azure SQL: driver version was upgraded, problem with auth token refresh was resolved
  • Clickhouse:
  • Table engine and engine parameters (editable) were added to table properties
  • View code editor was fixed
  • DB2: dependent views can be excluded from table DDL
  • Oracle:
  • DDL tab was added tp scheduler jobs
  • New table column properties was fixed
  • Issue with Debian installer was resolved (configuration files mark removed)

New in DBeaver 22.1.2 (Jul 10, 2022)

  • Data editor:
  • Arrays and structure data types visualization was fixed and improved
  • Console-like query results viewer was added
  • Support of column aliases in aggregate panel was fixed
  • Dictionary panel now supports pagination
  • Pinned columns scrolling was fixed (thanks to @troizet)
  • Binary/hex data viewer was fixed (crash on MacOS)
  • Major memory leaks in string editor panel were eliminated
  • SQL editor:
  • Parameters binding for DDL queries was fixed
  • Query error highlighting was improved (+now it can be disabled)
  • Query formatter was fixed (for identifiers starting from digit)
  • Compact formatter was improved
  • Issue with auto-completion of materialized view create/alter queries was fixed
  • Data transfer:
  • Target file name generation for custom SQL queries was fixed
  • Settings save/load was fixed for saved tasks
  • General improvements:
  • Dummy error messages after saving preferences were eliminated
  • UI was improved for non-applicable columns in metadata editor
  • Issue with main window minimize was fixed on MacOS
  • Many minor ui bugs were fixed
  • Clickhouse: issue with data editor was fixed
  • CocroachDB: sequences support was added
  • H2: schema sequences read was fixed
  • Hive: view source editor was fixed (issue with semicolon)
  • Kylin: dialect support was improved
  • MySQL, MariaDB: privilege editor UI was improved
  • Oracle: VARCHAR2 is now the default string data type
  • PostgreSQL: database refresh was fixed (issue with active schema mark)
  • Snowflake: issue with BEGIN TRANSACTION query execute was fixed
  • SQL Server:
  • Table DDL: issue with duplicated index declaration was fixed
  • Issue with GO delimiter evaluation was fixed (also for Sybase)
  • Database name proposal was fixed
  • Execution plan visualization was fixed

New in DBeaver 22.1.1 (Jun 27, 2022)

  • Connections: new connection name pattern now can be customized
  • SSH configuration page now has scrollbars on small monitors
  • Database full text search: page UI was improved, long lists paging was added
  • Metadata editor: columns auto-size command was added to the context menu
  • General UI: project configuration load visualization was added
  • Clickhouse: enum data types support was added
  • Derby: default driver version was set to 10.15 (to avoid Java version problems)
  • SQLite: view text edit support was added
  • Trino: multi-row insert support was added
  • Data viewer:
  • Arrays and multi-row data types visualization was added (beta version)
  • Excel like behavior for inline editor was added (shift row down, configurable)
  • Bug in grouping panel was fixed (“duplicates only” option)
  • Inconsistency of NULL value representation in calendar edit control was fixed
  • Bug with inline editor activation with double-click was fixed (gtk)
  • Data transfer:
  • Export with “selected columns only” was fixed (wrong column mapping)
  • Target DDL generator now checks for existing non-table objects
  • Export in SQL INSERT format now uses proper table name for complex custom tables
  • Header configuration for CSV and TXT formats was added
  • Problem with super-long CSV files import was fixed (row number visualization)
  • SQL editor:
  • Generate DDL from resultset command was added
  • Re-execute queries from execution log was supported
  • Schema selector was fixed for databases which don’t support schema change (Sybase, SQL Server)
  • Tasks:
  • Nested task folders support was added
  • Folders rename support was added
  • SQL script execute task was fixed (NullPointer error)
  • Netezza:
  • Default catalog selection was fixed
  • Old drivers support was added
  • PostgreSQL:
  • Constraints information pre-read option was added
  • Enum columns edit support was fixed
  • Representation of arrays with NULL elements was fixed
  • SQL Server:
  • DDL for nchar and nvarchar columns was fixed (incorrect length)
  • Columns with aliases now can be edited

New in DBeaver 22.1.0 (Jun 5, 2022)

  • General UI:
  • Local timezone configuration was added in preferences
  • Connection type color now affects SQL editor panels
  • Tab selector (CTRL+E) now supports fast/fuzzy search
  • Project rename now updates project name in all linked views
  • Problem with navigator tree refresh was resolved
  • Preference pages now respects font configuration
  • Configuration popup positioning was fixed for low-res monitors
  • Problem with embedded dropdown editors was resolved (MacOS)
  • Problem with application start on some MacOS and Linux installations was fixed
  • Read-only connections toggle was redesigned
  • “Copy object name” action was added to tab context menu
  • Data editor:
  • Color by range now supports foreground color customization
  • Problem with clob/json popup editors was resolved
  • Epoch time transformer now supports 4 more modes (thanks to @nodaki)
  • Grouping panel: problem with GROUP BY query generation was fixed for many analytical databases
  • Date/time inline editor UI was improved (thanks to @PILINING)
  • SQL editor:
  • Right click on a script text now changes cursor position
  • Part divider element visualization was improved
  • Confirmation was added for “Delete this script” action
  • Dangerous query execution confirmation configuration was fixed
  • DB2: procedure name auto-completion was fixed
  • HANA: procedures output parameters fetch was fixed
  • Netezza: case-sensitive user names support was added
  • Snowflake: database metadata read performance was significantly improved
  • Teradata: SQL query limit (TOP) support was added
  • Many minor UI bugfixes
  • New database driver: Apache Kyuubi

New in DBeaver 22.0.5 (May 23, 2022)

  • Italian localization was improved (thanks to @andreagualandi)
  • Chinese localization was improved (thanks to @bianyun1981)
  • Data editor:
  • Numbers formatting: digit group size option was added
  • Problem with unexpected change of timestamp values was fixed
  • Smooth scrolling on MacOS was improved (thanks to @Andrew0002)
  • Data transfer: XML format export was improved (encoding information)
  • SQL editor:
  • Results tab reuse behavior was fixed + new config option was added
  • Result logging was added for script execute task (thanks to @avandorp)
  • Redundant “Problems” view popup was removed
  • Keywords highlighting was fixed (problem with identifiers which start with underscore)
  • Diagrams:
  • Connected entities highlighting was added
  • Entities and columns search was improved
  • New diagram routing was added
  • Problem with unreadable comments was fixed (dark theme)
  • Export in SVG and Graphml formats was improved
  • Pseudo columns were removed from diagrams
  • Diagram re-arrange was fixed
  • Many minor bugs were fixed
  • Connections:
  • Creating connection from JDBC URL was improved
  • Opening connection using CLI was improved (extra option -save was added)
  • Preference pages: problem with small font size ws resolved
  • PostgreSQL:
  • SSPI authentication support was added (problem with JNA library conflicts was resolved)
  • Read-only connections support was improved (restrict of DML queries)
  • Scheduled jobs management was added
  • SQL Server:
  • External tables metadata read was fixed
  • NTLM authentication support was fixed

New in DBeaver 22.0.4 (May 1, 2022)

  • SQL editor:
  • Problem with semicolon on a new line was fixed
  • Problem with client-side commands parsing was fixed
  • Error highlighting support was improved
  • Tabs close/confirmation behavior was improved
  • Script with multiple @set commands processing was fixed
  • Command for data export automation was added (@export)
  • Toggle comment command was fixed (thanks to @arvillion)
  • SQL script datasource association command was fixed
  • Data editor:
  • Value filter now shows total number of distinct values
  • Search for whole word was fixed
  • Custom filter value save was fixed
  • Spatial viewer:
  • Ability to select spatial objects on map and data grid was added
  • Default zoom level option was added
  • Data transfer:
  • Default data type mapping was improved (especially for char/varchar columns)
  • Multi-table transfer now opens all target tables
  • Database restore task now requires additional confirmation
  • Output folder parameter now supports additional variables
  • Import task UI was fixed (problem with lost target tables configuration)
  • SQL export format now supports append mode
  • Navigator: database selector popup was fixed (null pointer error)
  • SSH: problem with connections and corrupted known_hosts file was resolved
  • CLI: parameter “create” was fixed for connection opened using -con parameter
  • Windows: DBeaver now supports workspaces on network paths (e.g. \network-shareworkspace)
  • MacOS: problem with UI freeze after data edit was fixed
  • DB2 i: keys and foreign keys metadata read was fixed
  • MySQL:
  • Generate SQL for geometry data types was fixed
  • Permission editor was fixed (problem with duplicated permissions)
  • Problem with decimal data types with zerofill flag was fixed
  • UPDATE SET replace method was added
  • Netezza: table rename SQL was fixed
  • Oracle: table partition metadata read was fixed
  • PostgreSQL:
  • Problem with SQL generation and JSONB columns was fixed
  • View column edit support was added
  • Default driver version was changed to 42.2.25 due to security reasons
  • SQLite: connection settings dialog UI was fixed (Open and Create buttons behavior)
  • SQL Server:
  • Money data type support was fixed
  • Connection settings dialog was redesigned
  • A lot of minor fixes in application localization

New in DBeaver 22.0.3 (Apr 18, 2022)

  • Data transfer:
  • “Append to existing file” feature was improved (for CSV, TXT and XLSX formats)
  • Export wizard now loads saved properties on demand
  • Export of result set with reordered/hidden columns was fixed
  • Export in SQL format: “split on multiple files” now works correctly
  • Task execution notification was improved
  • SQL script tasks support was fixed (NullPointer error was resolved)
  • Export of many tables into a single target table was fixed
  • Import from CSV was fixed (problem with null handling was resolved)
  • Trim whitespaces option was added for CSV import
  • Table columns mapping UI was fixed on MacOS
  • SQL editor:
  • Error position information was added in error messages
  • Query error highlighting was improved
  • Database navigator:
  • Support of databases with bug number of schemas was improved
  • Column grouping now shows number of grouped elements
  • Auto-completion was improved in properties editor
  • General:
  • DBeaver now shows EULA on start (one time)
  • Problem with workspaces on network paths was resolved
  • Kerberos configuration load was fixed on RHEL
  • Apache Phoenix: connectivity problem was fixed by setting proper driver version
  • CockroachDB: ROWID columns support was added
  • DB2 i:
  • Sequences support was added
  • View definitions read was implemented
  • Unique and check constraints support was added
  • Multiple minor improvements in metadata read were added
  • Exasol: search in view/procedure source code was implemented
  • MySQL: problem with table lock during database dump was fixed
  • Oracle: View source code edit was fixed (problem with view comments was resolved)
  • PostgreSQL:
  • pg_dump and pg_restore version was upgraded (to PG 14)
  • Script execute task now shows all script errors
  • Snowflake: support of LIMIT for custom SQL queries was added (affects performance)
  • Italian localization was significantly improved (thanks to @capitanfuturo)

New in DBeaver 22.0.2 (Apr 4, 2022)

  • Data editor:
  • Option “show whitespaces” was added
  • Columns reordering in data filter dialog was fixed
  • Line numbers were added to plaintext view
  • SQL editor:
  • Script error visualization is not configurable
  • Block statements (BEGIN, IF, CASE) auto-close was improved
  • Auto-completion was fixed for INSERT queries
  • “Cancel active query” command was added
  • Filtering of aliased columns was fixed
  • Problem with DML queries re-execution on connection lost was fixed
  • Python source code format was added to Copy As command
  • “Hippie” auto-completion was disabled by default (due to performance problems)
  • SQL commands parser/navigation was fixed (thanks to @arvillion)
  • Parameter bindings dialog was disabled for long strings (like $$)
  • CASE/WHEN formatting was fixed
  • Driver editor:
  • Driver description editor was fixed
  • Maven artifacts version resolution was improved
  • Data transfer: recreate table mapping support was fixed (saved configuration and tasks)
  • SSH tunnels: connection timeout/keep-alive parameters change was fixed
  • MacOS: problem with application launch was fixed (problem with plist file modification)
  • Dark theme: buttons UI now matches OS theme
  • Apache Druid, Apache Kylin:
  • Table data read was fixed
  • Data type properties were fixed
  • Indexes read was fixed
  • Azure Databricks driver was added
  • Clickhouse: array data type editor was implemented
  • DB2: query terminator redefine support was added
  • H2:
  • System views DDL generation was fixed
  • Geometry data type rendering in new H2 driver was fixed (thanks to @ebocher)
  • MySQL: functions execute was fixed
  • PostgreSQL:
  • Nested arrays editor was implemented
  • Functions source code generation was fixed (function signature)
  • Portuguese localization was fixed (thanks to @TiagoValdrich)

New in DBeaver 22.0.1 (Mar 20, 2022)

  • Navigator:
  • Connection read-only state switcher was added in main toolbar/menu
  • Data editor:
  • Auto-refresh UI was fixed (stop on error visualization)
  • Array data types handling was improved (PostgreSQL, Clickhouse)
  • Invalid fractional seconds rendering was fixed
  • Filter panel is removed in non applicable presentations
  • Number of selected rows calculation was fixed
  • Row colors reset option was added
  • Edit controls enable state was fixed for plaintext view
  • Keyboard shortcuts were fixed in inline date/time editor
  • Next segment auto fetch was fixed for specific queries
  • Data transfer:
  • "Ignore duplicated rows” option was added
  • Table mapping “re-create” support was improved
  • Skipped columns configuration save was fixed
  • SQL editor:
  • Data filter injection for custom SQL queries was improved
  • Transaction monitor was fixed (amount of statements in a transaction)
  • Tasks: task ordering was fixed (folders on top)
  • Command line: possibility to specify external variables file was added
  • MySQL: indexes edit support was added
  • Oracle:
  • Sequences DDL tab was added
  • Scheduler jobs metadata read was fixed
  • Arrays presentation was improved (numbers formatting was fixed)
  • Materialized view save was fixed PostgreSQL:
  • View source editor was fixed (redundant ‘create or replace’ clause was removed)
  • Template databases are now visible is specified in connection settings
  • Server version < 8 support was improved
  • Saved backup/restore tasks UI was fixed
  • Redshift:
  • Search in procedure definition was fixed
  • Vertica:
  • Metadata performance was significantly improved
  • Table/column comments are now read in lazy mode

New in DBeaver 22.0.0 (Mar 7, 2022)

  • Data transfer:
  • Table recreate mapping type was added
  • Table selector dialog now supports filters configuration
  • Variables configuration for data transfer tasks was fixed
  • Variables auto-complete was fixed in output file name
  • Custom data formatting now applied for TXT export format
  • Insert statement now supports DEFAULT clause for empty list of columns
  • Data editor:
  • Row count calculation query was fixed
  • Rows scrolling was disabled for data modifying queries
  • Problem with editor focus after new row add was fixed
  • Column value filter was fixed (wrong SQL query)
  • SQL editor:
  • Parameters binding dialog was improved (multiline editor was added, keyboard shortcuts were fixed)
  • Filtering and ordering by columns with aliases was fixed
  • Problem with cursor jump to script end was fixed
  • Script selector popup was fixed (issue with datasource association)
  • Script task execute was fixed (for connections without default database)
  • DDL generator: option to generate FKs as separate statements was added
  • Metadata search: search by LIKE pattern was fixed
  • Session manager UI was fixed (multiline cells on Linux, background color for connection type)
  • Interface language now can be changed in preferences (for MacOS and Linux installers)
  • SSH: option to disable host name validation was added
  • Local clients configuration load was fixed (MySQL and PostgreSQL derived drivers)
  • Azure SQL server: view definition read was fixed
  • Clickhouse: read-only connections support was improved
  • H2:
  • Driver configuration for version 2.x was added
  • Check constraints support was added
  • Unique keys support was added
  • MySQL: new view creation was fixed (DDL)
  • Oracle:
  • Metadata read performance was significantly increased
  • Case-sensitive navigator filters support was fixed
  • Snowflake: custom authentication configuration option was fixed
  • SQLite: sequences read was fixed
  • SQL Server: open database object dialog now respects selected database
  • Italian localization was improved (thanks to @capitanfuturo)
  • Many minor UI bugs were fixed

New in DBeaver 21.3.5 (Feb 21, 2022)

  • SQL editor:
  • Problems with app freeze on very complex queries executing was fixed
  • Parameters binding dialog now supports multiline editor
  • Script selector panel UI was fixed
  • New scripts now position cursor to the end of script
  • Data editor:
  • Columns drag-n-drop support was fixed (Linux)
  • Dictionary table editor now supports default column names customization
  • Connection-specific data formatting settings save was fixed
  • Metadata editor:
  • Table DDL is now auto-updated after new table editing
  • Navigator:
  • Bug with connection element expansion during connect was fixed
  • Table statistics refresh was fixed
  • Columns configuration (visibility, size, order) save/load was improved
  • “Expand on connect” now expands both database and schema
  • Column reordering now supports multiple columns
  • SSH: known_hosts support and validation of target host before connect were added
  • Various database tools: NullPointer error in task wizard was fixed
  • Data transfer: table re-create option was added
  • Clickhouse: problem with access to read-only connections was fixed
  • Firebird: columns autoincrement option editor was added
  • Generic driver: ClassCast error during connection instantiation was fixed
  • PostgreSQL:
  • Event triggers support was added
  • Greenplum, EDB: local clients configuration was added
  • Google Cloud driver support was fixed (driver dependencies)
  • Functions signature now include out parameters
  • GIS viewer for columns in complex data types ws fixed
  • CIDR data type support was added
  • Deferrable foreign keys create was fixed
  • SQL Server Synapse support was improved (metadata reading)
  • Trino: problem with corrupted navigator tree after long connect was fixed
  • New drivers: Denodo driver configuration was added (thanks to @scruz-denodo)

New in DBeaver 21.3.4 (Feb 6, 2022)

  • Data editor:
  • Row fetch size now can be set to a small value (up to 1 row)
  • Search in data grid with enabled numbers formatting now works properly
  • Date/time editor calendar presentation now shows proper error messages
  • Data loss on resultset scrolling confirmation was added
  • Option to highlight selected cell value was added
  • Value view panel now supports shortcuts to switch between data formats (configurable)
  • SQL editor:
  • Bug with missing resultset tab focus was fixed
  • Script selector panel now supports “All connections” mode
  • Data transfer:
  • Export of columns of composite data types support was added
  • Popup message boxes were replaced with task bar notifications
  • Navigator tree: database object comments render was added (configurable)
  • BLOB/binary editor: problem with changes saving in hex editor was fixed
  • Dashboard view: problem with memory leaks was resolved
  • Auto-close of idle connections option was added (configurable)
  • Driver editor: Maven artifacts settings save/load was fixed
  • Bug with empty editor tabs after restart was fixed
  • Redundant logging during connection context menu opening was fixed
  • New database drivers:
  • Apache Calcite Avatica
  • Apache Druid
  • Apache Kylin
  • Clickhouse:
  • New driver was added. Old driver was renamed to Legacy.
  • LIMIT clause support was added for data read queries
  • Exasol: execution plan save/load was implemented
  • MySQL/MariaDB: permission editor was redesigned, grant option support was fixed
  • MariaDB:
  • New driver (3.x) support was added
  • Packages and sequences support was added
  • Oracle:
  • Table constraints load performance was significantly increased (thanks to @skybber)
  • PL/SQL syntax support was improved (packages and procedures parser was fixed)
  • WITH clause parser was improved
  • PostgreSQL:
  • Identifiers quoting was added for table DDL
  • Database backup now supports “drop if exists” option
  • Row replace method “ON CONFLICT DO UPDATE” support was fixed
  • Redshift:
  • New view create was fixed
  • Driver version was updated to 2.1
  • Generic driver now support sequences and synonyms edit/rename
  • Japanese localization was improved (thanks to @yoshinorin)
  • Several minor UI bugs were fixed

New in DBeaver 21.3.3 (Jan 24, 2022)

  • Data editor:
  • Date/time editor now supports calendar-like UI
  • Column names quoting was fixed in filter clauses
  • Filter for array columns was fixed
  • Gis viewer: SRID switch behavior was fixed
  • Save/cancel button are now disabled during data save process
  • Column filter now uses exact match for numeric values
  • Status message now shows execute timestamp
  • Advanced copy now respects quoted column names
  • SQL Editor:
  • Multiple result tabs refresh was fixed
  • Import file now supports multiple files selection
  • Client-side commands (@set, @include) parser was fixed
  • Auto-completion fix for SELECT .. INTO queries
  • Auto-completion now uses “hippie” completion algorithm by default
  • Copy as source code: Delphi format was fixed
  • “Copy selected query” command was added
  • Variables and parameters deletion was improved
  • SQL formatting was fixed (redundant empty lines eliminated)
  • Tab context menu was improved (additional items were added)
  • Code folding restore was fixed
  • Multi-cursor edit mode was added
  • Data transfer:
  • XLSX import was improved (problem with column mapping was fixed)
  • Import from CSV now uses approximate column length calculation
  • Append to file mode was fixed
  • Navigator: tree state loading was fixed
  • SSH tunnel:
  • Advanced tunnel configuration UI was improved (window auto-resize)
  • Tunnel test dialog now supports test interruption
  • Private key configuration was fixed for jump servers
  • Task execute status now shows more detailed information
  • Eclipse plugin: history navigation shortcuts support was fixed
  • MacOS: application termination on detached window close was fixed
  • Localizations:
  • Simplified Chinese localization was significantly updated (thanks to @bianyun1981)
  • Italian localization was updated (thanks to @capitanfuturo)
  • Japanese localization was fixed and updated (thanks to @yoshinorin)
  • Oracle: native quoting parser was fixed
  • PostgreSQL:
  • Error (NullPointerException) in explain execution plan was fixed
  • Role DDL was fixed (connection limit)
  • SAP HANA: hyperlink navigation ws fixed
  • SQL Server: Database metadata read fix (problem with is_external column)

New in DBeaver 21.3.2 (Dec 26, 2021)

  • Files drag-n-drop (between DBeaver and OS file explorer) support was added in the project explorer
  • SQL editor: “hippie” auto-completion support was added (beta)
  • SSHJ implementation now included in DBeaver Community by default
  • Problem with DBeaver crash was fixed (when workspace path contains spaces)
  • Session manager: column grouping was added
  • Command line support: default connection now set for opened SQL scripts
  • SalesForce driver was added
  • AWS Athena: driver version was updated, problem with column filters was resolved
  • Clickhouse: typed arrays support was added
  • Derby: check constraints support for remote server driver was fixed
  • SAP HANA: public schema presentation was changed (thanks to @kai-morich)
  • SQL Server: external tables support was added
  • Data editor:
  • Auto-completion was fixed in filters panel
  • XML auto-format was fixed (elements sort was disabled)
  • Filter by column with alias was fixed
  • Numeric type transformer was fixed
  • Extra tab close action were added (close to the left/right)
  • Arrays presentation in record view was fixed
  • Driver management:
  • New Java11 modules were added to support new JDBC drivers (java.net.http)
  • Drivers copying was fixed (keep advanced driver settings)
  • Maven artifacts edit dialog was fixed
  • Data transfer:
  • CSV parser performance was significantly improved
  • Identifiers case configuration was added in SQL export format
  • Option to append results to an existing file was added
  • Date formatting was fixed for JSON format
  • Variables support in saved tasks was fixed
  • Support of arrays import from CSV was added
  • Problem with export wizard buttons enablement was fixed
  • Babelfish:
  • Synonyms, sequences and triggers were removed from metadata navigator
  • Cross-database access was disabled, only default database is visible

New in DBeaver 21.3.1 (Dec 12, 2021)

  • SQL editor:
  • Auto-completion for tables without alias was fixed
  • Script file name template support was added
  • Data editor: column filters edit dialog UI was improved
  • Resource manager: cross-project connection drag-n-drop was fixed
  • Task manager: task statistics read was fixed
  • SQL query generator: string values quotation was fixed
  • Driver manager: Maven artifacts import/edit UI was improved
  • Connection lock password support was fixed
  • Navigator:
  • Object filters now support backslash escape
  • Multiple minor UI bugs were fixed
  • DB2: table organization property was added
  • PostgreSQL, Greenplum, Redshift:
  • Permission editor UI was fixed (redundant GRANT/REVOKE commands merge)
  • Composite data types support was fixed
  • Execution plan rendering was fixed (“Parallel” scan)
  • Partition tables statistics read was fixed
  • SQL Server: column data type modifiers generator was fixed
  • SQLite: table foreign keys editor was added

New in DBeaver 21.3.0 (Nov 28, 2021)

  • Data viewer:
  • Filters configuration dialog UI was fixed (MacOS)
  • Found occurrences highlighting was fixed (find/replace)
  • Problem with long columns resize was fixed
  • Problem with overlapping column icons was fixed
  • Diagram viewer: connections auto-layout was fixed
  • Problem with SQL script preview dialog was fixed on MacOS
  • Error “PKIX path building failed” was fixed on Windows (OS certificate storage is now the default)
  • Dark theme: bug with mismatching colors was fixed on MacOS
  • Problem with missing file extensions was fixed (Windows)
  • Metadata editor: editor flickering after mode change was fixed
  • Full-text search now keeps original table filters
  • Currupted projects auto-recovery feature was added
  • Legacy error/warning icons were replaced with new ones
  • Version auto-upgrade:
  • Incorrect package type detection was fixed
  • Incorrect architecture (M1/ARM/x86) detection was fixed
  • Driver editor:
  • URL template edit support was added for all drivers
  • Maven artifacts import/edit UI was improved
  • SSH tunnel test: system variables support was added
  • New database drivers:
  • Babelfish driver was added (thanks to @okeuday)
  • OceanBase driver was added (thanks to @LuckyLeoZZ)
  • Greenplum: permission editor was fixed for older GP versions
  • MySQL/MariaDB/PostgreSQL: backup/restore tasks create wizard was fixed (NPE)
  • ODBC: app crash on editor open was fixed
  • PostgreSQL:
  • Database structure was redesigned (all cluster-level entities moved to the top level)
  • Multirange data types support was added
  • Exclusive schema filters support was fixed
  • Support of JSON columns in unique keys was added
  • SQLite: table indexes create/delete support was added
  • SQL Server: auto-completion and hyperlinks were fixed in stored procedures

New in DBeaver 21.2.5 (Nov 15, 2021)

  • Data editor:
  • Spatial viewer now saves proper SRID for tables and columns
  • Find/replace for BLOB/CLOB columns was fixed
  • Metadata editor:
  • Navigator refresh was fixed
  • Schema-level index create was fixed
  • ERD editor: columns search was implemented
  • SQL editor:
  • Files copy into new project was fixed
  • Backup/restore wizard UI was fixed (MySQL and PostgreSQL)
  • Task wizard buttons enable/disable was fixed
  • SQLite: driver updated to version 3.36
  • Greenplum/Redshift: session and lock managers were added
  • MariaDB/MySQL: tables metadata load performance was improved
  • Oracle:
  • Full-text search for functions and procedures was implemented
  • Option “show only current schema objects” was implemented
  • PostgreSQL:
  • Foreign key settings edit was implemented
  • Array value parser was fixed
  • Roles names quote was fixed in grant/revoke commands
  • Snowflake: driver version was updated (fixes problems with MFA)

New in DBeaver 21.2.4 (Nov 1, 2021)

  • Task management UI was redesigned for data transfer, admin tasks and SQL tasks
  • CockroachDB: query results limit was added
  • CSV, Athena: database metadata is now read-only
  • Redshift: geometry edit support was added
  • Snowflake: driver version is now hardcoded (to avoid problems with MFA authentication)
  • SQL Server: auto-completion for synonyms was added
  • Sybase: database statistics info was added
  • Data transfer:
  • Bulk load (COPY) support was added for PostgreSQL
  • Cross-database data type mapping was improved for PostgreSQL, Oracle and Sybase
  • Additional variables were added for file name patterns (${year}, ${month}, ${day}, etc)
  • Several fixes in data transfer wizard
  • Data editor:
  • Geometry values copy-paste operation was fixed
  • Gis viewer: object tooltips were fixed
  • Problem with invalid SRID was resolved
  • Copy from row above/below command was added
  • JSON function were added to virtual columns definition
  • Image viewer flickering was fixed
  • Row count calculation was fixed (bug with distinct select)
  • Composite data types support was fixed (arrays of composite type)
  • SQL editor:
  • New script template was added (configurable)
  • Tooltip for execution plan explain tab was fixed
  • Shared jar libraries confioguration was added
  • Navigator:
  • Quick filter value is now saved between application starts
  • Command line handler was fixed (problem with -reuseWorkspace)
  • Boolean editor UI was fixed (trimmed labels)
  • UI freeze during metadata editors re-open was fixed
  • Clickhouse:
  • Table statistics read was fixed (thanks to @den-crane)
  • SQL dialect definition was improved (extra keywords)

New in DBeaver 21.2.3 (Oct 17, 2021)

  • 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

New in DBeaver 21.2.2 (Oct 3, 2021)

  • 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

New in DBeaver 21.2.1 (Sep 20, 2021)

  • 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
  • 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
  • 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)
  • 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)
  • Metadata search:
  • Search in object comments configurator was fixed
  • Search page was fixed for cross-database search PostgreSQL
  • 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

New in DBeaver 21.2.0 (Aug 30, 2021)

  • 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

New in DBeaver 21.1.5 (Aug 16, 2021)

  • SQL editor: action buttons tooltips were fixed (keyboard shortcuts)
  • SQL Server: user management was added
  • Oracle: View triggers read 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
  • 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)
  • PostgreSQL:
  • Additional PostGIS data type support was added
  • Connection user role handle was fixed

New in DBeaver 21.1.4 (Aug 2, 2021)

  • 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

New in DBeaver 21.1.3 (Jul 19, 2021)

  • 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

New in DBeaver 21.1.2 (Jul 5, 2021)

  • 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

New in DBeaver 21.1.1 (Jun 21, 2021)

  • Data export: special characters escape was fixed in HTML and JSON formats
  • Greenplum: materialized views DDL was fixed
  • MySQL: foreign key edit support was added
  • Teradata: triggers and procedures DDL was fixed (extra linefeeds were removed)
  • Taiwan localization was added (thanks to @ralic)
  • Test connection dialog now shows connection detailed information
  • Last workspace location is now restored after DBeaver version upgrade
  • Redundant P2 plugins were removed from the standalone version
  • TLS 1.0 and TLS 1.1 support configuration was fixed
  • Navigator:
  • 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
  • Data editor:
  • 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
  • SQL editor:
  • 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
  • Oracle:
  • 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
  • PostgreSQL:
  • 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
  • Redshift:
  • Permission editor was added
  • Problem with case-sensitive object names was fixed
  • SQL Server:
  • Cross-schema foreign keys support was fixed
  • Detailed triggers metadata read was added

New in DBeaver 21.1.0 (May 31, 2021)

  • Connection recovery was improved. SSH tunnel infinite reopening cycle was fixed
  • Project settings: corrupted folders configuration fix was added
  • Legacy status icons were updated
  • Application launch time was reduced
  • Data editor: LOB viewer shows error dialog on data load errors now
  • CLI: reuseWorkspace parameter handler was fixed
  • Oracle: synonyms search is now configurable
  • MySQL: user rename feature was added
  • Exasol: schema refresh 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
  • Data transfer:
  • Insert/replace method configuration was fixed
  • Cross-database column data type mapping was improved
  • SQL Editor:
  • Problem with results tab collapse was fixed
  • Dummy NullPointerException and StackOverflowError errors were fixed
  • SQL Server:
  • Extended properties editor was added
  • New row insert for tables with calculated columns was fixed
  • 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
  • Informix:
  • Table statistics feature was added
  • Function parameters read was fixed

New in DBeaver 21.0.5 (May 17, 2021)

  • Navigator:
  • Boolean properties editor behavior was redesigned
  • Broken shortcuts (F2, F4, etc) in object editor were fixed
  • Redundant help icons removed from standard dialogs
  • Language change validation and documentation was added
  • Quick filter now supports triggers
  • SQL Editor:
  • Auto-completion was fixed for table aliases, joins and asterisks
  • Smart commit now ignores EXPLAIN statements
  • Big updated row count (>2gb) support was added
  • Output log enable/disable button was added
  • Data editor:
  • Selected rows highlight was fixed
  • Bug with overlapping timestamp and FK values was fixed
  • Find/replace dialog now respects number formatting
  • ERD viewer: property view support was fixed, entity/attributes context menu was fixed
  • PostgreSQL:
  • Constraints and indexes support was added
  • Problem with constantly growing search_path was fixed
  • Fully-qualified table names in foreign keys DDL was fixed
  • PGPASS authentication now can be used with empty user name
  • NaN and Infinity numbers formatting was fixed
  • Data transfer: ON DUPLICATE query generation was fixed
  • Database size statistics was added (configurable, off by default)
  • CREATE DOMAIN DDL was fixed
  • DB2: BEGIN/END blocks support was added
  • Greenplum: DDL for replicated tables was fixed
  • Oracle:
  • Procedure body formattign was fixed (for encoded procedures)
  • Procedures/triggers/packages DDL statements processing was fixed
  • Redshift: view columns metadata read was fixed, extra data type aliases were added
  • Vertica:
  • Table columns read was fixed for older Vertica versions
  • Sequences support was added
  • BigQuery driver version was upgraded
  • Eclipse plugin: bug with redundant .dbeaver folders was fixed
  • System notifications support was added on Linux
  • Jar code sign certificate was updated
  • Big number of minor bigfixes

New in DBeaver 21.0.4 (May 3, 2021)

  • Navigator:
  • Database statistics in simple mode was fixed
  • Legacy search icons were updated
  • Legacy edit toolbar and main toolbar items was removed
  • Columns reorder now supports multiple columns
  • Object lookup function now supports search in comments
  • DBeaver main menus are visible in DBeaver perspective only
  • SQL editor:
  • Collapsed results panel expand was fixed
  • Data editor:
  • Find/replace dialog was improved
  • Virtual unique key create dialog was redesigned
  • References panel was fixed for custom SQL queries
  • SSH:
  • SSH Agent support was fixed
  • SSHJ extension install was fixed
  • MySQL:
  • Column editor was fixed (DEFAULT_GENERATED clause removed)
  • Index editor was added
  • PostgreSQL:
  • Schema data types read was fixed
  • Sequence editor was implemented
  • Data type rename support was added
  • SQL Server:
  • Calculated columns support was added
  • Extended properties were added to table DDL
  • Default precision and scale for numeric data types was fixed
  • View triggers support was added
  • Oracle:
  • Functions folder was added (in addition to Procedures)
  • Jobs support was added (read-only)
  • Data type compile action was fixed
  • Synonyms read was fixed for partitioned tables
  • Table triggers loading performance was improved
  • Trigger disable/enable tool was added
  • Procedure/function dependencies were added
  • Comments for views and view columns were added
  • Data type DDL was fixed for predefined types
  • Redshift: problem with read-only resultset was fixed
  • SAP HANA:
  • Table columns was fixed for table names with special symbols
  • Hex literal formatting was fixed
  • Sybase IQ: SQL dialect support was improved
  • Snowflake: drop procedure function was fixed
  • DB2: stored procedures call generator was improved
  • Vertica:
  • Table column create/edit was fixed
  • View constraints read was implemented
  • Unique key creation was fixed
  • DuckDB driver configuration was added
  • RMI server waas fixed (no more public port listeners)

New in DBeaver 21.0.3 (Apr 19, 2021)

  • Dark theme support was improved (Windows 10 and GTk)
  • Metadata search now supports search in comments
  • SQL Server: MFA (multi-factor authentication) support was added
  • PostgreSQL: array data types read was fixed
  • Oracle: indexes were added to table DDL
  • Vertica: LIMIT clause support was improved
  • Athena: extra AWS regions added to connection dialog
  • Sybase IQ: server version detection was improved
  • SAP ASE: user function loading was fixed
  • Informix: cross-database metadata read was fixed
  • We migrated to Eclipse 2021-03 platform
  • Data viewer:
  • Copy As: format configuration editor was added
  • Extra configuration for filter dialog (performance)
  • Sort by column as fixed (for small fetch sizes)
  • Case-insensitive filters support was added
  • Plaintext view now support top/bottom dividers
  • Data editor was fixed (when column name conflicts with alias name)
  • Duplicate row(s) command was fixed for multiple selected rows
  • Edit sub-menu was returned to the context menu
  • Columns auto-size configuration was added
  • Dictionary viewer was fixed (for read-only connections)
  • Current/selected row highlighting support was added (configurable)
  • GIS/Spatial:
  • Map position preserve after tiles change
  • Support of geometries with Z and M coordinates was added
  • Postgis: DDL for 3D geometry columns was fixed
  • Presto + MySQL geometry type support was added
  • BigQuery now supports spatial data viewer
  • Binary geo json support was improved
  • Geometry export was fixed (SRID parameter)
  • Tiles definition editor was fixed (multi-line definitions + formatting)
  • SQL editor:
  • Auto-completion for objects names with spaces inside was fixed
  • Database objects hyperlinks rendering was fixed

New in DBeaver 21.0.2 (Apr 5, 2021)

  • Informix: SQL error position detector was added
  • Snowflake: active catalog/schema selector was fixed
  • DB2 LUW: extra embedded routines support added
  • Google Spanner driver configuration was updated
  • MariaDB: TIME data type support was fixed
  • Vertica: column comments read and update support was added
  • Redshift: table permissions read in table DDL was fixed
  • APM Jenifer driver configuration was added
  • Automatic version upgrade: app restart procedure was improved
  • Application icons were updated
  • SQL Editor:
  • Configuration of open editor action was added
  • Smart auto-completion of column values was improved
  • Problem with ambiguous column name resolution was fixed
  • Hyperlinks detection was fixed
  • Problems with SQL templates view freeze was fixed
  • SQL formatter of case and conditional operators was improved
  • Syntax highlighting for single and double quotes was fixed
  • SQL folding state is now saved for each script
  • Trim spaces command was added
  • Problem with double save/commit confirmations was fixed
  • Database navigator:
  • Quick schema filter was fixed
  • Metadata changes save: single transaction processing was improved
  • Delete object(s) dialog UI was improved
  • Data transfer:
  • Export to flat files now supports columns configuration
  • BOM support was added to CSV import
  • Data viewer:
  • BLOB viewer now respects content type of cell value
  • Grouping panel: queries with trailing comment now handled properly
  • Custom resultset ordering support was fixed
  • PostgreSQL:
  • Serial data types selector was fixed
  • Column default value editor was fixed
  • Numeric arrays rendering was fixed (number formatting removed)
  • SAP HANA (thanks to @wernerdaehn):
  • Smart completion was improved
  • Public synonyms read was added
  • Metadata object search was redesigned
  • SQL Server:
  • Default delimiter was changed to ; instead of GO
  • Synonyms support was improved
  • Check constraints added to table DDL
  • Unicode string literals generation was fixed

New in DBeaver 21.0.1 (Mar 22, 2021)

  • Connection management:
  • Automatic ending of idle transactions was added
  • Network profiles configuration page was fixed
  • Filters in the connection selector dialog were fixed
  • Data transfer:
  • Possibility to disable foreign keys was added (PostgreSQL, Oracle)
  • Numeric data types mappings were improved
  • “Skip all errors” button added in the error dialog
  • Metadata editor:
  • Column delete now checks for dependent objects
  • Constraint/index create command now available in the columns edit tab
  • Problem with deleted object dup was fixed
  • SQL editor:
  • Script selector popup panel UIX was improved
  • Hex constants and scientific numbers formatting was fixed
  • Columns alias generation was improved
  • Multi-line comments support was fixed
  • Data editor:
  • Column filter UI was improved (value count column)
  • Extra configuration was added to SQL script generator
  • Better support of IE browser in the spatial viewer (GIS)
  • Virtual columns support (rows add/delete) was fixed
  • Cells selection was fixed (MacOS)
  • ERD:
  • Export as image: image cropping problem was fixed
  • Export in SVG format was improved
  • Diagram save now forces UTF encoding
  • Tables coloring was fixed
  • Show/hide system object option is now respected
  • Print command enablement was fixed
  • PostgreSQL:
  • PgBouncer support was fixed (problem with prepared statements)
  • Data types read queries were fixed for older (8.4 and earlier) versions
  • Role permissions editor was fixed
  • Infinity timestamp values support was added
  • Auto-generated columns support was added
  • Role name DDL was fixed
  • Teradata:
  • Triggers management was added
  • Views metadata read was fixed
  • Clickhouse:
  • Table data edit support was added
  • Tables and indexed create/drop DDL was fixed
  • Firebird:
  • Procedure parameters’ default value read was fixed
  • View metadata read was improved
  • Automatic app version upgrade was implemented
  • Notification popup rendering in dark theme was fixed
  • Perspective customization UI was fixed
  • Informix: foreign key DDL was fixed
  • Sybase IQ support (server version detection) was fixed
  • Vertica: view create/edit was fixed
  • Data Virtuality driver was added (thanks to @sebcom-gmbh)
  • Preferences localization was updated

New in DBeaver 21.0.0 (Feb 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

New in DBeaver 7.3.5 (Feb 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

New in DBeaver 7.3.4 (Feb 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)

New in DBeaver 7.3.3 (Jan 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)

New in DBeaver 7.3.2 (Jan 4, 2021)

  • Password field layout was fixed
  • Tasks editor view: collapse/expand behavior was fixed
  • Opening SQL files from shell was fixed (MacOS)
  • SAP HANA: connection settings page redesigned (thanks to @kai-morich)
  • PostgreSQL: roles DDL view was added
  • SQL Server: stored procedures invocation was fixed
  • Clickhouse: ALTER TABLE scripts for new columns was fixed
  • Many minor UI bugs were fixed
  • Data editor:
  • Default column values are now shown for new rows
  • LIKE filers now add % masks automatically
  • Tabs close confirmation dialog was fixed
  • Value filter drop-down was fixed (problem with column mismatch was fixed)
  • Boolean values view is now configurable
  • Result tabs drag-n-drop behavior was fixed
  • Metadata editor:
  • Boolean values view is now configurable
  • Virtual foreign keys editor was fixed
  • Incorrect column length (zero or negative) was fixed
  • Data transfer:
  • Data type mapping was improved (better type matching)
  • Redshift:
  • Extra data types (non-PostgreSQL) support was added
  • Strings parser was fixed (escape with backslash)

New in DBeaver 7.3.1 (Dec 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

New in DBeaver 7.3.0 (Nov 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

New in DBeaver 7.2.5 (Nov 16, 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

New in DBeaver 7.2.4 (Nov 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

New in DBeaver 7.2.3 (Oct 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

New in DBeaver 7.2.2 (Oct 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

New in DBeaver 7.2.1 (Sep 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)

New in DBeaver 7.2.0 (Aug 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

New in DBeaver 7.1.5 (Aug 16, 2020)

  • Data transfer:
  • Import from multiple CSV files was added
  • Import from files into new tables
  • Data import preview dialog was added
  • Target table create/alter DDL now supports database-specific options
  • Virtual columns are ignored in SQL INSERTs export
  • Problem with data transfer wizard and Darkest Dark theme was fixed
  • Problem with timestamp format for CSV/XLSX export was fixed
  • Case sensitive table/column names resolution was fixed
  • Database navigator:
  • Statistics render was fixed for MacOS and Linux
  • Database size statistics was added for PostgreSQL, MySQL, SQL Server, DB2
  • Team work:
  • Problem with empty Git Repositories view was fixed
  • Git integration was added in project navigator view
  • PostgreSQL:
  • Native client version was upgraded to version 12 (Windows)
  • Check constraints read was fixed (PG 12+)
  • SQL results limit was fixed (for queries with LIMIT/OFFSET/FETCH clauses)
  • Object DDL generator was improved (comments, permissions)
  • Support of case insensitive full-text search was added
  • Table partitions statistics was added
  • Oracle:
  • TNS names search was fixed
  • Connection info was fixed for TNS/custom URL connections
  • Variables are now supported in custom JDBC URL (thanks to @insightfuls)
  • MysQL:
  • Problem with check constraints read was fixed
  • Table copy was fixed (bug with redundant indexes was resolved)
  • Redshift: problem with read-only resultsets was fixed
  • Snowflake: SQL dialect support was fixed ($$ comments)
  • A large number of minor UI improvements and bugfixes

New in DBeaver 7.1.4 (Aug 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

New in DBeaver 7.1.3 (Jul 19, 2020)

  • Spatial presentation: tooltips rendering was fixed
  • DB2: UI tools were converted into database tasks
  • MySQL/MariaDB: database restore was fixed (binary data corruption)
  • PostgreSQL: data type DDL was improved + comment edit support was added
  • Oracle: problem with connect as SYSDBA was fixed
  • Exasol: (thaks to @Sargul)
  • Database error type discovery was added (proper handle of “connection lost” errors)
  • Metadata read performance was improved
  • Googlee Spanner: official driver configuration was added (thanks to @olavloite)
  • Simple view mode was fixed (redundant database objects were hidden)
  • Proxy configuration UI was fixed
  • MacOS installer was fixed (potential vulnerability was removed, thanks to @De4dCr0w)
  • Tasks management: error handing was improved (for deleted tables)
  • We reverted to Eeclipse 2020-03 platform (it resolves a set of UI glitches on some platforms)
  • A few minor UI and database-specific bugs were fixed

New in DBeaver 7.1.2 (Jul 5, 2020)

  • Data viewer:
  • Now we refresh entire row after cell value update (handy if you have triggers)
  • Generate SQL context menu was fixed
  • Horizontal scroll with mouse wheel support was added
  • Export data in source code (PHP arrays) format was added
  • Bug with Ctrl+Backspace handler was fixed
  • SQL Editor:
  • Query cancel handler was improved (problem with UI stuck was fixed)
  • Now we show query information in the result tab tooltip
  • Query parser was fixed (active query extraction for Ctrl+Enter action)
  • Template variables (${word_selection} and ${line_selection}) support was fixed
  • Navigator:
  • Icons for “Create object” actions were fixed
  • Main menu File items were reordered
  • Heading and trailing spaces trim was added to all edit dialogs/panels
  • Session manager: problem with multiple windows was fixed
  • SQL Server: Database tools (index rebuild, triggers disable) were redesigned
  • Firebird: new table and table column creation was fixed
  • PostgreSQL: Table partition DDL was fixed
  • MySQL: CHECK constraints edit support was added
  • Oracle:
  • Table statistics read was fixed
  • Schema indexes folder was added
  • Check constraints editor was added
  • Trigger status icon was fixed
  • Exasol: (thanks to @Sargul)
  • Metadata read performance was improved
  • Metadata search support was added
  • Table references
  • Index create DDL was fixed
  • Table statistics read performance was improved
  • Redshift: driver download was fixed
  • SQreamDB driver was added
  • YugabyteDB driver was added
  • We upgraded Eclipse platform version to 2020-06. It affects dark theme and General preferences and fixes several minor bugs

New in DBeaver 7.1.1 (Jun 21, 2020)

  • Database navigator:
  • Connection type highlighting was redesigned
  • Simple view support was improved
  • "Force object refresh on editor open" action was fixed
  • Main toolbar UIX was improved (no disabled selectors)
  • Database tools context menu was fixed
  • Table statistics:
  • Rendering problems (redraw on scrolling) were fixed
  • Performance problems were fixed
  • SQL Server support was added
  • Data viewer:
  • Wrong value extraction was fixed for expression aliases which conflict with table column names
  • Dictionary values separator configuration was added
  • Row coloring: support of gradient coloring for read-only columns was added
  • Data formatter:
  • Action "reset to default" was fixed in preferences
  • Preference changes are immediately applied to open data editors
  • SQL editor:
  • Results tab rename was fixed (now we save tab title between results refresh)
  • Parser of multiple SQL queries on a single line was fixed
  • Execution plan explain operation cancel was implemented
  • Coloring of numbers in scientific notation was fixed
  • Paste from source code: n and r characters handle was fixed (now we use proper line feeds)
  • Stored procedures call generation was fixed
  • Object editor: "reject changes" and command undo/redo command were fixed
  • Data import: open target table on finish
  • Data migration: DDL generation was improved (apply the same column data type when source and target databases use the same driver)
  • Database tasks: PostgreSQL, MySQL and Oracle tools now can be saved as tasks
  • SSH configurator: UI controls layout was fixed
  • Database driver edit dialog was fixed (legacy driver option is disabled by default)
  • MySQL:
  • User permission management was fixed (FLUSH PRIVILEGES is not needed for newer server versions)
  • Unsigned INT and BIGINT data types support was added
  • Oracle:
  • Numeric data type modifiers (scale/precision) rendering was fixed
  • Materialized views read/create and delete was fixed (mviews were removed from table list)
  • PostgreSQL:
  • Vacuum tool was improved (run in auto-commit mode)
  • List of reserved keywords was updated
  • Redshift: View with no schema binding support was added
  • SQL Server: timestamp columns were marked as auto-generated
  • Big number of minor UI and database-specific bugs were fixed

New in DBeaver 7.1.0 (May 31, 2020)

  • Database navigator:
  • Statistics view (table sizes) was added
  • Connection coloring was redesigned
  • Connection host name tip was added
  • Data viewer:
  • Ref cursor panel viewer was added
  • Columns sort settings save/load was added
  • Data export in HTML format was fixed (styles)
  • SQL editor:
  • Function call formatting was improved
  • Table alias generation was fixed (for unicode/numeric table names)
  • PostgreSQL:
  • Ref cursors refresh support was added
  • Table and schema statistics was added
  • Table comment and rules were added to DDL
  • Oracle:
  • Metadata search was fixed
  • Java source read was fixed
  • ODBC driver download was fixed
  • Exasol: metadata edit dialogs were redesigned
  • Clickhouse: table statistics was added
  • Firebird: view editor was fixed
  • Plain HTTP driver repositories (Maven or direct links) were replaced or removed
  • Big number of minor UI and database-specific bugs were fixed

New in DBeaver 7.0.5 (May 17, 2020)

  • Data viewer:
  • Pin (aka “freeze”) column feature was added
  • Float (32bit) data type render was fixed (MySQL)
  • Plaintext renderer was fixed (binary values representation)
  • Filter value auto-complete was fixed (clipboard paste support)
  • Issue with “order by table column + column alias” was fixed
  • SQL editor:
  • Script close prompt was fixed
  • Hyperlinks now contain procedure parameters
  • Script selector panel positioning was fixed
  • Execute in new tab: new tabs opening was fixed
  • SQL format preferences page was improved
  • SQL formatting was fixed (line feeds after brackets)
  • SQL console title was fixed (source object name was added)
  • Non-https Maven repositories and driver links were removed
  • PostgreSQL:
  • Added parameters to the SQL execution plan explain (ANALYSE is optional)
  • Database backup was fixed on Linux/MacOS (proper table names quoting)
  • Table DDL was fixed (show table comment)
  • Sequence DDL was fixed (START parameter)
  • Object dependencies now contain links on dependent/depending object
  • Permission/role editors were fixed (roles are sorted by name now)
  • SQL auto-completion fixed for older PG (<= 8.4)
  • Oracle: unique key detection was fixed
  • DB2:
  • FOR BIT DATA columns support was fixed (show value as binary)
  • Native SQL dialect support was improved (BEGIN/END)
  • SQLite: ROWID pseudo-column support was added (as unique key)
  • Many other minor bug fixes and improvements

New in DBeaver 7.0.4 (May 3, 2020)

  • SQL editor:
  • Format now formats active query by default
  • Matching brackets highlighting was improved
  • Data viewer:
  • Find/replace highlighting and scrolling was fixed
  • Data filter save was fixed (problem with quoted column names)
  • Auto-completion in data filter now can be disabled
  • Object editor: refresh button in bottom toolbar was unified for all pages
  • Dark theme support improved (connection type colors)
  • New connection wizard was fixed (problem with quick driver selector)
  • Driver editor dialog was improved:
  • Extra properties save was fixed
  • Legacy drivers support was added
  • Git extension packaging was fixed (older Eclipse versions support)
  • Derby: new database create was fixed
  • Firebird: system objects hide/show was fixed (determine system flag from fro meta table)
  • MySQL:
  • Read-only connections support was fixed (SQL editors)
  • Query execution plan explain was fixed
  • Oracle:
  • Driver configuration was fixed (typo in Maven artifact name)
  • Java classes source viewer was added
  • Materialized view DDL read was fixed
  • PL/SQL parser was fixed (CASE/WHEN/END)
  • PostgreSQL:
  • search_path update was fixed
  • Numeric values rendering was fixed
  • Redshift: SOCKS proxy support was fixed
  • SQL Server: table DDL generation was fixed (column type names)
  • SQLite: foreign key metadata read was fixed (FKs with no name)
  • Portuguese (BR) localization was added (thanks to @wellesximenes)
  • Many minor bug fixes and improvements

New in DBeaver 7.0.3 (Apr 20, 2020)

  • SQL editor: multiline code templates apply was fixed (thanks to @VASilaev)
  • Number of bugs were fixed in the Simple navigator view
  • Transaction management was improved (redundant transaction commit confirmations were removed)
  • GIS viewer: many new (and cool) tiles were added (thanks to @mkgrgis)
  • Active catalog/schema selector UI was improved
  • Connection edit dialog was fixed (error during page switch)
  • HANA: unique key creation was fixed
  • Firebird: procedure metadata refresh was fixed
  • Problems with remote RDP connections (app crash) were fixed
  • Japanese localization was significantly improved (thanks to @ScratchBuild)
  • We have migrated to Eclipse platform 2020-03
  • Many other minor bug fixes and improvements
  • Data viewer:
  • Problem with unreachable last row/column was fixed
  • “Open With” action now uses configuration from last data export
  • Find/replace issues were fixed (scroll to found cell)
  • Bug in reference panel was fixed (multiple value selection)
  • Filter value auto-completion was fixed (popup close)
  • Virtual unique keys management was improved
  • Oracle:
  • Connection settings (SID/Service) save was fixed
  • Session terminate was fixed (for non-RAC databases)
  • Exasol:
  • Foreign key creation was fixed
  • View DDL extraction was fixed (auto-format was disabled)

New in DBeaver 7.0.2 (Apr 6, 2020)

  • Database navigator:
  • Simplified database structure view was added
  • Navigator view settings and presets were added
  • Object editor:
  • Context menu was added to the object breadcrumbs
  • Object alter script now can be opened in SQL editor
  • Data editor:
  • Preference and data format changes now applying immediately (without data refresh)
  • Scrollbar position reset in columns reorder/filtering was fixed
  • Number of selected rows/columns/cells now shown in the status bar
  • Query filter history save/load was fixed
  • Floating point numbers (4-byte precision) rendering was fixed
  • SQL Editor: quick search tool was added (ctrl+alt+shift+f)
  • Driver copy was fixed (problem with read-only URL)
  • PostgreSQL:
  • PGPASS support was fixed
  • Database information (ctype, collate) reading was fixed
  • Problems with default database change were fixed
  • OID types rendering fix
  • Domain metadata reading was fixed (base type qualified name)
  • Extra options were added to database backup/restore wizards
  • Redshift: data type resolution was fixed (array types)
  • SQL Server:
  • Driver download and “reset to default” was fixed
  • Default schema detection was added
  • Problems with read-only query results were fixed
  • Column comments edit was fixed
  • MySQL:
  • Permission editor was fixed (schema privileges)
  • Index rename support was added
  • Exasol:
  • Security tree (Exasol 7) was fixed
  • Auto-completion for builtin functions was added
  • Foreign keys metadata was fixed
  • Oracle: “drop procedure” support was fixed
  • SAP HANA: driver download was fixed
  • Firebird: driver version was upgraded (4.0)
  • Many other minor bug fixes

New in DBeaver 7.0.1 (Mar 23, 2020)

  • ERD viewer: table resize support was added
  • Query manager: full query text view was fixed
  • Connections invalidate was fixed (redundant connections open) and invalidate performance was improved
  • SQLite: column rename support was added
  • Snap package was significantly improved (thanks to @galgalesh)
  • Many other minor bug fixes
  • Data viewer:
  • Search/replace in selected rows support was added
  • Problem with Find/Replace and scrolling was fixed
  • Floating point numbers rendering/copying was fixed (precision fix)
  • SQL editor:
  • Connection initialization was fixed (active schema set)
  • Auto-completion for DROP/ALTER procedure/function was added
  • Auto-completion for asterisk (*) was fixed
  • Auto-completion for table aliases was disabled
  • Auto sync with database navigator was fixed (proper catalog/schema change)
  • Schema compare (simple):
  • Compare progress visualization was fixed
  • Stored procedures body compare was fixed
  • SSH tunnel: default user name (current OS user) is used when user name not set
  • PostgreSQL:
  • PGPASS authentication was added
  • Unique key indexes visibility was fixed
  • Schema permissions viewer/editor was added
  • Function/procedure create dialog was fixed
  • Options for tables/functions DDL viewer now saved
  • Enum values editor was added
  • Array values copy-paste was fixed
  • Oracle:
  • Automatic driver download was added
  • View constraints create/drop support was added
  • DB2 LUW:
  • Automatic driver download was added
  • Table references read was fixed
  • SQL Server:
  • Driver download (native artifacts) was fixed
  • Custom SQL query result editor was fixed
  • Schema selector (main toolbar) was fixed

New in DBeaver 7.0.0 (Mar 2, 2020)

  • Tasks management: data transfer, backup-restore, SQL execution
  • Git integration
  • SSH agents and jump servers support
  • And a lot of other great things
  • Data viewer and data editor UI major improvements:
  • GIS/geo-spatial viewer
  • JSON viewer
  • Logical columns, primary and foreign keys
  • References panel
  • Advanced row coloring
  • SQL editor major improvements:
  • Smart-commit mode
  • Enhanced SQL parser and auto-complete proposals

New in DBeaver 6.3.5 (Feb 17, 2020)

  • Data viewer:
  • Read-only columns UI was improved (icon + explanation were added)
  • Filter text content assistant was significantly improved
  • Row count calculation control UI ws fixed
  • “Set default value” shortcut was changed
  • Ordering in record mode was fixed
  • Data change confirmation was fixed
  • Plaintext presentation rendering was fixed (extra spaces)
  • Numbers native representation mode (no client-side formatting) was added
  • SQL editor:
  • Export from query task was fixed
  • Output tab now remains active after query execute
  • Auto-commit toggle was fixed (rollback is performed on mode switch)
  • Connection initialization was fixed (“Not connected to a database” bug)
  • Column values assistance was added
  • Numbers color and font was fixed
  • ERD viewer:
  • Entity/schema diagram “reset” action was added
  • “Show views” option handle was fixed
  • Connections and drivers:
  • Variables support was improved (now all properties may contain variables)
  • Maven artifact version resolution was fixed (null version bug)
  • External drivers configuration support was added (see wiki)
  • PostgreSQL:
  • Query cancellation was fixed
  • Hyperlinks and “Go to object” action were fixed (now they use current database instead of default one)
  • Schema privileges were added in DDL
  • Indexes read was fixed (redundant primary key constraint was removed)
  • Arrays of domain types support was fixed
  • Column copy-paste support was added
  • MySQL:
  • Identifiers redundant quotation was fixed
  • Column copy-paste support was added
  • Oracle:
  • Default schema detection was fixed
  • Double compilation of package was fixed
  • PL/SQL parser was improved (case .. when .. end)
  • DB2: alter column DDL was fixed (column modifiers were added)
  • SQL Server: metadata search was fixed (wrong object types bug)
  • AWS Athena: error position highlighting was added
  • Sybase: legacy versions (12 and earlier) support was improved
  • A lot of minor bugfixes

New in DBeaver 6.3.4 (Feb 3, 2020)

  • Active database/schema selector behavior was significantly improved
  • Smart commit mode was enhanced:
  • Switching to auto-commit after the end of transaction
  • Smart commit for table editors
  • Transactions preference page was added
  • Data transfer:
  • CSV export parameters (quote mode) were added
  • Add/remove table to existing data transfer task was fixed
  • SQL editor:
  • “Select all rows” query generation was fixed
  • Read data in console now uses correct default schema
  • Exasol: metadata editor was significantly improved
  • Neo4j: complex data types (structs/arrays) support was fixed
  • Snowflake: index editor was fixed, view editor was fixed
  • Greenplum 6.x: table DDL was fixed
  • Oracle: PL/SQL parser was fixed (code blocks)
  • A lot of minor bugfixes
  • Data viewer:
  • Show boolean values as checkboxes (configurable)
  • Row colors customization was fixed
  • Connection editor:
  • Multiple connection editor dialogs can be opened now
  • Extra variables were introduced, config UI was improved
  • Apache Phoenix:
  • Driver version was updated
  • Schema-less tables read was fixed
  • Index create support was added
  • SQL autocomplete was fixed
  • PostgreSQL:
  • Backup for selected tables was fixed
  • Execute script on the selected database was fixed

New in DBeaver 6.3.3 (Jan 20, 2020)

  • Oracle: procedures/views source code editor was fixed
  • MySQL: database restore log level config was fixed
  • Netezza: views and procedures source extraction was fixed
  • Hive: view editor was fixed
  • Neo4j: arrays support was fixed, SQL parser was fixed
  • Metadata editor: current database detection was fixed
  • Tooltips for database navigator were improved
  • Variables in connection parameters now enabled by default
  • Connection type permissions save was fixed
  • Dark theme support was improved in the main toolbar and in different dialogs
  • SSH agents support was fixed (now we use ssh-agent on Linux)
  • SSH + private key + password: configuration dialog was fixed
  • A lot of minor bugfixes
  • Tasks:
  • SQL script execute task was added
  • Variables support was added
  • Grouping of tasks by project/type was added
  • Active database/schema now saved for custom SQL queries
  • Target table mapping was fixed for database-to-database data transfer
  • Data viewer:
  • Column filter UI was improved (multi-value select, value search)
  • Null XML columns support was fixed
  • Column value transformations and coloring was fixed
  • Context menu was improved (layout was change, missing commands were added)
  • Problem with missing toolbar actions was fixed
  • Hex editor coloring was improved, dark theme support was added
  • SQL editor:
  • Auto-complete now respects active schema
  • Database output read was fixed (async mode)
  • Hyperlinks and object navigation were fixed
  • Aliases generation algorithm was improved
  • PostgreSQL:
  • Database restore task was fixed (target database)
  • SQL parser was fixed (BEGIN/END keywords)

New in DBeaver 6.3.2 (Jan 6, 2020)

  • Database backup/restore/sql tools (PostgreSQL, MySQL, Oracle) now can be saved as tasks
  • Smart auto-commit mode was introduced (enable transactions before data modifying query execute)
  • Data editor: advances paste now respects NULLs for dates and numbers
  • DB2 (iSeries, z/OS): new connection issue was fixed
  • Oracle: session manager now shows servr-side execution plans (thanks to @SergDzh)
  • MySQL: database backup/restore was fixed
  • Firebird: unique key DDL was fixed
  • Number of fixes and improvements in backup/restore tools
  • Workspace switch: last chosen workspace is now saved between app restarts
  • Dark theme support was improved (toolbars, dark colors customization)
  • Eclipse 4.6 support was fixed
  • Problem with missing toolbar buttons was fixed (Linux)
  • A lot of minor bugfixes
  • SQL editor:
  • Alias generation was improved
  • Output log flush eas fixed
  • Default database assign (for SQL script) was fixed
  • PostgreSQL:
  • $$ strings parser was fixed
  • Domain type arrays support was fixed

New in DBeaver 6.3.1 (Jan 6, 2020)

  • Transaction log/query manager: dark theme support was fixed
  • Dashboards + timeseries + minute interval support was fixed
  • SSH with private key + password support was fixed
  • Extra locales (pt and ru) support was added in bundled JDK
  • SAP HANA: GIS/spatial data type viewer support was added (thanks to @stefanuhrig)
  • Presto: metadata reading was improved (dummy errors suppressed)
  • AWS Athena: URL template now respected in new connections
  • DB2: table truncate command was fixed
  • Oracle: new function DDL was fixed
  • Snap repository dbeaver-ce is now official. We will update it on every version release
  • A lot of minor bugs were fixed
  • SQL editor:
  • Active database/schema change now affects current editor only
  • Server-side output now works with huge outputs
  • New command @unset was introduced
  • Table alias generation was fixed (conflicts with SQL keywords were fixed)
  • Query parameters dialog now doesn't appear on scrolling/refresh
  • Code templates now saved in utf-8
  • Data editor:
  • Smart option "Use all columns" for virtual identifier
  • Inline cell editor now uses the same font as in grid
  • Decimal values formatting was fixed
  • Data transfer:
  • Selected rows/columns option support was fixed
  • CSV import was fixed
  • Export to single file was fixed (timestamp pattern)
  • Export from query now works with variables
  • MySQL:
  • Database backup can be saved as task now
  • Events editor (DDL) was fixed
  • PostgreSQL:
  • Connection dialog was improved (new tab was added)
  • $$ and $tag$ parser was improved (new config options were added)
  • JSON and struct data types support was fixed

New in DBeaver 6.3.0 (Dec 2, 2019)

  • SSH Agent support was added (pageant and ssh-agent)
  • Disconnect project/folder/all actions were reworked
  • Problem with connection properties save was fixed
  • Connection properties dialogs UI was improved (test connection, password save, pref page search)
  • Task management UI was improved (task create/save actions in data transfer wizard)
  • ER diagrams: dummy errors are now suppressed (now they present in log file only)
  • Legacy Eclipse plugins installation support was added (with hold update site format)
  • Dark theme support was significantly improved
  • Auto-commit mode behavior change:
  • Toolbar toggle now affects current connection only
  • Mode change affects active DBeaver session only
  • Data export:
  • Export from SQL script now supports commands (@set and others)
  • Saved settings loading was fixed
  • XLSX exporter now respects export configuration
  • Data editor:
  • Fetch size can be changed before query execute
  • Spatial viewer now supports different pluggable tiles (mapbox, osm, etc)
  • Wrong date/time format now treated as error
  • SQL Editor: editor layout now saved between DBeaver sessions
  • Object editor (tables, views, etc) now checks for object name duplicates
  • Oracle: now we use full type name presentation by default
  • PostgreSQL: support of extra type aliases and array data types was added
  • CockroachDB: native CDB data types were added
  • Impala: active schema change support was added
  • A lot of minor UI/DB-specific bug fixes

New in DBeaver 6.2.5 (Nov 18, 2019)

  • Problem with context menu was fixed (on Linux)
  • Problem with mixed global/connection settings was fixed
  • SSH: “jump” server support was added (thanks to bsv798)
  • Object editor: property change and object rename was fixed (right order of DDL queries)
  • SQL editor: CASE/WHEN formatting was fixed
  • Oracle: data type editor UI was fixed
  • MySQL: events DDL was fixed (interval)
  • PostgreSQL: array-based domain data types handle was fixed
  • SQL Server: synonyms search was added
  • HANA: table column create was fixed
  • Greenplum 6+: table DDL (distribution) was fixed
  • Full-text search dialog render was fixed
  • Application startup speed was improved
  • Several rendering glitches on HighDPI screens were fixed
  • Many other minor UI fixes
  • Data editor:
  • Vertical and horizontal scroll position is now saved between data refresh/filter
  • Smooth scroll mode is now the default mode (and configurable)
  • Large json loading performance was improved
  • Ordering by unnamed columns was fixed
  • Grouping panel refresh was fixed
  • Data export/copy as: use the same connection by default

New in DBeaver 6.2.4 (Nov 3, 2019)

  • SQL editor:
  • Select row count from custom query was fixed (ORDER BY now allowed)
  • Parameters/variable binding was fixed
  • Export from query with parameters was fixed
  • Number of improvements in intellisense algorithms
  • Data viewer:
  • Smooth scrolling mode was added
  • Number of fixes in floating point numbers handling
  • Option for short/fully qualified table names in SQL script was added
  • Grid state save/restore (after ordering/filter apply) was fixed
  • Tabs pin + drag-n-drop behavior was fixed
  • Tables navigation was fixed (filter value refresh)
  • Query manager: query ordering/refresh was fixed
  • ERD: problem with broken layout after config change was fixed
  • CSV export: row separator config was added
  • PostgreSQL:
  • $$ delimiters handle was fixed
  • Function parameters default value reading was fixed
  • Oracle: table column comments save was fixed
  • SQL Server: functions and synonyms support was added in object search
  • Java version in Windows ad MacOS installers was upgraded to OpenJDK 11.0.5
  • A lot of other minor UI fixes

New in DBeaver 6.2.2 (Oct 7, 2019)

  • H2GIS: spatial data viewer was added
  • Redshift: stored procedures support was added
  • Yellowbrick: driver config was fixed for better performance
  • Oracle: view column comments edit support was added
  • A lot of minor UI fixes
  • Task management: now all data transfer operations (export/import) can be saved as tasks:
  • New task management view
  • Running saved tasks in two clicks
  • Task execution logs
  • Data transfer:
  • Output file names were fixed
  • Previous wizard settings save was fixed
  • Many minor improvements
  • Virtual table columns:
  • Supported for all tables and views
  • Supports expressions, math functions and geometry transformation functions
  • Virtual foreign keys config save/copy was fixed
  • Data viewer:
  • Hex viewer was added for string content
  • Long CLOB text viewer was fixed
  • Filter dialog was fixed (orderings, distinct value reading)
  • SQL editor: parameters binding was improved:
  • Show dialog before script execution
  • Show current query text
  • Object editor: new command for expensive properties (row count) reading SAP HANA
  • New extension developed (thanks to @kai-morich):
  • Driver auto-download
  • Sequences, synonyms, triggers
  • SQL execution plan
  • Object searcher

New in DBeaver 6.2.1 (Sep 23, 2019)

  • SQL Editor: update row count calculation was fixed
  • MySQL: date/time formatting was fixed
  • PostgreSQL: 3D geometry columns render was fixed
  • SQL Server: problem with identifiers with “go” characters was fixed
  • Oracle: SQL parser was fixed (CASE WHEN ELSE END)
  • Database metadata search wizard was fixed
  • A lot of other minor UI bugs were fixed
  • Data viewer:
  • Spatial (GIS) presentation improved (tooltips, different shape colors for different columns)
  • JSON render performance was significantly improved
  • XML value viewer was fixed (proper error handle)
  • XML auto-formatting was fixed (extra whitespaces)
  • Context menu “Navigate” was added (returned)
  • Floating numbers representation was fixed (exponential view)
  • Columns transformation settings dialog was fixed
  • Connection settings:
  • Load multiple data-sources*.json files
  • Respect preference changes (timeouts and other) in “Test Connection” dialog.
  • Project export/import wizard was fixed
  • New database drivers:
  • H2GIS
  • Kognitio
  • Opendistro (Elasticsearch)

New in DBeaver 6.2.0 (Sep 13, 2019)

  • Data viewer:
  • JSON highlighting/formatting was added
  • Select/deselect rows with alt+click was improved
  • Reference panel now supports virtual foreign keys
  • “Set to default value” action was fixed (for timestamp columns)
  • Dictionary read was fixed
  • ERD:
  • Table/schema diagram edit is now supported
  • Virtual foreign keys support was added
  • Database navigator:
  • Transactions tracking was improved (+now commit/rollback actions are always active)
  • Cross-project connections copy-paste and drag-n-drop was fixed
  • Navigator tree state save (and restore on restart) was added (thanks to loro2)
  • Columns reordering was fixed
  • Global filters configuration was fixed
  • Connection permissions are now supported in connection type (prod, dev, test)
  • SQL editor:
  • Query execution time logging was fixed
  • Generate SQL dialog was improved (FQ names, copy to clipboard)
  • Script selector panel UI was fixed
  • Variables binding now can be skipped for a query/script
  • JDBC fetch size now set for custom SQL queries
  • Data export now reuses SQL editor connection
  • Metadata editor: columns drop was fixed
  • SQL Server:
  • NVARCHAR/NCHAR length calculation was fixed
  • Column default value edit support was added
  • DDL for TEXT/NTEXT data types was fixed
  • PostgreSQL:
  • Driver now uses URL template (by default)
  • Column comments for new tables now saved properly
  • SQL Server Data Warehouse support was added
  • MySQL: bit stream data type support was fixed
  • CockroachDB: table metadata read was fixed
  • Apache Derby driver was upgraded
  • Teradata: multiple resultsets support was added
  • Test connection dialog was redesigned
  • Driver libraries cache was fixed (re-download of Maven artifacts)
  • Widows registry reading was fixed (Java 8 compatibility)
  • Many other minor bugs were fixed

New in DBeaver 6.1.5 (Aug 19, 2019)

  • Data viewer:
  • Virtual primary/foreign keys editors were enhanced
  • Problem with filters on data refresh was fixed
  • Added confirmation dialog before opened result tabs closing
  • Problem with missing updated row count (in script mode) was fixed
  • References panel now remembers last FK/reference selection
  • Value view panel now supports Find/Replace
  • Float values rendering was fixed (numbers rounding is disabled by default)
  • Data transfer:
  • Save of previous target container selections was added
  • Export of tables/queries with complex data types (structs, objects) was improved
  • Connection management:
  • Connection permissions config was added (restrictions of data/metadata changes for a particular connection or connection type)
  • Problem with bootstrap queries and auto-commit state save/load was fixed
  • Multi-project support was improved (use selected project for new connections)
  • Support of empty database passwords was added
  • Copy/paste and drag-n-drop connections between different projects was fixed
  • Database navigator:
  • Default double-click behavior configuration was added (view properties/data/erd)
  • Object edit dialogs are properly sized now (problem with too small dialog window was fixed)
  • Connection type coloring in the main toolbar is back
  • DBeaver toolbars visibility was fixed (for Eclipse plugin version)
  • New DBeaver version automatic downloading (optional) was added
  • MySQL:
  • Datetime columns edit was fixed. Problems with timezone were fixed.
  • Legacy MySQL <4 driver was added (again)
  • PostgreSQL:
  • Automatic transaction error recovery was added (famous “current transaction is aborted” error)
  • Partition management was added (partition create/drop)
  • Support of VACUUM tool for older PG version was fixed
  • Enum items order was fixed (in metadata editor)
  • Legacy PostgreSQL <= 8 driver was added
  • SQL Server: index DDL was improved (now it contains all index properties)
  • Redshift: table DDL generation was fixed (“diststyle AUTO” and other improvements)
  • Hive: struct/array data types support was added
  • Presto: array data types support was fixed
  • DB2 i: routine list reading was fixed
  • We have migrated to the Eclipse 2019-06 platform (fixes many minor UI bugs on Linux)
  • Many other minor bugs were fixed

New in DBeaver 6.1.4 (Aug 5, 2019)

  • Many problems with workspace migration were fixed
  • Entiy diagrams: logical foreign keys can be created/deleted right in the diagram editor
  • Data transfer: auto-generated (identity) columns handler was added
  • DDL generation: now we generate tables DDL according to their foreign keys order
  • Geometry viewer: simple (flat) geometry support was added
  • Execution log: reading of row count for DML statements was fixed
  • Apache Hive: many bugfixes related to complex (struct/array) data types handling
  • Apache Drill: driver was fixed (missing JDK modules were added)
  • Many other minor UI bugs were fixed
  • Data viewer:
  • UI look and feel was significantly improved
  • New interface for rows/columns coloring
  • Logical foreign key creation was simplified
  • Many bugs were fixed in References panel rendering
  • Column filters UI was fixed (dups, dictionary reading errors)
  • Unique key detection was fixed (use indexes with nullable columns if no other identifiers found)
  • SQL Editor:
  • SQL formatter was fixed (DECLARE statements)
  • Copy SQL to Java code was improved (thanks to loro2)
  • PostgreSQL:
  • Array data type handler was fixed
  • Indexes metadata reading was fixed
  • Execution plan visualization was fixed for CTE nodes
  • SQL Server:
  • Support of identity columns creation was added
  • Session manager was fixed
  • Oracle:
  • Scheduled jobs metadata reading was fixed
  • Session management was fixed for RAC mode
  • Firebird: views and indexes metadata reading was fixed

New in DBeaver 6.1.3 (Aug 5, 2019)

  • New project configuration format was implemented. Main advantages:
  • Better security (now we keep user credentials separately)
  • Better support for version control systems (e.g. Git)
  • Now we use standard (OS-specific) directories for configuration location
  • Major features:
  • Logical foreign keys
  • Data viewer: “References” panel was added (browse values by foreign and reference keys)
  • Network profiles support was added: you may configure SSH/Proxy settings once and reuse them for any number of connections
  • Other:
  • Connection page was redesigned
  • Data viewer filter panel UI was improved
  • Snowflake: procedures DDL, connection page fix
  • Google Spanned database support was added
  • PostgreSQL: struct/array data types support was fixed
  • MySQL: privileges viewer was fixed (global privileges grant/revoke)
  • DB2 i: procedure list and DDL reading was fixed
  • Many minor UI bugs were fixed

New in DBeaver 6.1.2 (Jul 8, 2019)

  • Git integration:
  • Create projects in remote repositories
  • Pull/commit/push automation from the DBeaver perspective
  • Integrate existing projectys with Git repositories
  • Problem with SSH and SSL connections was solved
  • Problem with missing legacy character encoding was fixed
  • Data editor:
  • “Delete cascade” feature was added
  • Problem with column order was fixed (when result contains multiple columns with the same name)
  • Problem with duplicated values in column filters was fixed
  • “Default” values were added for numbers, strings and booleans
  • Data transfer:
  • Export to a single file was fixed
  • TXT format: extra options were added
  • CSV import: timestamp columns parser was fixed
  • PostgeSQL:
  • Extensions management was added
  • Partitions DDL was added
  • Partitions create/drop support was added
  • Object description reading was fixed (+ problem with duplicated objects was solved)
  • Complex data types rendering was fixed
  • float4 data type support was fixed (wrong value render)
  • Greenplum: ERD renderer was fixed
  • Oracle:
  • Problem with read-only tables was fixed (for some Oracle versions)
  • View management: problem with semicolons was fixed
  • DB2 for iSeries:
  • Procedures DDL was added
  • Problem with schema list reading was fixed
  • Generic driver (SQLite and others): problem with view create command was fixed
  • Plenty of minor UI bugs were fixed

New in DBeaver 6.1.1 (Jun 24, 2019)

  • We have migrated to Java11 (Windows and MacOS bundled JRE is OpenJDK 11.0.3)
  • ERD: diagram refresh fixed (do not re-layout elements)
  • ERD: support of zoom with mouse wheel was added
  • PostgreSQL: ref cursor data type support was fixed
  • Oracle: bootstrap queries execute was fixed
  • DB2 for iSeries, DB2 for z/OS: schema list reading was fixed
  • SQLite: datetime columns support was fixed
  • SAP HANA: triggers support was added (read-only)
  • Data views: calc panel was fixed (min/max functions evaluation)

New in DBeaver 6.1.0 (Jun 10, 2019)

  • Stable release of geo spatial data viewer, many UI improvements and bug fixes.
  • Data viewer:
  • Spreadsheet column-based coloring support was added
  • Copy as HTML now uses html clipboard format
  • Focus loss bug was fixed (MacOS)
  • Data transfer:
  • Export to XLSX format: performance was greatly improved
  • Table truncate confirmation was added
  • Plaintext export was fixed (datetime data types formatting)
  • SQL editor:
  • SQL execution plan save/load support was added
  • Bug with keywords in comments was fixed
  • Active connection/schema selectors were fixed in the main/context menus
  • Workbench/J formatter was fixed
  • ERD diagram: Dark theme support was improved
  • Database navigator:
  • New object create context menu redesigned
  • Duplicated nodes bug was fixed
  • Spatial viewer:
  • Coordinates inversion was fixed (MySQL)
  • Column SRID and coordinates flip settings are now saved between sessions
  • Oracle:
  • Constraints metadata reading was fixed (fixes table editor as well)
  • Indexes DDL reading was added
  • PostgreSQL:
  • Backup of “quoted” schemas and tables was fixed
  • Functions’ dependencies information was added
  • Struct data types parser was fixed (boolean fields extraction)
  • MySQL:
  • BEGIN keyword handler was fixed
  • View DDL was fixed (extra delimiters)
  • SQL Server: drop index qury was fixed
  • Eclipse plugin installer was fixed (missed bundles)
  • Many minor UI bug fixes

New in DBeaver 6.0.5 (May 26, 2019)

  • Database navigator:
  • Create object menu was improved (no redundant sub-menu)
  • Connection folders creation was fixed
  • Elements coloring was improved (for different connection types)
  • Shortcuts processing was fixed (broken shortcuts after some actions)
  • Table editor tabs activation was fixed
  • Columns editor: auto-completion was fixed in drop-downs.
  • Data transfer: export from multiple queries was fixed (target file names)
  • SQL Editor: SQL formatter was fixed (exp numbers and other minor fixes)
  • Spatial data editor:
  • Geography/geometry value editor (plaintext, WKT)
  • Numerous fixes in different SRIDs support
  • Oracle: metadata (constraints, foreign keys) reading performance was significantly improved
  • PostgreSQL:
  • Multiple query result sets support was added
  • Table partitions information was extended
  • Native database backup was fixed
  • Database creation was fixed (special characters in db name)
  • Sequence rename was fixed
  • Full schema DDL generation was fixed
  • Greenplum, Redshift: execution plan explain now supports plaintext format
  • SQLite: sample database was updated
  • Sybase (12 and older): stored procedures source reading was fixed
  • Apache Ignite: identifiers quoting was fixed
  • DB2 iSeries: schema reading was fixed
  • Extra command line parameters (connection opening)
  • Connections import from SQL Developer was fixed
  • Windows installer: config files (dbeaver.ini) backup
  • Extensions (Office, SVG, etc) installer was fixed
  • Checking for multiple DBeaver instances was added
  • Many minor UI bug fixes

New in DBeaver 6.0.4 (May 6, 2019)

  • 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 map 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 schema 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

New in DBeaver 6.0.3 (Apr 22, 2019)

  • Connection/schema selector toolbar was redesigned
  • Create object context menu was redesigned
  • Data viewer:
  • Panels UI was redesigned
  • “Copy As” command was added (CSV, HTML, JSON, etc)
  • IN filter UI was improved (previous selection save)
  • Statistics view was improved (proper view of multiline queries)
  • SQL editor: auto-indent was fixed
  • GIS spatial data viewer beta version (PostgreSQL, MySQL/MariaDB):
  • Viewer panel was redesigned, special results presentation was added
  • Multiple objects viewing support was added
  • Copy/save as picture, print, SRID selector
  • Data transfer:
  • Export progress monitoring was fixed
  • Export from custom SQL queries performance was improved (using fetch size)
  • Split output file feature was added
  • Reset UI settings menu item was added
  • Backup/restore wizards: native client configuration was added in the dialog
  • MacOS X installer was updated (JRE version update)
  • PostgreSQL:
  • Schema/tables backup wizard was fixed
  • Triggers enable/disable tool was added
  • Greenplum: tables reading for GP 4.x was fixed
  • SQL Server:
  • Use TOP to limit queries fetch size
  • Dynamic parameters binding bug was fixed
  • Table triggers enable/disable tool was added
  • Support of special characters in object names was added
  • Oracle:
  • New config option for metadata reading performance fix
  • Subpartitions browser was added
  • PL/SQL blocks parser was improved
  • Configuration of system views usage was added
  • DDL reading was fixed (problem with string truncate with some driver versions)
  • Many minor UI bug fixes

New in DBeaver 6.0.2 (Apr 8, 2019)

  • 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

New in DBeaver 6.0.1 (Apr 3, 2019)

  • 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

New in DBeaver 6.0.0 (Mar 11, 2019)

  • Navigator:
  • Filters were fixed for multi-database drivers (PostgreSQL, SQL Server)
  • Folders management was improved (move, drag-n-drop, etc)
  • Scripts ordering was fixed
  • Data view:
  • Multiple cells editor was fixed (performance)
  • Plain text presentation was improved
  • Context menus were fixed
  • PostgreSQL:
  • Views dependencies tab was added
  • Composite data types rendering and editing was fixed
  • GIS data types rendering was fixed
  • Table columns collation support was added
  • Geometry type and SRID are shown in DDL
  • Support of triggers delete was added
  • SQL Server:
  • Tables DDL generation was improved
  • Column default values render was fixed
  • Sybase procedures loading was fixed
  • BigQuery: error position discovery was added
  • Generic driver: JDBC URL
  • Dashboards rendering was fixed
  • ERD: rendering was fixed (IDEF1X compatibility)
  • Tools editor opening was fixed (sessions, locks)
  • CSV import: support of custom data/tme format was added
  • SQL editor colors were updated for dark theme
  • Multiple shortcuts were fixed
  • CrateDB driver was added
  • Elasticsearch driver was fixed (6.6 compatibility)
  • Some icons in UI were updated
  • A lot of minor UI fixes

New in DBeaver 5.3.5 (Feb 18, 2019)

  • 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

New in DBeaver 5.3.4 (Feb 3, 2019)

  • 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 Ignote 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

New in DBeaver 5.3.3 (Jan 21, 2019)

  • Connection wizard was completely redesigned.
  • Database driver icons were updated.
  • “Tip of the day” dialog was redesigned, tips were added
  • ERD: attributes visibility configuration was fixed
  • Sybase: stored procedures reading 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
  • 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
  • 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
  • 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

New in DBeaver 5.3.2 (Jan 7, 2019)

  • UUID/GUID generate function was added
  • Data transfer: “truncate target table before load” function was fixed
  • 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
  • Data editor:
  • Open With menu was added (web browser and Excel)
  • Next page auto-fetch was fixed
  • ERD:
  • Save as picture function was fixed (case-insensitive file path)
  • Attributes visibility configuration was improved
  • 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

New in DBeaver 5.3.1 (Dec 24, 2018)

  • Java 11 support was added
  • Data transfer: saving for tables/columns mappings was added
  • Extensions installation/update were fixed on Windows (infinite restart loop)
  • Linked files/folders rename 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
  • 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
  • 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

New in DBeaver 5.3.0 (Dec 10, 2018)

  • 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

New in DBeaver 5.2.5 (Nov 19, 2018)

  • 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

New in DBeaver 5.2.4 (Nov 5, 2018)

  • 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

New in DBeaver 5.2.3 (Oct 22, 2018)

  • 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

New in DBeaver 5.2.2 (Oct 8, 2018)

  • 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

New in DBeaver 5.2.1 (Sep 24, 2018)

  • 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

New in DBeaver 5.2.0 (Sep 10, 2018)

  • 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

New in DBeaver 5.1.6 (Aug 27, 2018)

  • 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

New in DBeaver 5.1.5 (Aug 16, 2018)

  • 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

New in DBeaver 5.1.4 (Jul 30, 2018)

  • 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.

New in DBeaver 5.1.3 (Jul 16, 2018)

  • 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

New in DBeaver 5.1.2 (Jul 2, 2018)

  • 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

New in DBeaver 5.1.1 (Jun 18, 2018)

  • Results viewer:
  • Filter text can be expanded (for multi-line filter values)
  • Filter editor now supports undo/redo and drag-n-drop
  • Text value editor was fixed (undo/redo commands)
  • Grouping panel UI was fixed (settings save, dark theme, keys navigation)
  • Table ordering is saved between foreign keys navigation
  • Context menu was refactored
  • SQL Editor:
  • Parser performance was improved
  • SQL formatting was improved
  • Support special characters in table names for auto-completion
  • Stored procedures execute was improved
  • Stored procedures names auto-completion was added
  • Driver manager dialog was fixed
  • ERD:
  • Palette is visible by default
  • Notes edit was fixed (+ undo/redo)
  • Table/tree editors UI was fixed for MacOS
  • Ping/keep-alive background jobs visualization was fixed
  • PostgreSQL:
  • Use fully qualified data type names in DDL
  • View default values for procedure parameters
  • Enum/set values editor was fixed
  • Revoke all permissions command was fixed
  • Show template databases
  • MySQL:
  • Event DDL was fixed
  • View DDL was fixed
  • SQL Server: datetime/datetime2 data types handle was fixed
  • HSQLDB: synonyms support was added
  • Data transfer:
  • CSV values escaping was fixed
  • Support export in SQL format for custom SQL queries
  • Finish wizard message can be suppressed
  • Localization was improved

New in DBeaver 5.1 (Jun 4, 2018)

  • Results viewer: Groupings panel was added (GROUP BY generator)
  • Results viewer: Aggregate panel was renamed to Calc
  • Results viewer: links navigation was fixed (references rendering)
  • Results viewer: show confirmation if panel data was modified
  • Results viewer: improved drag-n-drop support for all controls
  • Results viewer: icons were fixed
  • Mockdata: template generator was added
  • SQL editor: show stored procedures/functions in SQL completion
  • SQL formatting was fixed (single line comments)
  • XLS export: empty tables export was fixed
  • Update site management preference page was added
  • Columns visibility/order configuration dialog was improved
  • Date/time formatted was fixed (nanoseconds format pattern)
  • HANA: functions source code reading
  • Clickhouse: array data types support was added
  • Oracle: session elapsed time was added
  • Oracle: timestamp with timezone handler was fixed (check driver version)
  • PostgreSQL: drop sequence query was fixed
  • RedShift: driver configuration was fixed
  • Many minor UI bugfixes

New in DBeaver 5.0.6 (May 28, 2018)

  • Support of cells edit for queries with joined tables
  • SSH tunnels: test connection button was added
  • Results viewer: horizontal scroll with mouse wheel
  • Results viewer: extra header tooltips were added
  • PostgreSQL: debugger – fix breakpoints support
  • PostgreSQL: data types loading performance was greatly increased
  • PostgreSQL: search_path updating was fixed
  • PostgreSQL: array data type support was improved
  • MySQL 8+ support was fixed
  • Oracle: jobs scheduling (thanks to Neil Crow)
  • Oracle: schema create dialog improvements
  • Oracle: error positioning was improved
  • Oracle: timestamp with timezone support was added
  • Oracle: CASE statements parser was fixed
  • SQL Server: triggers reading was fixed
  • SQL Server: drop trigger feature was added
  • Vertica: table columns editor (data type, nullability)
  • Redshift: driver version update
  • Cassandra: JSON formatter for all text columns
  • ERD: include nullability in attribute type description
  • Queries history browser was fixed
  • Some keyboard shortcuts were changed (results navigation)
  • Some icons were updated
  • Spanish localization was added (thanks to Ishibashi Takken)
  • Japanese localization was added (thanks to faibistes)
  • Misc minor UI bugfixes

New in DBeaver 5.0.5 (May 14, 2018)

  • PostgreSQL procedures debugger was added in CE
  • Search in query history feature was added
  • Query manager view was redesigned
  • DBUnit data export format support was added (thanks to Henrik Hansen)
  • Eclipse Mars (and earlier) support was fixed
  • Foreign key values browser was improved (progress visualizing, values ordering)
  • Results viewer/editor key bindings activation was fixed
  • Results viewer now respects database navigator filters (default column visibility)
  • Results viewer shortcuts (fetch page/fetch all) were changed to avoid conflicts with Linux def shortcuts
  • XLS data exporter was improved (column comments support)
  • SQL formatter was fixed (special characters processing)
  • SQL Editor: auto-completion was fixed for Generic driver (including SQL Server and Informix)
  • Connect, disconnect and invalidate timeouts were added
  • PostgreSQL: view comments and permissions support was added
  • PostgreSQL: asynchronous server output reading is now supported
  • PostgreSQL: schema create was fixed
  • MariaDB: packages support was added, procedures read was fixed
  • DB2: table columns create/edit supports was added
  • Oracle CASE statement parsing was fixed
  • Misc minor UI bugfixes

New in DBeaver 5.0.4 (Apr 30, 2018)

  • Different action icons were fixed (results viewer, SQL editor, file operations)
  • Results viewer: context menu was redesigned (compacted)
  • Results viewer: scrolling shortcuts were changed
  • HighDPI support: composite icons rendering was fixed
  • Data export: SQL INSERT format support for custom SQL queries
  • Mockdata: commands contributions (menu and toolbar) was fixed
  • SQL editor: object search now can search inside object names
  • SQL editor: auto-indent was fixed (identifier replace issue)
  • SQL editor: “to upper case/to lower case” command shortcuts were fixed
  • SQL editor: bold font style configuration
  • Bookmarks drag-n-drop inserts real object name
  • Database objects create: mixed case identifiers support was fixed
  • Database aliases support was added (DB2, Oracle)
  • Diagram viewer: support aliases drag-n-drop
  • Diagram viewer: tables/columns copy action was added, context menu was redesigned
  • Table truncate support (for data transfer, mock data generators, etc)
  • Oracle: default driver version changed to 12.2
  • Oracle: expired passwords change UI
  • Oracle: DROP INDEX was fixed
  • PostgreSQL: permissions reading was redesigned
  • PostgreSQL: table columns permissions view/edit support was added
  • PostgreSQL: create function dialog redesign
  • PostgreSQL: schema DDL support was added
  • PostgreSQL: schema comments edit support was added
  • PostgreSQL: tablespace edit support was added
  • PostgreSQL: constraint indexes support
  • PostgreSQL: default schema change was fixed
  • PostgreSQL: trigger attribute view
  • MySQL: enum columns parser was fixed
  • SQLite: read-only connections support was added
  • Firebird: driver version was updated. 2.x driver was removed.
  • Firebird: SET TERM command evaluation was fixed
  • Vertica: tables, projections and columns comments support was added
  • Clickhouse: metadata read fix
  • Misc minor UI bugfixes

New in DBeaver 5.0.3 (Apr 16, 2018)

  • Event notification UI was added (commit/rollback/reconnect events)
  • Results viewer: status bar update fixed (re-layout)
  • Results viewer: filters reset action enablement was fixed
  • Results viewer: ordered UUID transformer was added
  • Results viewer: support of grid columns drag-n-drop in text editor was added
  • Results viewer: filter dictionary reading was fixed (include NULL values)
  • Results editor: script generation was improved (column values are now correctly rendered)
  • Results editor: complex data type (structures, arrays) editor UI was fixed
  • SQL editor: autocomplete was fixed (word replacement)
  • SQL formatter: keyword case configuration UI was fixed
  • PostgreSQL: function permissions editor was added
  • PostgreSQL: active schema switching was fixed (search_path patching)
  • PostgreSQL: support of PG <= 8.4 (data types info reading)
  • PostgreSQL: table comments added in DDL
  • Oracle: synonyms reading was fixed (include broken synonyms)
  • Oracle: NUMBER data type scale/precision editor was added
  • Oracle: convert query line feeds for ORacle <= 10
  • SQL Server: procedures drop was added
  • SQL Server: table comments reading was added
  • Connection invalidate job was fixed (disable disconnect on first failure)
  • Connection editor was fixed (folder list)
  • Autocommit toolbar button state refresh was fixed (on editor switch)
  • CLI: connections duplications bug was fixed
  • Query manager colors configuration was added
  • Data transfer: extra output file name template variables were added
  • Global column filters support was added
  • ERD: fully qualified table names option was added
  • ERD: export in GraphML was fixed (column data type)
  • XLSX exporter was improved (configuration UI)
  • SSHJ extension was repackaged
  • Full text searcher UI was fixed (messages)
  • Mockdata wizard UI was improved
  • RPM package dependencies fix (Java 8)
  • Misc minor UI fixes

New in DBeaver 5.0.2 (Apr 2, 2018)

  • Exasol: table row count support was added
  • SQL Server: URL generation (explicit port value) was fixed
  • Greenplum driver configuration was added
  • Data export: XLS format (NULL cell values, column comments) was fixed
  • Results viewer: plaintext + record mode error was fixed
  • Minor UI bugfixes
  • SQL editor:
  • Empty script close behavior config was enhanced
  • Resources leak (thread + memory) was fixed
  • PostgreSQL:
  • Permission grants in table DDL
  • Constraints comments support was added
  • Foreign keys comments support was added
  • Sequences support (v10) was fixed
  • Sequences comments support was added
  • Functions permissions UI was added
  • Triggers DDL was added
  • Inherited tables DDL was fixed
  • Foreign servers DDL was added
  • Foreign wrappers DDL was added
  • Database rename support was added
  • Oracle:
  • DBA views resolve was fixed
  • Standard function names highlight was fixed

New in DBeaver 5.0.1 (Mar 19, 2018)

  • Data export: markdown (wiki, confluence) format support
  • Data export: extra configuration for CSV format
  • Data export: auto-size clumns in XLS
  • Mockdata generator: UI redesign, extra configuration
  • Connection selector dialog was redesigned
  • ERD: save to image was fixed (image bounds)
  • SQL generate: queries unwrap (configurable)
  • SSH tunnel: external SSHJ implementation (ed25519 support, bouncy castle)
  • Generic driver configuration was fixed
  • PostgreSQL: table DDL fix (include table comment)
  • MySQL: global server privileges edit fixed
  • Oracle: PL/SQL parser was fixed
  • Oracle: float data type support was fixed
  • ERD in SVG format support was fixed
  • Many minor UI fixes

New in DBeaver 5.0.0 (Mar 6, 2018)

  • Mock data generator extension release. UI changes, lots of bugfixes.
  • PostgreSQL debugger (beta version)
  • PostgreSQL: constraints DDL was fixed
  • PostgreSQL: PostGIS support was fixed (array of geometry type)
  • Vertica: UDF support (read-only)
  • Vertica: flex tables support (read-only)
  • Oracle: include comments in view DDL
  • Auto-reconnect after connection failure feature was added (configurable)
  • Auto-refresh for sessions and transaction lock views was added
  • SQL editor: auto-complete for JOIN was fixed/improved
  • Metadata search was fixed (NPE)
  • Results viewer: grid background colour shows cells state
  • Results viewer: column header render was fixed
  • Excel export: support of column descriptions in header
  • Settings for the page switch saving on the connection page were fixed
  • Keyboard shortcuts for the SQL editor opening were fixed
  • Entity editor save/revert changes actions were fixed (refresh contents)
  • Decimal part rendering is now configurable for the numeric data type
  • Command line handling (-con) was fixed (drivers search)
  • Fixes for the driver editor dialog were implemented: NPE fixes, show driver ID
  • Edit connection dialog was fixed (dialog layout glitch)
  • Dialog for errors was fixed – now default button is Stop
  • Numerous localization fixes
  • Many minor UI fixes

New in DBeaver 4.3.5 (Feb 19, 2018)

  • Full UI localization (Chinese, Russian, German, French)
  • Mock data generator: additional generators and bug fixes
  • Changes for SQL Editor:
  • JOIN table/condition auto-complete
  • SQL Editor: UI for results/editor/panels switching was fixed
  • “open editor” and “switch panels” shortcuts were changed
  • warning on the “Execute in separate tabs” command for big scripts was added
  • “extract SQL from source code” command was fixed
  • Changes for Result viewer:
  • icon visibility options were added
  • rendering of floating point numbers was fixed (fraction digits are shown according to column scale)
  • JSON/XML panel editor was fixed (dirty mark on text selection)
  • Driver editor dialog was fixed (custom jars for Maven-enabled drivers)
  • Changes for MacOS X installer (pkg):
  • support of CE and EE versions on the same machine
  • allows to install DBeaver extensions
  • Changes for PostgreSQL:
  • Postgis support was added
  • HStore support was fixed (in string form)
  • UI for permission management was fixed
  • table DDL (costraints) was fixed (constraint name)
  • Changes for MySQL:
  • support of geometry (GIS) types was added
  • session manager view was improved
  • triggers DDL was fixed: trigger creation now omits database name
  • Changes for Impala:
  • driver configuration was fixed
  • SQL dialect/syntax highlighting was fixed
  • Many minor UI fixes (edited)

New in DBeaver 4.3.4 (Feb 5, 2018)

  • Mock data generator extension (beta version)
  • Import/export/script wizard allows multiple run
  • SQL formatter was fixed (comments and expressions)
  • Data export in SQL INSERT format was fixed (auto-increment columns)
  • SQL generator: JOIN support
  • Results viewer: “Fetch All” command was fixed
  • Content editor: value saving/activation was fixed
  • ERD editor: context menu was enhanced (populated with standard table commands)
  • SQL Server 2000 and earlier: schema reading was fixed
  • Sybase: procedure body reading was fixed
  • Sybase: database metadata reading was fixed
  • PostgreSQL: database switch support was added
  • PostgreSQL: identity column support was added
  • PostgreSQL: sequence management
  • PostgreSQL: default driver version was updated (42.2.0)
  • PostgreSQL: permission management was improved (sequences support) and fixed (role name escaping)
  • PostgreSQL: index comments were added to DDL
  • PostgreSQL: trigger name column was added
  • Oracle: view definition reading was fixed
  • MySQL: table filters were fixed
  • MySQL: database restore wizard was fixed (UTF encoding)
  • Firebird: stored procedure execution was fixed
  • Snowflake driver config was added
  • A few icons were fixed
  • Keyboard shortcuts were fixed (commit, rollback, results panels toggle)
  • Many minor UI fixes

New in DBeaver 4.3.3.1 (Jan 23, 2018)

  • Fix of NSIS installer (install in Program Files with Admin privileges)
  • Fix of SQL processor for PostgreSQL dialect (NPE)
  • SQL editor: query extraction was fixed (trailing delimiter)
  • SQL editor: variables support was added (${varName}, configurable)
  • SQL editor: embedded mode was fixed (UI freeze on editor refresh)
  • Results viewer: column drop-down filter was added
  • Numeric cell value dialog editor was fixed
  • Ref cursor cell value dialog viewer was fixed
  • Main toolbar was fixed (now it is visible only in DBeaver perspective)
  • UI of checkbox inline editor was fixed
  • Environment variables substitution now works for all network configurations
  • External Eclipse extension installer was fixed
  • Git integration was implemented with Eclipse Git plugin
  • External plugin repository list was enhanced (Office, SVG, Git, Eclipse Oxygen)
  • Command line support was fixed (-con + connection properties)
  • CSV export: value quoting config was added
  • PostgreSQL: syntax highlighting was improved
  • MariaDB: default column value editor was fixed
  • SQL Server: schema list reading was fixed
  • SQL Server: procedures source reading was fixed
  • Oracle: view definition (truncated) reading was fixed
  • Sybase: error handling was fixed (for queries with multiple results)
  • Firebird: 3.x driver configuration was fixed (default encoding is UTF-8)
  • Windows installer was improved
  • "All Users" mode was removed
  • /S and /D options were fixed
  • Controls internationalization was improved
  • Chinese, Russian and French localizations were improved
  • Many minor UI fixes

New in DBeaver 4.3.3 (Jan 22, 2018)

  • SQL editor: query extraction was fixed (trailing delimiter)
  • SQL editor: variables support was added (${varName}, configurable)
  • SQL editor: embedded mode was fixed (UI freeze on editor refresh)
  • Results viewer: column drop-down filter was added
  • Numeric cell value dialog editor was fixed
  • Ref cursor cell value dialog viewer was fixed
  • Main toolbar was fixed (now it is visible only in DBeaver perspective)
  • UI of checkbox inline editor was fixed
  • Environment variables substitution now works for all network configurations
  • External Eclipse extension installer was fixed
  • Git integration was implemented with Eclipse Git plugin
  • External plugin repository list was enhanced (Office, SVG, Git, Eclipse Oxygen)
  • Command line support was fixed (-con + connection properties)
  • CSV export: value quoting config was added
  • PostgreSQL: syntax highlighting was improved
  • MariaDB: default column value editor was fixed
  • SQL Server: schema list reading was fixed
  • SQL Server: procedures source reading was fixed
  • Oracle: view definition (truncated) reading was fixed
  • Sybase: error handling was fixed (for queries with multiple results)
  • Firebird: 3.x driver configuration was fixed (default encoding is UTF-8)
  • Windows installer was improved
  • “All Users” mode was removed
  • /S and /D options were fixed
  • Controls internationalization was improved
  • Chinese, Russian and French localizations were improved
  • Many minor UI fixes

New in DBeaver 4.3.2 (Jan 8, 2018)

  • UI language selector was added in preferences
  • Active schema selector UI was enhanced (filter)
  • Foreign/ref key navigation icon render was fixed
  • String cell value can be opened in a separate text editor
  • Plaintext rendering was enhanced (NULL values, delimiters)
  • Data export: export of selected columns/rows is now supported
  • SQL editor: support backslash escape in SQL strings/quoted identifiers
  • DB2: connection properties dialog was fixed (settings load)
  • SQL Server: Windows authentication option was added
  • Sybase/SQL Server: schema list read/filter was fixed
  • Sybase/SAP ASE: native jConnect driver configuration was added
  • MySQL/MariaDB: big query results fetching was fixed (for complex custom SQL)
  • PostgreSQL: procedure creation was fixed
  • PostgreSQL: role create/drop actions
  • PostgreSQL: permission management UI was added
  • PostgreSQL: table DDL generation was fixed (column comments)
  • Redis: connection properties dialog was fixed (settings load)
  • Extra CLI options for MySQL/PostgreSQL native export/import wizards
  • French localization was added (thanks to madcollector)
  • Chinese localization was updated
  • Many minor UI fixes

New in DBeaver 4.3.1 (Dec 26, 2017)

  • Merry Christmas!
  • New custom DBeaver icon set was added.
  • ×32 icons for HighDPI minotors
  • Entity editor UI was improved (properties panel)
  • Stored procedures execute console
  • Referencing tables navigation fix
  • Unique key create dialog was fixed
  • Quick filter for procedures
  • Object delete dialog was improved (CASCADE delete support)
  • Main menu localization was fixed
  • SQL Server/Sybase: schema list read was fixed
  • PostgreSQL: child tables navigation was fixed
  • PostgreSQL: money data type support
  • PostgreSQL: table DDL generate fix
  • Oracle: table DDL generate fix
  • Oracle: queues metadata (read-only)
  • Firebird: separate drivers for 2.x and 3.x
  • HANA: views/procedures DDL extraction
  • Generic: show all table triggers in catalog/schema
  • Main window title rendering was fixed (confiruable)
  • Minor UI fixes

New in DBeaver 4.3.0 (Dec 8, 2017)

  • UI localizations (Chinese, Russian, German) were added back
  • Database navigator: new objects (tables, views, columns) create was fixed
  • SQL Editor: active query extraction/parse was fixed
  • SQL Editor: proposals auto-activation was fixed
  • SQL Editor: compact SQL formatter was added
  • Results viewer: data types coloring support was added
  • Results viewer: cell value editor
  • Results viewer: dictionary edit dialog was fixed (custom criteria)
  • Driver manager dialog was improved (driver copy, sorting)
  • Main toolbar was slightly redesigned
  • Support environment variables in connection properties
  • Navicat connections configuration import was added
  • Some icons were updated (application, SQL editor)
  • Find/replace dialog was added in text edit fields (from context menu)
  • PostgreSQL: basic partitions and inheritance support in database navigator
  • PostgreSQL: view edit/create was fixed
  • Vertica: 7.x-9.x driver configuration
  • Neo4j driver configuration was added

New in DBeaver 4.2.6 (Nov 27, 2017)

  • Changelist: Results view: referencing tables view (ctrl+1) Results view: plain text presentation configuration Results view: column ordering shortcut (ctrl+0) Results view: boolean value editor was fixed (MacOS) Results view: editor activation fix (caps lock handle) SQL editor: auto-complete was fixed

New in DBeaver 4.2.5 (Nov 13, 2017)

  • Connection/schema selectors UI was improved
  • Shortcuts for connection schema select (CTRL+9, CTRL+0)
  • SQL error handle was fixed (error type detection, reconnect activation)
  • SELECT COUNT(*) transformer was fixed
  • SQL completion: multiple bug fixes
  • SQL editor: single line comment toggle was fixed
  • SQL editor: script execution UI config (editor pane maximize is now configurable)
  • SQL editor: support association with connections from another project
  • Database editor: auto-save doesn’t affect data editors
  • Results viewer: varchar to binary column view transformer
  • Results viewer: status label was fixed
  • Results viewer: timestamp value editor was fixed
  • PostgreSQL: view DDL was fixed (for alter view)
  • MySQL/MariaDB: quoted schema name handle fixed
  • Oracle: DATE data type support was fixed
  • Oracle: execution plan for queries with parameters
  • Oracle: sessions SQL read was improved
  • SQL Server: native timestamp format fixed
  • Data search: UI was fixed (performance)
  • MetaData search: UI was fixed (tree structure)
  • ER diagrams: datasource info in project explorer
  • SSH tunnel config enhanced (local port number)
  • i18n model enhancement
  • Chinese localization
  • Hex editor UI was fixed (hex panel stretching, preferences)
  • Keyboard shortcuts were fixed (conflicts with other Eclipse solutions)
  • Cloudera Impala driver config was added
  • CUBRID driver config was added
  • Office and SVG extensions moved to separate update sites (marketplace)
  • Misc UI fixes

New in DBeaver 4.2.4 (Oct 30, 2017)

  • Results editor: zoom in/zoom out support
  • Stored procedures results visualization fix
  • Active database/schema switcher was fixed
  • Bootstrap queries processing was fixed (prepared statement)
  • Command line parameters processing was fixed
  • Views/triggers create/edit was fixed
  • Metadata compare: compare views source
  • Running queries in background: UI freeze fix
  • Results viewer: columns width configuration
  • Installers icons/splash screen were updated
  • Chinese localization additions (-nl zh)
  • Connection invalidate command was fixed
  • SQL generation was improved (FQ names config for DDL)
  • Oracle: PL/SQL blocks parser was fixed
  • Oracle: FLOAT (NUMBER) data type edit was fixed
  • MySQL: extra options in database dump wizard
  • MySQL: database charset/collation edit
  • DB2: show aliases in SQL auto-completion
  • PostgreSQL: permissions panel was redesigned
  • SQLite: data types properties
  • Misc UI fixes

New in DBeaver 4.2.3 (Oct 16, 2017)

  • Java 9 support was fixed
  • SQL Editor: connection/schema selectors redesign
  • SQL Editor: divider position save
  • SQL Editor: BOM for external SQL files support was added
  • SQL Editor: queries folding was fixed
  • SQL error chain evaluation was fixed
  • SQL autocomplete for quoted and/or national identifiers was fixed
  • Results viewer: cursor reposition on refresh/mode change was fixed
  • Results viewer: reset all colorings action was added
  • Results viewer: reflect data changes in transaction monitor
  • Results viewer: right-aligned cells (numbers/dates) rendering was fixed
  • Results viewer: columns drag-n-drop was redesigned (now activated on column icon dragging)
  • Results viewer: multi-cell paste support was added
  • SQL Editor/results viewer: SELECT COUNT query transformation was fixed (omit order)
  • Dark theme support was improved
  • Support of null scale/precision for numeric data types was added
  • SQL generator: IS NULL/IS NOT NULL support was added
  • SQL generator: omit schema name feature (configurable)
  • Object editor: changes save procedure was fixed (+UI fix)
  • Office (XLSX) export: numeric/boolean cells formatting was fixed
  • Global schema/tables filters were fixed (MySQL/PostgreSQL)
  • Connections copy/paste was fixed
  • MySQL/MariaDB tables read was fixed (quoted identifiers)
  • Vertica: JDBC URL was fixed (database is optional)
  • Vertica: current schema detection/update
  • PostgreSQL: advanced data types (postgis, json, etc) resolution fix
  • PostgreSQL: procedures fully qualified names fix
  • DB2: primary key drop/edit fix
  • Oracle: synonyms read was fixed
  • Oracle: primary key drop/edit fix
  • SQL Server: GO delimiters evaluation was fixed
  • Minor UI fixes

New in DBeaver 4.2.2 (Oct 2, 2017)

  • Eclipse Oxygen (E4.7) is now default base platform. A lot of minor improvements/fixes comes along with it
  • Chinese, Russian, German localizations are back in beta test
  • Results viewer: UUID value transformer (from binary) was added
  • Results viewer: multi-cell paste support was added
  • Results viewer: aggregate functions for char/varchar columns
  • Results viewer: filter editor dialog UI was fixed
  • Connection invalidate timeout was added
  • Workspace preference page was added in standalone version
  • Database navigator refresh performance was fixed
  • Extra command line parameters support (-closeTabs, -disconnectAll)
  • SQL Editor: delimiters parser was fixed ($$ delimiters)
  • SQL Editor: unsafe queries (DELETE/UPDATE without WHERE) warning was added
  • SQL Editor: server-side ouput reading was redesigned (output for scripts was fixed)
  • SQL Editor: SQL completion preference page was fixed (global search)
  • SQL Editor: SQL completion for unicode identifiers was fixed
  • SQL Editor: parameters binding (NULL value) was fixed
  • SQL Editor: status message update was fixed
  • ER diagrams: column comments now can be enabled on diagram
  • ER diagrams: dark theme support was fixed (css)
  • Object filters was fixed (asterisk in schema names)
  • Oracle: zero scale for numeric data types
  • Oracle: REF CURSOR read was fixed (in value view dialog)
  • PostgreSQL: big table data export was fixed (memory consumption)
  • PostgreSQL: table indexes DDL was fixed (read from server)
  • PostgreSQL: sequences were excluded from table list
  • PostgreSQL: NULL array elements reading was fixed
  • Firebird: column charsets, binary columns support was added
  • PrestoDB driver config was added
  • UI freeze on transactions isolation level detect was fix

New in DBeaver 4.2.1 (Sep 18, 2017)

  • SQL editor: FK navigation was improved (open reference in new tab)
  • SQL editor: code folding was added
  • SQL editor: morph delimited text feature
  • SQL editor: SQL formatting was fixed (Oracle)
  • SQL editor: autocompletion was fixed (databases without schemas)
  • ERD: diagram rendering/nodes selection was fixed
  • ERD: export to SVG format was fixed
  • XML editor: code folding was added
  • Results viewer: CLOB reading was improved
  • Results viewer: connection name in status bar (optional)
  • Results viewer: copy column names action was fixed
  • Results viewer: complex types (structs, arrays, objects) rendering is now configurable
  • Data edit: big decimal values binding was fixed
  • Metadata editor: remember editor tab sizes
  • Database navigator: double-click behavior is now configurable (expand by default)
  • Database navigator: column data types are visible in tree (optional)
  • Bootstrap queries can use local variables
  • Connections config file loading was fixed (make force refresh)
  • Error handling: extract SQL error chain on client-side
  • MySQL: DDL read was fixed (non-English identifiers/comments)
  • MySQL: default driver version was changed to 5.1.44
  • PostgreSQL: database create/drop support was added
  • PostgreSQL: LIMIT/OFFSET support (for big tables export)
  • PostgreSQL: default generic driver version was changed to 9.4.1212
  • PostgreSQL: block statements processing was fixed
  • FireBird: domain types support (read-only)
  • SQLite: full table DDL (with indexes) support
  • Hive: query limits config was changed
  • Number of minor UI fixes

New in DBeaver 4.2.0 (Sep 4, 2017)

  • Sample database was added (SQLite)
  • New connection create fix (ordering in DB navigator)
  • Results viewer: local ordering fix (show confirmation about data loss)
  • Results viewer: copy column names/row numbers configuration dialog
  • ERD: bring to front and send to back actions
  • ERD: custom diagram coloring
  • ERD: diagram export fix (NPE)
  • ERD: SVG format export (optional extension)
  • MySQL: SOURCE keyword handler was fixed
  • MySQL: local client install detection was fixed
  • PostgreSQL: XML value edit fix
  • PostgreSQL: default tablespace info
  • Generic driver: foreign keys loading fix
  • Redshift: driver version update

New in DBeaver 4.1.3 (Aug 21, 2017)

  • Results viewer: save filters settings for each table
  • Results viewer: columns reordering with drag-n-drop
  • Results viewer: dark theme support was improved
  • SQL editor: variables support was fixed (global vars)
  • SQL Editor: hyperlinks on quoted identifiers were fixed
  • SQL Editor: autocomplete of quoted identifiers was fixed
  • SQL scripts create was fixed (for new projects)
  • Triggers source viewer was fixed (empty trigger body)
  • Auto-complete: optional support of global (in all schemas) tables search
  • Checkbox editor UI was fixed
  • Database/schema selector was fixed (application minimize problem)
  • Custom (named) object filters support was added
  • Locale configuration was fixed
  • Custom SQL queries ordering fix (quoted column names)
  • Exasol: object comments support improved, DEFINE command support
  • Oracle: all table triggers folder was added
  • PostgreSQL: SSL configuration UI was fixed
  • Informix: active database change was added
  • Informix: column names (instead of descriptions) in results viewer
  • Informix: triggers reading was fixed
  • Drivers download was fixed

New in DBeaver 4.1.1 (Jul 25, 2017)

  • SQL editor layout configuration was added
  • Results viewer: search dialog now highlighs cells
  • Connection/database selector was fixed
  • Office data export was enhanced
  • Dark theme support was improved
  • BLOB/CLOB editor was fixed
  • Numeric values editor was improved
  • Data transfer wizard was improved (columns mapping)
  • Folder editor UI was fixed
  • SQL formatting was fixed
  • Tray icon support was enhanced (can be used for long data export/import operations)
  • Oracle: PL/SQL parser was improved
  • MySQL/MariaDB: extra keywords added to SQL dialect
  • Generic driver: data types were added in navigator tree
  • Multiple UI bugs were fixed

New in DBeaver 4.1.0 (Jun 26, 2017)

  • Dark theme configuration was fixed/improved
  • Results viewer: first row insert bug was fixed
  • Results viewer: extra rendering config
  • Results viewer: find/replace dialog fixed (set focus)
  • CLOB/BLOB editor fixed (value edit/save)
  • Project explorer view fixed (ER diagrams and bookmarks folders)
  • SQL editor: additional layout configuration
  • Advanced copy/paste: additional properties were added
  • MySQL: database size property
  • MySQL: float data type editor fixed
  • PostgreSQL: ref cursors support
  • PostgreSQL: execution plan properties added
  • Oracle: DDL generation was fixed (delimiters)
  • Exasol: DDL generation was fixed, connection objects are now visible
  • Apache Drill: driver config was fixed
  • Yandex Clickhouse driver was added
  • Many minor UI fixed/improvements

New in DBeaver 4.0.8 (May 31, 2017)

  • Results viewer auto-refresh support added
  • Results viewer filter settings dialog UI wqas fixed
  • Shell commands configuration was enhanced
  • Session/Locks editor activation was fixed
  • SSH authentication was fixed (private key without password)
  • SQL completion processor performance was fixed (big number of objects)
  • SQL parameters binding was improved (empty values evaluated as NULLs)
  • Project create wizard was fixed
  • Results edit: advanced paste supports multiple rows insertion
  • SQL execution time format was fixed
  • Metadata changes are executed in transaction
  • Oracle: table triggers metadata reading was fixed
  • Oracle: save objects before compilation
  • Oracle table DDL now includes comments
  • MySQL: JSON data type support was added
  • SQL string escape was fixed (MySQL)

New in DBeaver 4.0.7 (May 15, 2017)

  • Tables/views inline filter (database navigator)
  • Open database connections from command line
  • ERD: dark theme support
  • SQL parameters fixed (param in SQL blocks)
  • SQL query execute statistics was fixed (fetch time added)
  • Project resources configuration is now persistent
  • Property editor behavior was fixed
  • SQL scripts layout config added
  • Gnome desktop config was fixed
  • SSH auth with private key
  • dialog fixed
  • Data export from SQL query was fixed (NPE)
  • UUID data type support was fixed
  • SnappyData driver has been added
  • MacOS DMG installer fix (Mac OS Sierra)
  • Many minor UI fixes

New in DBeaver 4.0.6 (May 1, 2017)

  • Entity editor hyperlinks were redesigned (active with CTRL key down)
  • SQL editor advanced copy (copy queries in programming languages source code)
  • Data transfer wizard UI fixed (columns mapping)
  • Eclipse plugins now can be installed in CE version
  • Generate SQL: single query for multiple rows
  • HSQLDB: triggers support
  • MySQL: index creation wizard was improved
  • DB2: native timestamp format support
  • Refresh action was fixed (now works in session/locks viewers)
  • Multiple result sets fetch was fixed
  • XML formatting was fixed
  • Transaction monitor UI was fixed
  • A few minor UI fixes

New in DBeaver 4.0.5 (Apr 18, 2017)

  • Transaction locks monitoring (PG and Oracle)
  • SQL scripts processing fixed (statements delimiter detect)
  • Transactions monitor UI fix
  • JSON and XML auto-formatting
  • SQL execution confirm dialog
  • Search results page: standard context menu support added
  • Error message dialog fix (huge messages)
  • Results viewer: statistics info was fixed
  • Results viewer: extra shortcuts for tab close/toggle
  • MySQL/MariaDB: support multiple result sets in single query
  • PostgreSQL: ERD rendering fix
  • Oracle: view definition fixed (column list was added)
  • LOB/XML/JSON cache fixed
  • Custom drivers configuration was fixed
  • Temp directory cleanup fix
  • Minor UI fixes

New in DBeaver 4.0.4 (Apr 2, 2017)

  • Connection editor UI fixed
  • Client-side SQL scripting (@set and @echo commands)
  • Results editor was improved (shortcuts, focus loose fix)
  • Results editor: create/copy/paste multiple rows with one command
  • CSV JDBC driver config fixed
  • Apache Drill: driver update
  • Oracle: table privileges tab, roles and users UI improved
  • Oracle: scheduled jobs and programs support was added
  • Oracle 8-10: data editor fixes
  • Maven repository list updated. Warnings for non-secure repositories
  • External SQL formatter was fixed
  • Transaction monitor UI was fixed
  • Mac OS: object editor and results editor UI rendering was fixed
  • Many minor UI fixes

New in DBeaver 4.0.3 (Mar 19, 2017)

  • SQL editor: context tooltips (F2) + database help system integration
  • Database data transfer wizard was fixed (tables/columns mapping)
  • Drivers download dialog was fixed
  • Query manager view UI improved (columns sorting)
  • Maven repositories switched to SSL versions
  • Exasol: statements execution performance was improved
  • Exasol: LUA scripts, functions
  • Oracle 8 and 9i support has been improved
  • Oracle: sequence manager was added (create/drop/alter)
  • HSQLDB extension was added (views, procedures source, sequences)
  • Hive: table data viewer/exporter fix. Array data type support.
  • Hive Spark driver configuration added
  • DB2 for z/OS: error message extraction config
  • A lot of minor UI fixes/improvements
  • All national localizations were disabled

New in DBeaver 4.0.2 (Mar 1, 2017)

  • Transaction monitor errors fixed
  • CLOB value editor fixed
  • MySQL: table create fixed
  • MySQL: column position change feature
  • MySQL: column charset/collation edit support
  • Oracle: standalone procedures navigation fixed
  • Oracle 8: metadata reading fixed
  • PostgreSQL: database switch was fixed
  • DB2 iSeries driver update
  • Dark theme fixes
  • Secured Maven repositories support
  • Connection folders creation was improved
  • Connection properties dialog was fixed (performance + datasource-specific settings)
  • Misc minor UI bugs were fixed

New in DBeaver 4.0.1 (Feb 22, 2017)

  • This is a hotfix version:
  • Oracle connector was fixed
  • DB2 for z/OS connector was fixed
  • ODBC connector was fixed
  • Commit/Rollback command enablement was fixed
  • Solaris version build was fixed
  • A few minor bugfixes

New in DBeaver 4.0.0 (Feb 21, 2017)

  • Transaction monitor
  • Pending transactions monitor dialog
  • Commit/Rollback commands are enabled only if transaction is active
  • SQL editor: performance fixes (CPU usage in idle mode)
  • SQL editor: tabs switch shortcuts added
  • SQL editor: memory leaks fixed (multiple result tabs)
  • SQL completion: quoted identifiers completion has been fixed
  • Results view: custom coloring fixed (multiple color settings for single column)
  • Results view: attributes hide/show fixed (visibility change doesn’t require results refresh)
  • Query manager view: rows coloring was fixed
  • Data export: execute external process on finish
  • CSV export: NULL value rendering configuration
  • Create index: ability to set column ordering
  • Connection keep alive now reopens failed connections
  • Status bar: shows current time zone and locale
  • Connection editor: connection folder settings save was fixed
  • SSH tunnel config: ask for password if password wasn’t saved in connection settings
  • BLOB value rendering was fixed
  • HSQLDB: embedded database shutdown fix
  • MySQL: SSL support has been improved (certificate private key support, Google Cloud support)
  • Oracle: PL/SQL packages navigation was improved (navigate from procedures and from SQL editor)
  • Oracle: fix of metadata reading for version <= 8
  • PostgreSQL: numeric columns scale/precision are now editable
  • PostgreSQL: case-insensitive autocompletion was fixed
  • PostgreSQL: new tables/columns comments save was fixed
  • SQLite: data editor was improved (SQLite synamic data type system support)
  • SQLite: read and edit of triggers and sequences
  • SQLite: native tables/views/triggers DDL
  • SQLite: tables rename support
  • Many minor bug fixes
  • Migration on Eclipse 4.6 platform:
  • DBeaver now requires Java 8
  • Support of HighDPI monitor
  • SQL editor zoom in/out function
  • Many UI fixes in GTK mode (CPU usage)

New in DBeaver 3.8.5 (Jan 31, 2017)

  • SQL editor performance fix (auto-completion)
  • Export from SQL query fix
  • Results advanced copy/paste: quote complex cell values
  • Results viewer: value view panel refresh fixed
  • Foreign key dialog: schema selector added
  • Metadata editor: copy/paste in search control fixed
  • Metadata editor: columns configuration dialog fixed
  • Generate SQL action fixed
  • PostgreSQL: schema selector fixed
  • A few minor UI fixes

New in DBeaver 3.8.4 (Jan 24, 2017)

  • Resultsets refresh UI was improved
  • SQL editor: connection selector was redesigned
  • SQL editor: auto-indent/completion was fixed
  • Use virtual keys in generated SQL
  • Generate SQL UPDATE for resultsets
  • Connection editor save was fixed
  • DBeaver identification config added
  • Maven repositories configuration UI has been improved
  • Preferences pages were reorganized
  • German localization (thanks to @Sargul)
  • PostgreSQL: table/role permissions viewer was added
  • PostgreSQL: new column create dialog added
  • PostgreSQL: disable BEGIN/END blocks processing
  • Exasol: auto-completion was fixed
  • MS SQL: DDL generation was fixed
  • Cassandra: NULL values read/write fixed
  • Data export: JSON format was fixed
  • Many minor UI fixes/improvements

New in DBeaver 3.8.3 (Jan 10, 2017)

  • Metadata viewer: columns are configurable
  • Navigator filters toggle command
  • SSH tunnel auth (password/public key) fix
  • SSH tunnel invalidate fix
  • SQL templates formatting fixed
  • SQL script execution fixed (blank lines)
  • SQL editor: empty files delete fix
  • Data viewer UI improved (column description in header)
  • Date editor: include combo-box editor was fixed
  • Connection wizard UI improved
  • Keep connection user name in secured storage
  • Connection properties edit/save fixed
  • MySQL: zero date/time value support
  • MySQL: drop index fix
  • PostgreSQL: procedure parameter names reading fix
  • PostgreSQL: sequence properties reading fix
  • PostgreSQL: CHECK constraints support
  • Teradata: JSON editor
  • Exasol: maven driver added
  • Eclipse Marketplace support added (EE version)
  • Many minor UI fixes

New in DBeaver 3.8.2 (Dec 20, 2016)

  • Hierarchical connection folders support added
  • New folders browser was added
  • Object (table, schema, etc) editor activation (after restart) was improved
  • SSH tunnel invalidation fix
  • SSH keep-alive config was fixed
  • Connections copy/paste was fixed
  • Metadata search results UI fixed
  • Data export wizard was fixed (bad performance for long SQL queries)
  • Results viewer: total row count action added
  • Results editor: drop-down editor fixed, activation on key-down fixed
  • PostgreSQL: JSON support (value copy, array view) fixed
  • PostgreSQL: extra keywords & data types highlighting
  • Firebird: SQL delimiter redefine support added
  • Oracle: procedures/packages
  • check compile status on save
  • Oracle: PL/SQL blocks execution was fixed
  • DB2: session manager UI was fixed
  • DB2: tools (runstats, reorg, etc) UI was fixed
  • Teradata: JSON support
  • Exasol: views/tables descriptions, misc fixes
  • Exasol: now uses Maven repository for driver download
  • Cassandra: new rows edit was fixed
  • Cassandra: date/time values edit fixed
  • Misc UI fixes

New in DBeaver 3.8.1 (Dec 5, 2016)

  • Object editor: many fixes in properties editor/refresh
  • Results editor: row data refresh after insert/update
  • ERD: refresh action was fixed
  • SQL queries execution was fixed (multiple statements, params binding)
  • SQL completion was fixed
  • Generic: auto-increment columns creation support (H2, Derby, Teradata, MSSQL)
  • H2: new database extension (supports views source, sequences)
  • MySQL: dump/restore wizard fixed
  • PostgreSQL: local client home configuration fixed
  • PostgreSQL: triggers properties improved
  • Oracle: triggers caching fixed (performance)
  • Cassandra: SSH tunnel support added
  • MongoDB: support of replica servers
  • Secure passwords storage support (EE)
  • Misc minor UI fixes

New in DBeaver 3.8.0 (Nov 22, 2016)

  • SQL editor tabs management was redesigned
  • Object editor UI was redesigned
  • Basic icons were updated
  • Results viewer: web hyperlinks support, URL transformations, web pages viewer
  • PostgreSQL: database dump/restore support was added (pg_dump/pg_restore)
  • PostgreSQL: admin tools added (analyze, vacuum, truncate)
  • PostgreSQL: trigger properties were fixed
  • PostgreSQL: view triggers support
  • MariaDB: local client detection fixed
  • Cassandra: query trace panel added
  • Oracle: tablespace management was added
  • Oracle: SQL error position detection improved
  • Exasol: high speed load/unload to csv
  • Exasol: Virtual schema support
  • MacOS: product info (plist) was fixed
  • SQL Editor: dynamic parameters binding fixed (+dialog redesign)
  • SQL Editor: status toolbar was fixed/improved (warning list)
  • SQL completion fix (extra options in preferences)
  • SQL generator fix (DDL for complex objects like packages)
  • Many minor UI fixes

New in DBeaver 3.7.8 (Oct 31, 2016)

  • Results viewer was fixed (numerous bugs were fixed in refresh, navigation, filters, ordering, etc)
  • FK create dialog was fixed
  • Oracle: schema filters were fixed
  • Oracle: NLS date format config
  • SQL Server/Generic: procedure names were fixed
  • Taradata: driver config was fixed
  • Evaluate SQL Expression command was added
  • A few minor UI problems were fixed

New in DBeaver 3.7.7 (Oct 24, 2016)

  • Table/constraint/index edit dialogs were improved
  • Date/time values rendering was redesigned (for export and SQL generation).
  • CLOBs encoding problem was fixed
  • DBeaver version check/update was fixed
  • Statements timeout config fixed (+Cassandra support)
  • SQL Editor: script execution visualization was added
  • ERD: types names rendering was fixed
  • Drivers download UI was improved
  • Disconnect All command added
  • MySQL: triggers create/refresh was fixed
  • MySQL: column creation dialog
  • PostgreSQL: hyperlinks/object navigation was fixed
  • Oracle: CLOB/BLOB export was improved
  • ODBC: connection initialization was fixed
  • Results viewer UI redesign
  • Exasol extension:
  • DDL for views, tables, scripts
  • Table editor
  • Connection objects browser
  • Session manager
  • Security browser
  • Explain execution plan

New in DBeaver 3.7.6 (Oct 10, 2016)

  • ODBC: database metadata reading was fixed
  • PostgreSQL: SQL autocomplete fixed (with schema name)
  • PostgreSQL: multi-dimension arrays support
  • Oracle: advanced constraint types support
  • MS SQL: drop table in non-active database fix
  • SQL execution: query metadata reading is now configurable
  • Results viewer: metadata extraction (attribute binding) is now configurable
  • Results viewer: copy column/row names command introduced
  • Results editor: fixed activation on key press
  • SQL completion: auto completion improved and enabled by default
  • SQL formatting: special characters formatting was fixed
  • Windows installer: fixed support of target folder (/D) in silent install (/S)
  • ERD: fixed problem with multiple unique keys
  • Metadata browser: objects refresh was fixed
  • Metadata browser: column values rendering fixed
  • CSV export: data formats settings fixed
  • UI fixes for better GTK support
  • Added support of Open JDK 9
  • Many minor UI bugfixes

New in DBeaver 3.7.5 (Sep 26, 2016)

  • Aggregate functions: Distinct count, Min/Max for non-numeric types, Mode and Median functions were added
  • MetaData panel was added in result panels
  • Results filters/ordering improvement (support of joins)
  • Data transfer: columns mapping was fixed (now support columns skip), BIGINT datatype support was fixed
  • MetaData compare wizard was fixed (PG)
  • JSON and XML support in value editor
  • Value edit panel: misc fixes (gtk)
  • ER diagrams: entity/attributes colors were fixed
  • Attributes binding performance increased
  • SQL completion processor was fixed
  • Multi-project workspaces support was improved
  • PostgreSQL: view and materialized view edit, a few metadata additions
  • MySQL: by default uses 5.x drivers to avoid problems with server charset
  • Oracle: metadata reading was improved
  • SQL Server: table data viewer fixed (use fully-qualified table name)
  • RedShift: driver update (+ support of LIMIT in table queries)
  • A lot of minor UI fixes

New in DBeaver 3.7.4 (Sep 13, 2016)

  • Search UI was redesigned (standalone version)
  • Search in files (SQL) was added
  • Value view panel: save and auto-save command were fixed. UI was fixed.
  • SQL autocomplete was fixed
  • Generate SQL from results: row order was fixed
  • CSV export was fixed (values quotation)
  • Navigator filters edit/update was fixed
  • MySQL: trailing SQL comments issue was fixed
  • MySQL: index prefix (sub part) support was added
  • MySQL: tables copy/paste feature was added
  • MySQL: auto-complete was fixed (use current schema for objects search)
  • PostgreSQL: materialized view indexes support added
  • PostgreSQL: views source code formatting fixed
  • PostgreSQL: array type handler fixed
  • PostgreSQL: data type aliases support was added
  • PostgreSQL, MS SQL: DROP INDEX was fixed
  • Many minor UI fixes

New in DBeaver 3.7.3 (Aug 29, 2016)

  • Result set UI was redesigned (panels)
  • Results aggregation panel added
  • Navigator filters management was improved
  • ERD attributes view is now configurable (data type, icon, nullability)
  • Object editor breadcrumbs UI was redesigned
  • Advanced results copy was improved (row divider)
  • Results metadata resolve was fixed (problem with SQL expressions was resolved)
  • Run query from Query Manager view
  • Enum data type editor was fixed
  • Data export (CSV, XML and JSON) was fixed
  • DBeaver projects export/import was fixed
  • SQL parameters binding dialog was fixed
  • SQL parser was updated (performance problem with complicated queries was resolved)
  • SQL code completion now uses navigator filters
  • DDL generation was improved (multiple objects support)
  • Plaintext presentation was fixed (column reorder)
  • SOCKS proxy support was improved (PostgreSQL)
  • Support system variables in driver.xml file
  • Oracle: TNS connection fixed
  • Oracle: TNSNAMES custom path support
  • PostgreSQL: struct data types support was fixed
  • PostgreSQL: objects lookup was fixed
  • MySQL: single line comments were fixed
  • Many minor bugfixes and improvements

New in DBeaver 3.7.2 (Jul 26, 2016)

  • PostgreSQL: procedure parameter types fix
  • Oracle: schema metadata read fixed
  • DB2 v11: metadata read fix
  • DB2: DECFLOAT support fixed
  • MySQL: alter user SQL fixed
  • MySQL: procedure body read fixed
  • SQL keywords fix
  • SQL quoted identifiers support fixed
  • ResultSet SQL generation redesign
  • ResultSet refresh fix
  • ResultSet print (plaintext)
  • Locked connections support
  • Import connections from CSV/XML
  • Import connections from SQL Developer
  • Bookmarks folders support fixed
  • Search data: search in UUID columns
  • Many minor bugs were fixed

New in DBeaver 3.7.1 (Jul 11, 2016)

  • DBeaver logo and icons were redesigned
  • Results order/refresh has been fixed
  • PostgreSQL: alter column SQL fixed
  • Oracle: PL/SQL block processing was improved (DECLARE/BEGIN/END)
  • Oracle: output reading was fixed
  • JDBC: case-sensitive indexes reading was fixed
  • Results filter menu was extended
  • Project explorer view: scripts can be copy/pasted from OS file system
  • SQL keywords were updated
  • Korean localization was added

New in DBeaver 3.7.0 (Jun 28, 2016)

  • Context help system added
  • Filters dialog improvements (IN clause, dictionary browser)
  • Filters context menu was added (F11)
  • Multi-cell paste command was added (copy-paste from Excel, etc)
  • SQL editor + external files support improved.
  • SQL Editor auto-indent fixed
  • Row count limit usage fixed
  • Refresh connection URL on settings change (fix)
  • Saved passwords management fixed
  • Version update dialog/incremental update fixed (EE)
  • Drivers management dialog fixed
  • Results viewer: multiple bugfixes
  • MySQL: triggers create/drop fixed
  • MySQL: create procedure fixed
  • PostgreSQL: create/alter procedure fixed
  • Oracle: foreign key drop fixed
  • Oracle: BFILE type support added
  • Virtuoso: driver config added
  • CSV: driver configuration updated (maven)
  • Redis: beta version of Redis extension
  • Cassandra: InetAddress/UUID data types support, binary data type handle was fixed
  • Query manager persistence was fixed
  • A lof of minor UI fixes

New in DBeaver 3.6.10 (Jun 6, 2016)

  • Fixed problem with DBeaver startup on some machines
  • Cell value editor redesigned
  • Array data type support
  • Help system fixed
  • SQL editor auto-save feature was added
  • SQL editor encoding issues were fixed
  • SQL preview dialog encoding issue was fixed
  • SQL editors reopening was fixed
  • Netezza extension has been added
  • PostgreSQL: security exception handling
  • MySQL: database import tools was fixed
  • DB2: DDL extraction fixed ( for old drivers)
  • EE version now supports incremental version update
  • Misc UI fixes

New in DBeaver 3.6.9 (May 31, 2016)

  • SQL completion fixed
  • Tables data export fixed
  • Grid control UI fixed
  • Arrays edit support added
  • Misc minor UI fixes
  • MySQL: index creation fixed
  • MySQL: extra keywords support
  • PostgreSQL: functions rename/delete fixed
  • PostgreSQL: functions, tables comments read/write
  • PostgreSQL: CHECK constraints
  • Cache: streams reading
  • Redis: keys navigation improved
  • Redis: commands execution in SQL editor

New in DBeaver 3.6.8 (May 23, 2016)

  • External projects/external SQL files are now managable
  • OS shell integration was added
  • Resource management was improved
  • SQL preview in data editor
  • Oracle: TNS names usage was fixed
  • PostgreSQL: SQL completion was fixes
  • PostgreSQL: schema and tables rename support was added
  • MySQL: functions source code read was fixed
  • MySQL: binaries dump in hex support was added
  • Cassandra: timestamp representation is now configurable
  • Teradata: tables, views, procedure DDL
  • SQL editor tabs can be pinned
  • SQL editor “link with navigator” command was improved
  • SQL completion now uses fuzzy search
  • ERD uses table filters
  • Binaries presentation was fixed
  • A lot of bug fixes and UI improvements

New in DBeaver 3.6.7 (May 10, 2016)

  • PostgreSQL: function-based indexes support
  • PostgreSQL: columns search added
  • PostgreSQL: triggers source viewer fixed
  • PostgreSQL: foreign key creation fixed (delete/update rules)
  • MySQL: database dump fixed (command line parameters)
  • MySQL: stored procedures editor fixed
  • DB2: unisuq key creation fix
  • ODBC driver fixed (Java 8 for Windows)
  • Redis: pre-alpha version of Redis extension in EE version (only for testing)
  • Table unique key search fixed (do not use nullable columns)
  • Connection properties dialog was fixed
  • ResultSet context menu redesigned
  • SQL editor context menu redesigned
  • CSV exporter fixed (values escape)
  • Project create fixed
  • Binary column encoding was fixed (hex format)
  • Sound notifications support added
  • Database navigator refresh error handler added
  • Many minor UI bugs were fixed

New in DBeaver 3.6.6 (Apr 26, 2016)

  • Column transformers (view numbers in a specified radix, view milliseconds as dates, etc)
  • MongoDB: editor was fixed
  • MongoDB: document renderer (JSON) was improved
  • PostgreSQL: minor metadata fixes
  • MySQL: database export was fixed
  • Apache Phoenix driver was added
  • SQL editor fixes
  • Ignore broken JDBC drivers (MySQL, MariaDB)

New in DBeaver 3.6.5 (Apr 15, 2016)

  • PostgreSQL: table data update fix (CRITICAL)
  • PostgreSQL: metadata read fix
  • MySQL: database export fix
  • Oracle: custom PLAN table creation
  • Windows installer now shipped with JRE 1.8

New in DBeaver 3.6.4 (Apr 11, 2016)

  • MySQL: database export wizard improved (+ DEFINER remove feature)
  • Oracle: metadata read performance improved
  • PostgreSQL: metadata read fixed for version before 9.x
  • PostgreSQL: temp/toast schemas access added
  • MongoDB: document update/delete fixed
  • SQLite: datetime columns read/update fixed
  • GemfireXD: driver updated
  • SQL keywords were updated
  • Misc UI bugfixes

New in DBeaver 3.6.3 (Mar 28, 2016)

  • MySQL: support of DELIMITER command
  • PostgreSQL: metadata reading fixed
  • Cassandra: functions and aggregates support added; date/time and UDT bindings fixed
  • Connections keep-alive support
  • Keywords case auto-convert
  • Source code paste conversion
  • SQL formatter: fixes and improvements
  • SQL formatter: external formatter support
  • SQL preferences redesigned
  • Many minor fixes

New in DBeaver 3.6.2 (Mar 14, 2016)

  • Cassandra 3.x support was added. New data types, metadata browser.
  • MongoDB 3.x authentication support was added.
  • PostgreSQL: SSL support, foreign tables support, database switch, metadata managers improved.
  • MySQL: SSL support was added.
  • Oracle: table DDL generator improved.
  • Many minor UI fixes and improvements.

New in DBeaver 3.6.1 (Feb 29, 2016)

  • PostgreSQL: multi-database support was fixed.
  • PostgreSQL: Older (

New in DBeaver 3.6.0 (Feb 21, 2016)

  • PostgreSQL: new extension was added (metadata editor, data types, sessions, inheritance, support of arrays, structures, enums, uuids, hstore, etc).
  • Cassandra: driver was updated to 3.0
  • DB2: nicknames, temp tables, execution plan
  • Amazon Redshift driver was added
  • SQL generation was fixed
  • Stored procedures/views save was fixed
  • SQL editor statement highlighting was redesigned
  • Data transfer fixes (binary data export)
  • Property viewer was fixed
  • UI freezes during save were fixed
  • A lot of minor UI fixes

New in DBeaver 3.5.9 (Feb 8, 2016)

  • Color results (based on column values)
  • UI freeze during table data save was fixed
  • SSH tunnel: password prompt was fixed
  • Properties editor fixed
  • Resources (scripts, diagrams, etc) copy/paste support was added
  • SQL formatter fixed (WHEN .. THEN)
  • Resultset filter dialog was improved
  • Data import wizard was fixed
  • Identifiers (table/column names) quote was fixed
  • Metadata compare error was fixed
  • ERD loading (contents) was fixed
  • MySQL/PostgreSQL/Vertica: SELECT .. LIMIT bug was fixed
  • Oracle: table rename fixed
  • Oracle: tnsnames parser was improved
  • Teradata: default port set
  • A few minor UI bugs were fixed

New in DBeaver 3.5.8 (Dec 28, 2015)

  • SQL completion was fixed
  • Results filtering (by custom value) was fixed
  • DDL generation was added (from context menu)
  • Duplicated procedures were removed
  • Enum types support was fixed
  • Dictionary tables editor was added
  • Temporary files cleanup was fixed

New in DBeaver 3.5.7 (Dec 21, 2015)

  • Filter panel wa fixed (query text, ui issues)
  • Version upgrade issue fixed (NPE on startup)
  • Columns default value change fixed (quotes)
  • Context tools menu added (ALT+`)
  • Eclipse plugin: workspace save/restore warnings fixed
  • Scripts management redesigned (content preview, recent scripts)
  • Results grid control improved (tooltips, icons)
  • Generate object DDL command added
  • Duplicated procedures/functions fixed
  • MySQL: new database charset/collation options was added
  • SQLite: foreign keys resolution was fixed
  • SQLite: BLOB/CLOB editor fixed
  • MongoDB: connection security issue fixed
  • Many minor UI fixes

New in DBeaver 3.5.6 (Dec 9, 2015)

  • Foreign key edit in value view panel
  • Editor refresh (f5) was fixed
  • Driver editor UI improved
  • Standard SQL keywords added
  • MySQL: events support was added
  • MySQL: indexes metadata was improved
  • PostgreSQL: OID and HSTORE columns handle was fixed
  • Many minor UI fixes

New in DBeaver 3.5.5 (Nov 30, 2015)

  • Grid control was redesigned (filters, navigation, inline editors)
  • Triggers support was added for PostgreSQL, SQL Server, Sybase, Firebird, Informix
  • Processing of SQL blocks (begin/end) was fixed
  • Save of metadata changes was fixed
  • SQL editor connection selector was fixed
  • Data search (full-text) was fixed
  • Invalidate (reconnect) behavior was fixed
  • Persistent query filters history (EE version)
  • Metadata editor (views, tables, etc) refresh was fixed
  • PostgreSQL: text (clob) columns handle fixed
  • MySQL: “enum” and “set” data types support fixed
  • MySQL: partitions information reading was fixed
  • Firebird: views and procedures source code generation was fixed
  • Oracle: use DBA_* views when possible
  • Oracle: read new ROWID for inserted rows
  • Sybase: views, procedures and triggers source code
  • SQL Server/Sybase: hyperlinks detection fixed
  • UI freeze was fixed (metadata changes save)
  • Some standard Icons was changed
  • Minor UI fixes

New in DBeaver 3.5.4 (Nov 17, 2015)

  • New objects creation was fixed
  • Foreign key navigation (back/forward) was fixed
  • Paste in property editor (inline) was fixed
  • MySQL: connection dialog fixed
  • DB2: MQT indexes support was added
  • PostgreSQL: date time support was fixed
  • Firebird: procedures/views DDL was fixed
  • Oracle: block statements (begin .. end) execute was fixed
  • CLOB/text columns edit was fixed
  • Query manager: queries now formatted with parameter values
  • RPM package fixed (Fedora 20+ format)
  • Editors UI was improved (icons)
  • Keyboard shortcuts fixes

New in DBeaver 3.5.3 (Nov 10, 2015)

  • Drivers download UI was fixed.
  • Windows: installer has been fixed (version update).
  • PostgreSQL: inline editor fixed. Custom SQL queries results are now editable. Native data types loading was fixed.
  • Oracle: metadata reading performance was improved. IOT support added.
  • Oracle structures edit support fixed. XML edit support fixed.
  • Data export: column name quoting added for SQL INSERTS format.
  • Query manager UI improved (SQL formatting).
  • Properties view was fixed.
  • Floating-point numbers default format was changed.
  • Metadata read/edit: a few minor fixes.

New in DBeaver 3.5.2 (Nov 2, 2015)

  • Drivers download UI was fixed
  • Checkbox editor UI was fixed (MacOS)
  • JDBC drivers (Maven artifacts) dependencies resolution added
  • Windows installer was fixed (libraries unpacking error)
  • Data export: JSON format support was added
  • Solaris (x86) version is back in business
  • Table/columns alter fixed (column NULL/NOT NULL and DEFAULT modifiers)
  • SQL editor: hyperlinks resolution was fixed
  • SQL editor: active query extraction was fixed (multiline comments support)
  • SQL scripts creation (in a folder) was fixed
  • Redundant SQL scripts cleanup was added
  • MySQL comments handling was fixed (escaping)
  • MS Access (UCanAccess) driver updated
  • Firebird driver updated
  • Apache Hive driver was added
  • Apache Drill driver was added
  • Drivers icons added
  • Program icon fixed (Linux)
  • DBeaver sources moved to GitHub

New in DBeaver 3.5.1 (Oct 5, 2015)

  • Table columns rename feature added (MySQL, DB2, Oracle)
  • Possibility to create embedded database added (Derby, H2)
  • Templates assistant feature added (Shift+Tab)
  • Launcher icons fixed
  • MS Access driver updated
  • Informix driver updated
  • Multiple config fixes support fixes
  • Export of MySQL routines added
  • Multiple resultsets support added to DB2
  • Decimal columns handling fixed
  • Stored procedures/packages loading fixed (UI freeze fixed)
  • Maven artifact version resolve fixed (exclude alpha/beta versions)
  • DBeaver now depends on Java 1.7
  • A few UI fixes

New in DBeaver 3.5.0 (Sep 28, 2015)

  • Driver manager and driver download dialogs were redesigned and improved.
  • Connection wizard was improved. Driver settings button added.
  • DBeaver now uses Maven repositories to download JDBC drivers.
  • Support of Maven artifacts was added to driver editor dialog.
  • Oracle and DB2 JDBC drivers were removed from DBeaver distribution. Now they have to be downloaded manually (due to license restrictions).
  • Data formatter was fixed (problem with cached configuration).
  • Export to SQL INSERTs was fixed (quotes).
  • Multiple connections configuration files support added (DBeaver loads all config files matching .dbeaver-data-sources*.xml).
  • Many minor UI fixes.
  • Base platform was changed to Eclipse 4.5 (Mars). A few UI bugs in standalone version were fixed with this migration.
  • DBeaver migrated to Tycho build system instead of Ant headless builds.

New in DBeaver 3.4.5 (Aug 24, 2015)

  • Apache Derby extension was added (view source, sequences, etc)
  • SQL editor now scrolls to error position (Oracle, MySQL, PostgreSQL, Firebird, Derby)
  • Output messages were fixed (MSSQL)
  • Sequences were fixed (PostgreSQL)
  • MongoDB 3.x support added
  • Preference pages were redesigned
  • Plaintext results presentation configuration was added
  • Eclipse 4.5 (Mars) support added for plugin version
  • CSV export config improved
  • ERD export in GraphML format was added
  • A few hanging/UI freeze problems were fixed
  • Misc UI bugs were fixed

New in DBeaver 3.4.4 (Jul 29, 2015)

  • It fixes missing ER diagrams tab.

New in DBeaver 3.4.3 (Jul 27, 2015)

  • Oracle: metadata loading performance improved (12g)
  • SQLite: driver updated
  • SQLite: foreign keys loading fixed
  • PostgreSQL: sequences support added
  • Firebird: sequences support added
  • MySQL: columns extra info added (ON UPDATE, etc)
  • BIT/TINYINT and LONGVARCHAR types support fixed
  • Date/time value editor improved
  • BLOB/CLOB editors fixed
  • CLOB values cache support added (+configuration)
  • GoTo database objects dialog was fixed
  • Find/Replace dialog in results was fixed
  • SQL editor: parenthesis matching fixed
  • Results cell value editor fixed and improved
  • DDL generation improved
  • SQL parameters handle fixed (+configuration)
  • Transactions management fixed
  • Query manager fixed (updated row count si now correct)
  • UI freeze problems fixed
  • Document editor support added for MongoDB JSON documents and Oracle XML tables
  • A LOT of minor UI bugs was fixed

New in DBeaver 3.4.2 (Jun 30, 2015)

  • Stored procedures support was added in SQL Editor
  • Connections wizard and driver editor were improved
  • Bootstrap SQL queries config was added
  • Embedded databases support was improved
  • Possibility to disable editors reopen was added
  • Keyboard shortcuts were fixed
  • DB2 table names escaping was added
  • DB2 read-only connection was fixed
  • LOB export was fixed
  • Multi-connection initialization was fixed (auto-commit, transactions isolation level, current schema)
  • Cassandra multi-connection issue fixed
  • Persistent Query Manager history was added (no UI yet)
  • Many other minor UI fixes

New in DBeaver 3.4.1 (Jun 3, 2015)

  • Now DBeaver can create separate connections for each SQL editor (configurable)
  • Connection invalidate improved
  • Plain text presentation was fixed
  • Date/time editor was fixed
  • Many minor UI bugs were fixed

New in DBeaver 3.4.0 (May 18, 2015)

  • Informix database extension was added
  • Resultset scrolling UI was fixed. Auto-fetch of results next page if now configurable.
  • Date/time editor was redesigned + nanoseconds support added
  • Custom SQL delimiter support was added
  • Complex SQL (DDL) execution was improved
  • Association rendering in ERD was fixed
  • Vertica extension was fixed (results scrolling support)
  • Many minor UI bugfixes
  • Licensing was made consistent (GPL2)
  • EE version branding was fixed

New in DBeaver 3.3.2 (Apr 22, 2015)

  • Driver license accept is now required
  • SQL parameters binding dialog was fixed
  • Error dialog was fixed
  • Added drivers configuration for NuoDB, GemfireXD, ExaSol
  • SQL formatter was fixed
  • Data transfer DDL generator was fixed
  • Data transfer performance was improved
  • LIMIT clause usage was fixed + SQL limit configuration was added
  • ERD UI fixes
  • Document renderer (JSON) was improved (MongoDB)
  • UI freeze on disconnect was fixed

New in DBeaver 3.3.1 (Apr 14, 2015)

  • Results viewer UI was fixed and improved
  • Plaintext results viewer was fixed (columns width, scrolling, etc)
  • Dark theme support was improved
  • Single entity diagrams (ERD) were improved (show more connections)
  • Hex editor UI was fixed
  • GTK: context menus was fixed
  • GTK: UI freeze in cell editors was fixed
  • Vertica extension was added (views and procedure source code)
  • SQL Server & Vertica: big resultsets reading was fixed
  • PostgreSQL procedures source code viewer was improved
  • DB2: nanoseconds support in date/time data types was added
  • Cassandra: BLOBs columns reading was fixed
  • MongoDB: JSON & XML viewer added
  • Many minor UI fixes

New in DBeaver 3.3.0 (Mar 30, 2015)

  • Plain text results presentation added
  • Results viewer redesigned
  • DB2: metadata fixes (indexes, functions, table DDL, keywords)
  • SQL Server: extension added (views definition and procedures source code now available)
  • PostgreSQL: explain plan support added
  • SQLite: driver version update
  • CSV-JDBC: driver version update
  • SQL autocomplete fixed
  • SQL parser improved
  • Data transfer fixed (column types auto-cast added)
  • Results navigation fixed (keep filter values after navigation)
  • Mongo DB:
  • Connection invalidate
  • Data type management improved
  • Cassandra:
  • Cassandra Thrift is now obsolete. Legacy (0.x-1.x) Cassandra extension removed from DBeaver
  • Map, set and list types support added
  • Data type management improved
  • Tables autocomplete added
  • UUID type handler fixed

New in DBeaver 3.2.0 (Mar 11, 2015)

  • Data transfer wizard UI improved
  • Cross-database data transfer fixed + performance significantly improved
  • Object editor UI changed
  • Many minor UI improvements and bugfixes
  • MongoDB extension (EE version):
  • Support of JavaScript expressions/queries in SQL editor
  • Multi-db authentication support
  • Create/delete collections/databases
  • Server functions (JS) and users view

New in DBeaver 3.1.5 (Feb 24, 2015)

  • Eclipse plugin update site was fixed
  • Parameters binding dialog was fixed
  • Data export was fixed (by-segment reading)
  • Data types load fix (PostgreSQL)
  • Copy/paste in resultset was fixed
  • SQL autocomplete was fixed
  • Scripts titles are now configurable
  • A few minor UI bug was fixed

New in DBeaver 3.1.4 (Feb 16, 2015)

  • Eclipse plugin version now works for older Eclipse versions
  • SSH auth was fixed
  • SSH logging was added
  • Max rows issue was fixed (MS SQL)
  • MS Access driver was fixed
  • Results control toolbar was fixed

New in DBeaver 3.1.3 (Feb 9, 2015)

  • Dark theme support was added
  • Resultset scrolling was fixed
  • Multiple results fetch (SQL Server, Sybase) was fixed
  • Driver tree was redesigned
  • SSH tunnel private key passphrase support was added
  • JDBC driver class discovery was improved
  • Schema filter was fixed
  • Table/column creation was fixed
  • NULL values insert was fixed
  • Datasource configuration save was fixed
  • H2 driver was updated
  • Many minor UI problems were fixed

New in DBeaver 3.1.2 (Jan 13, 2015)

  • Cassandra 2.1.x support was added
  • Apache Derby driver was updated
  • ResultSet scrolling bug was fixed
  • Data export wizard was fixed
  • DB2 execution plan was fixed
  • SQL editor execution log was fixed

New in DBeaver 3.1.0 (Dec 8, 2014)

  • Full-text database search feature added
  • SQL queries parser was fixed
  • DBeaver perspective and initial windows layout were improved
  • SQL hyperlinks and object navigation now supports fully-qualified names
  • Data export (in isolated connection) has been fixed
  • Primary keys/indexes read has been fixed (MSS SQL, DB2 z/OS, and SQLite)
  • Resultset navigation has been fixed (now it keeps filter settings)
  • Many other minor UI fixes

New in DBeaver 3.0.2 (Oct 16, 2014)

  • We rolled back to Java 6
  • Custom queries results are now editable
  • SQL parser/formatter was improved
  • SSH tunnel connection timeout was added
  • Many minor bugfixes and improvements

New in DBeaver 3.0.1 (Sep 10, 2014)

  • Firebird and PostgreSQL extensions were added (views and procedures definition view now supported)
  • MongoDB secured connections support waa added
  • Indexes information read was fixed
  • SQL editor was fixed
  • Oracle metadata read was fixed
  • Data transfer wizard configuration was fixed

New in DBeaver 3.0.0 (Sep 10, 2014)

  • New Cassandra and MongoDB extensions are not open source (but free to use).
  • Eclipse plugin version includes only Community edition plugins.
  • Standalone version is now based on Eclipse 4.4 (Luna).
  • Java7 is now default JRE for DBeaver.
  • And many bugfixes and minor UI improvements were added as usually.

New in DBeaver 2.4.3 (Jul 18, 2014)

  • Table constrains reading fixed
  • SSH tunnel instantiation fixed
  • Editors reopen fixed
  • Data grid UI improved
  • Data grid toolbar fixed
  • jTDS driver updated
  • SSL for MySQL (alpha version)
  • Generic driver now splits tables and views
  • Oracle XML type support improved
  • ERD diagrams made IDEF1X compatible
  • Many minor UI fixes

New in DBeaver 2.4.2 (Jun 18, 2014)

  • JRE 7 is now default Java version for DBeaver (however DBeaver still works under Java 6). Windows installer now contains JRE 7 (update 60).
  • Database selection toolbar was fixed
  • Auto-completion was improved (duplicated objects removed)
  • DDL generation was fixed (Vertica and Sybase)
  • A few minor bugfixes of UI improvements

New in DBeaver 2.4.1 (May 20, 2014)

  • Results scrolling was fixed
  • DB2 tables edit was fixed (RID_BIT problem)
  • SQLite driver configuration fixed (stable driver version used by default)
  • SQL editor opening error fixed

New in DBeaver 2.4.0 (Apr 30, 2014)

  • Foreign keys navigation added
  • Structured and collection types support added
  • Results viewer improved
  • A lot of minor bugfixes and improvements

New in DBeaver 2.3.8 (Feb 25, 2014)

  • SQLite driver has been fixed
  • DB2 metadata read was fixed
  • Generic driver metadata read was improved
  • Data export was improved (SQL format)
  • Result set navigation was improved

New in DBeaver 2.3.7 (Feb 4, 2014)

  • MySQL maintenance tools (check, analyse, etc) was added
  • Oracle table tools (analyse, gather statistics) was added
  • DB2 table truncate tool was added
  • SQLite driver was updated, metadata read has been fixed
  • SQL autocomplete fixed
  • Server output window added in SQL editor
  • ResultSet viewer UI was fixed
  • Minor UI fixes

New in DBeaver 2.3.6 (Jan 22, 2014)

  • Resultset viewer/editor was redesigned
  • SOCKS (4/5) proxy support was added
  • Connection network configuration UI was redesigned
  • MS Access driver was updated
  • SQLite SQL statements processing was fixed
  • DB2 metadata browser has been fixed
  • Oracle sequences search was added
  • Many additional UI preferences was added
  • Minor UI fixes

New in DBeaver 2.3.4 (Dec 16, 2013)

  • Database objects quick search dialog has been added
  • Query execution progress/cancel UI was redesign
  • SQL auto-completion was improved
  • Results find/replace has been fixed
  • Multiple result sets support (SQL Server & Sybase) added
  • DB2, Oracle extensions was improved. Legacy DB2 LUW driver added
  • MySQL driver updated
  • Many UI fixes and improvements

New in DBeaver 2.3.2 (Nov 18, 2013)

  • Open editors are now restored after restart
  • Connections’ folders support has been added
  • SQL auto-completion was improved
  • Auto-completion and hyperlinks for procedures/packages has been added
  • Database search results are now structured
  • Disconnect detection by error code has been added
  • Driver management UI was redesigned
  • DB2 for AS 400 driver has been added
  • H2, Derby and HSQLDB drivers were updated
  • Minor fixes in Oracle, MySQL and DB2 plugins
  • Data transfer columns mapping fixed
  • SQL processing UI fixed
  • Minor UI bugfixes

New in DBeaver 2.3.1 (Oct 28, 2013)

  • DB2 extension replaces generic DB2 driver (note: this applies only to DB2 LUW, DB2 for z/OS still use old generic driver)
  • Separate database connection used for metadata reading (configurable)
  • Pseudo columns (ROWID) support added for Oracle and DB2. Data editor now uses ROWID as primary table identifier (instead of PK).
  • Local/server-side result set ordering is now configurable
  • SQL templates additions ($schema and $catalog variables has been added)
  • Metadata editor UI improved
  • Minor UI bugfixes

New in DBeaver 2.3.0 (Sep 23, 2013)

  • DB2 extension (metadata browser, execution plan view, etc)
  • Eclipse 4.3 is now base platform (improves UI and editors performance)
  • Fixes of MS SQL, MySQL, Oracle ad CSV extensions
  • Metadata editor fixed
  • Execution plan visualization improved
  • Auto-increment columns edit fixed
  • Many minor fixes in UI and model

New in DBeaver 2.2.5 (Aug 26, 2013)

  • Data transfer performance improved
  • Query/script execution statistics improved
  • SQL autocomplete improved
  • Results view copy/advanced copy improved
  • Results view rendering fixed
  • Unique keys management simplified
  • A few minor UI problems fixed

New in DBeaver 2.2.4 (Jul 16, 2013)

  • Search UI changed
  • Metadata reading improved (Oracle RDB problem fixed)
  • Results columns hiding/reordering support added
  • Results viewer fixed (context menu, record mode, scrolling, etc)
  • Connection properties dialog fixed
  • Project management fixed in Eclipse plugin version
  • Metadata search integrated into standard Eclipse search UI
  • Oracle driver updated to 11.2.0.3
  • Many minor UI fixes

New in DBeaver 2.2.3 (Jun 28, 2013)

  • Word wrap mode support in text editors
  • Connection properties editor fixed
  • Default date/time format changed
  • Oracle DDL format is now configurable
  • Oracle TNS connections fixed
  • TINYINT data type handle fixed
  • Results context menu fixed
  • Grid column hide support added
  • Vertica driver updated

New in DBeaver 2.2.2 (Jun 17, 2013)

  • Connection properties UI completely rewritten and improved
  • DB2 for z/OS driver added
  • Binary (LOB) editor improved, Hex and Base64 formats added
  • Autocommit and transaction isolation per-connection configuration added
  • Cross-database data export fixed
  • Results viewer fixed (additional segments fetch)
  • Checking of multiple running DBeaver instances added
  • Context menu fixed in Eclipse plugin mode
  • Foreign keys added in generic DDL
  • UI freeze on disconnect with socket timeout fixed
  • Many minor UI fixes

New in DBeaver 2.2.1 (May 27, 2013)

  • Oracle, MySQL, Cassandra and WMI drivers are now included in standard DBeaver distribution. No need to download these drivers separately.
  • Oracle OCI driver is now obsolete. It is replaced by Thin driver.
  • Data export from query/SQL script fixed.
  • SSH keep-alive support added.
  • Windows installer fixed (extraction worked incorrectly on some systems)
  • Minor UI fixes

New in DBeaver 2.2.0 (May 13, 2013)

  • Multiple result sets are now supported by SQL editor
  • Result set filters has been improved (you may set filter criteria directly in SQL editor/table data viewer)
  • Find/replace support added result sets. Now you may search data right in result set using good old CTRL+F.
  • Metadata (tables/constraints/foreign keys) editor has been improved (you may create complex table structure in UI and then save it in one click)
  • JRE is now included in Windows installers. So there are no system prerequisites for DBeaver if you are on Windows.
  • MySQL TINYINT(1) data type problem fixed, Oracle date/time data type problems fixed, a few minor fixes for SQL Server and PostgreSQL added.
  • Many minor UI bugfixes and improvements

New in DBeaver 2.1.2 (Apr 24, 2013)

  • MS Access driver added (UCanAccess)
  • Drivers download fixed
  • Projects import/export fixed
  • Big Integer values handling fixed
  • Oracle TIMESTAMP formatting fixed (filters)
  • ResultSet UI improvements

New in DBeaver 2.1.1 (Apr 1, 2013)

  • Eclipse 4.2.2 is base platform for standalone version
  • UI freeze during MySQL long queries fix
  • Sort navigator tree alphabetically (configurable)
  • Expand navigator tree on connect (configurable)
  • MySQL enum/set data types handle fix
  • Oracle TNS names load fix (on Linux)
  • Autocomplete fix (SQLite)
  • Cell editor dialog UI fixed
  • Standard commands’ handlers fix
  • Minor UI and functional fixes

New in DBeaver 2.1.0 (Mar 18, 2013)

  • Data transfer/import feature (transfer data between any tables/views/queries in different databases)
  • In Eclipse plugin version JDBC drivers can be installed from update site as plugins
  • SQL editor improved (braces matching, current line highlight, print margins support)
  • 64-bit Windows installer fixed
  • JDBC driver for CSV/DBF files added
  • Oracle IOT tables support added, view meta information improved
  • Advanced authentication for MySQL native tools
  • SQL Auto-completion fixed (insert full qualified table names when needed)
  • SQL scripts to database group linking feature added
  • Many minor UI and database-specific fixes

New in DBeaver 2.0.7 (Feb 17, 2013)

  • Apache Cassandra extension plugin
  • ResultSet cell properties
  • Inline integer value editor fixed
  • Inline binary editor added
  • MySQL stored procedures editor fixed
  • Oracle XML editor fixed
  • PostgreSQL big schema loading fixed (performance increased)
  • SQL generation improved (MERGE operator)
  • Date viewer performance increased
  • A few UI bugfixes

New in DBeaver 2.0.6 (Feb 4, 2013)

  • Grid data editor refactored. Embedded editor/viewer added
  • Support of complex SQL types (arrays, structures, references – tested on Oracle)
  • Value editors/viewers improved. Images preview in panel
  • Direct data export from SQL query
  • Advanced data copy dialog (support of locale specific number/date formats)
  • SQL query generator (for tables and result sets)
  • Connection invalidation before query execution (configurable)
  • Keyboard shortcuts are working in inline data editors
  • ResultSet export fixed
  • Hung on transactions level/autocommit change fixed
  • Hyperlinks fixed in metadata browser
  • Lazy properties loading fixed in metadata editor
  • Native tools menu fixed (MySQL and Oracle)
  • Eclipse plugin UI fixed
  • MySQL Views metadata editor fixed
  • Privileges editor fixed (MySQL)
  • Actual row count property added (Oracle)
  • Drop view statement fixed (Generic)
  • Tray icon notifier improved (show script name)
  • A few minor UI fixes

New in DBeaver 2.0.5 (Jan 14, 2013)

  • Tray icon support (long-running tasks finish notification)
  • Support of table column default values
  • UI freeze on multiple queries fixed
  • Table columns autocomplete improved
  • Undo/redo manager fixed
  • Oracle metadata editors fixed
  • MySQL enum/set types support fix
  • MySQL user management fixed
  • Many minor bug fixes

New in DBeaver 2.0.4 (Dec 17, 2012)

  • Connection types (dev, test, prod) support added. Note that now global auto-commit parameter moved to connection type specific settings. Also you may define your own connection types (see preferences).
  • Oracle CREATE/DROP schema actions fixed
  • Vertica database driver added + Vertica SQL autocomplete fixed
  • Plugin mode fixes (perspective icon, branding, etc)
  • UI fixes (database selector, copy/paste in dialogs)
  • Misc bugfixes

New in DBeaver 2.0.3 (Nov 28, 2012)

  • Support of DDL generation for generic drivers
  • MySQL active DB selection fix
  • Informix autocomplete fix
  • MSSQL formatting fix
  • Project explorer columns configuration
  • Localization fixes
  • Plugin version minor UI fixes

New in DBeaver 2.0.2 (Nov 19, 2012)

  • Eclipse plugin version
  • SQL templates (snippets) support
  • Database compare feature
  • Data editor improvements
  • Hex editor for strings
  • XML data export
  • SQL log persistence
  • Project explorer UI improvement
  • Apache Cassandra driver
  • Misc fixes in generic JDBC/ODBC support
  • A lot of UI fixes

New in DBeaver 2.0.0 RC 1 (Nov 5, 2012)

  • Templates (snippets) support:
  • It is a draft version so some things may work not like expected. But generally templates are just great.
  • To use this feature you may open new view “Templates” and just lick on template name or drag-and-drop it on editor. But the most powerfull thing is template shortcuts. Type template name (e.g. “scount”) and press TAB – template will be inserted at the cursor and you may choose variable values (like table name). And of course you may create your own templates.
  • Database compare feature:
  • In fact not only databases but any database objects may be compared. Just select them in navigator and choose “Compare” from context menu.
  • Compare results are saved in HTML report file:
  • It is first beta version of compare feature, please send your improvement suggestions.
  • Hex editor for strings:
  • It is available in value (cell) edit dialog. String-to-binary convesion encoding may be configured in preferences.
  • A lot of bugfixes (most of them related to E4 migration). Now we are very close to stable version. Just a little bit more testing.

New in DBeaver 2.0.0 Beta (Oct 24, 2012)

  • Version 2.0 is compatible with Eclipse Juno (Eclipse 4) framework. Current standalone DBeaver version built and tested with Eclipse 4.2.1.

New in DBeaver 1.6.4 (Oct 5, 2012)

  • SQL editor comments toggle support
  • Autocomplete, SQL hyperlinks and objects search refactored:
  • Object lookup speed significantly increased;
  • Case-sensitive (quoted) object names lookup support
  • Tables are shown prior to schemas;
  • Support of HTML format for tables/data export
  • SQL editor fixes (correct extraction of current query)
  • SQL scripts creation fix
  • Metadata editors UI and undo/redo fixes
  • Quick data filters fixed (enable filters menu for empty result set + numbers formatting fix)
  • Metadata property names localization
  • Minor UI fixes

New in DBeaver 1.6.3 (Sep 17, 2012)

  • Support of data edit for tables without unique key
  • Support of custom descriptions for dictionary tables
  • Quick filter of ResultSets
  • ResultSet controls improved
  • Transactions management improved
  • Columns width fixed in ResultSet grid
  • Support of nanoseconds for TIMESTAMP data types
  • Oracle connection settings improved (SID/Service Name)
  • Oracle metadata load fix
  • Oracle DATE type handle fix
  • MSSQL active database selection fix
  • MySQL SELECT INTO fix
  • SQL formatter improvements
  • Many bugfixes and minor UI improvements

New in DBeaver 1.6.2 (Sep 17, 2012)

  • New connection wizard fix (test connection button)
  • Parameter binding dialog improvement
  • Misc UI fixes

New in DBeaver 1.6.1 (Jul 30, 2012)

  • This version contains a few important bugfixes:
  • Toolbar actions fixes (ERD, SQL editor, etc)
  • Search dialog fix
  • Object filters fix (NPE)
  • Numeric data types (Oracle) handle fix
  • Read-only connections fix (all new connections were read-only by default)
  • And a few minor UI fixes

New in DBeaver 1.6.0 (Jul 2, 2012)

  • Chinese, Russian and Italian translations
  • Metadata tree filters
  • ResultSet editor improvements. Support of copy/paste for cells.
  • BLOB editor fix (save)
  • Oracle cursors viewer
  • Read-only connections support
  • HTTP proxy authentication support
  • SSH support for external (native) utilities
  • Line numbers ruler configuration
  • Fixed handling of dynamic SQL parameters
  • A lot of minor UI fixes and improvements

New in DBeaver 1.5.6 (May 22, 2012)

  • SSH tunnels settings fix
  • External tools fix (support of SSH tunnels)
  • ERD color schema fix
  • Hyperlinks fix

New in DBeaver 1.5.5 (Apr 24, 2012)

  • It is minor release which contains a few bugfixes:
  • MySQL problem when no default database is set
  • Oracle performance problems
  • Minor UI fixes (hyperlinks rendering)

New in DBeaver 1.5.4 (Apr 5, 2012)

  • Support of SSH tunnels
  • Table column descriptions

New in DBeaver 1.5.2 (Feb 29, 2012)

  • Additional Auto-completion configuration
  • Date/Time format fixed in table export
  • ResultSet filter dialog redesign
  • ResultSet cell editor fixes
  • Oracle schema loading fix
  • A few minor UI fixes

New in DBeaver 1.5.1 (Feb 11, 2012)

  • Content assistant configuration added in Preferences
  • Metadata editor fixes (database/table creation)
  • Table data editor fix (problems with auto-generated keys in MS SQL)
  • Error messages and localization fixes
  • Performance optimization
  • Main menu was updated (SQL editor related menus were moved)
  • Minor UI fixes

New in DBeaver 1.5.0 (Jan 31, 2012)

  • WMI (Windows Management Instrumentation) browser
  • Redesign of architecture to support non-relational databases
  • ERD plugin improvements
  • Oracle plugin additions and performance fixes
  • A lot of bug fixes

New in DBeaver 1.4.7 (Jan 31, 2012)

  • This version contains just a few hotfixes:
  • Oracle OCI driver loading fix
  • Oracle login roles (SYSDBA, etc) fix
  • And one new feature – new it is possible to link any external folder to DBeaver project. For example link user SQL scripts laying in some version control system.

New in DBeaver 1.4.6 (Jan 31, 2012)

  • Changes: many general and UI fixes. Improvement of native tools execution (MySQL and Oracle), redesign of stored procedures/views/types/packages edit.
  • Additionally we added social networking features to the site.

New in DBeaver 1.4.5 (Nov 28, 2011)

  • MySQL and Oracle native clients support
  • MySQL full database export/import
  • Resultset filters UI update
  • Drivers management improvements
  • SQL editor fixes and additional formatting
  • General UI and code fixes
  • Multilingual installer

New in DBeaver 1.4.3 (Oct 26, 2011)

  • New version checker/updater
  • Connection events (run shell command on connect/disconnect)
  • Oracle tables view/edit fixes
  • Oracle procedures, packages, views, types, triggers source code editor and compiler
  • UI internationalization and first localization beta
  • Many general UI fixes

New in DBeaver 1.4.1 (Oct 5, 2011)

  • Oracle:
  • Oracle home selection fix
  • TNS_ADMIN environment variable usage fix
  • TNS names are available for Thin driver
  • Data type resolve fix (Timestamp and BigInteger)
  • View/Materialized view search
  • MS SQL:
  • UPDATE statement execution fix (do not use row count limit)
  • Auto complete fix for complex identifiers
  • Table/ResultSet editor fix
  • PostgreSQL:
  • driver update
  • Driver manager fix (do not try to load redist libraries for drivers with custom libraries)
  • OS-dependent drivers
  • UI fixes

New in DBeaver 1.4.0 (Sep 26, 2011)

  • Oracle:
  • OCI driver support (special thanks to Eugene)
  • Constraints & foreign keys search
  • Timestamp & cursor datatypes support
  • Procedures, packages & views compilation support
  • Edit of stored procedures
  • Parameters/variables bindingEclipse plugin – test version
  • UI fixes:
  • Objects search fix
  • Inline editor of date/time values
  • Minor bugfixes

New in DBeaver 1.3.4 (Aug 29, 2011)

  • Oracle XML type support (in some environments XML columns were always NULL)
  • Data export wizard (suport of data filters was added)
  • A few nasty UI bugs

New in DBeaver 1.3.2 (Aug 22, 2011)

  • MySQL stored procedure editor
  • MS SQL Server native (by Microsoft) driver added
  • Terdata database driver added
  • Bug fixes

New in DBeaver 1.3.0 (Jul 5, 2011)

  • Oracle extension:
  • Allows to browse all Oracle-specific metadata like packages, views, sequences, procedures, tablespaces, users, roles, etc
  • Fully supports XML data type, supports Object and Collection types in read-only mode
  • Supports execution plan explain
  • Manages server sessions
  • Also:
  • Driver management was updated – now all drivers are “external”. JDBC drivers does not shipped with DBeaver anymore. But, as before, drivers will be atomatically downloaded on demand (e.g. when you make new connection). Or you may download drivers from official source and configure it in DBeaver manually.
  • MySQL driver performance improved
  • Ingres database driver
  • Linter database driver
  • Context help update (special thanks to Adam Peaslee for the verification and updates of product documentation)
  • Many UI updates
  • Bug fixes

New in DBeaver 1.2.2 (Jun 10, 2011)

  • Integrated help system
  • SQLite drivers configuration
  • SSO (Single Sign On) support for MS SQL (obviously it works only in Windows version)
  • Driver manager enhancements (driver categories)
  • Automatic installer for Windows 64
  • And standard feature – bugfixes

New in DBeaver 1.2.0 (May 26, 2011)

  • Metadata editor. Supports visual edit of:
  • Tables
  • Columns
  • Unique keys
  • Foreign keys
  • Indexes
  • Views (MySQL)
  • Undo/redo in all object editors
  • Imporoved SQL autocompletion
  • A lot of UI updates and bugfixes

New in DBeaver 1.1.3 (Apr 26, 2011)

  • Support of IBM Informix
  • Support of SAP/MAX DB
  • Support of Cache database
  • Driver management was refactored. Now DBeaver ships with MySQL, PostgreSQL, Oracle and JTDS drivers. All other drivers could be automatically downloaded on demand.
  • SQL scripts import/export
  • SQL syntax highlighting/scripts parse fixes
  • Identifier escaping fix

New in DBeaver 1.1.0 (Apr 11, 2011)

  • Major redesign of object editor/viewer
  • Context search in editors (in object lists and in ERD)
  • Show row count for tables (configurable, may be disabled to prevent database load)
  • Display child objects in item lists (for complex entities e.g. index/constraint columns)
  • ERD palette redesign (show structure of diagram content)
  • Filtering of database tree depending on element properties (e.g. show only columns for views)
  • Support of running background tasks view/cancel
  • Real progress monitor for editor tasks
  • Accelerators (shortcuts) and main/context menu update
  • Configure of new SQL scripts creation (in the root or in the connection’s folder) + deletion of empty scripts on close
  • Performance improvements (lazy activation of all sub-editors)
  • Icons update in core/generic/mysql plugins
  • Support of read-only datasources
  • DB2 driver: current scheme get/set
  • MSSQL driver: indent columns support
  • Memory leaks fixed in SQL and ERD editors
  • A lot of minor bugfixes and many minor UI changes

New in DBeaver 1.0.5 (Mar 21, 2011)

  • Custom Entity diagrams (ERD). Now you may create diagram with custom tables (even from different databases), layout entities automatically or manually, create logical references between entities, create descritpion notes, etc. Copy-paste and drag-n-drop are fully supported. Diagrams are saved in new special project folder “Diagrams”.
  • Export ERD to image feature added.
  • Global “New object” wizard added in File menu (in this release it supports Project, Connection and Diagram creation).
  • Driver management was redesigned. Custom JDBC drivers problems are fixed in Linux/Unix versions.
  • A few JDBC problems fixed in Generic plugin (DB2, ODBC bridge, PostgreSQL)

New in DBeaver 1.0.1 (Feb 28, 2011)

  • Project configuration import/export (so now you can share your DB configurations with colleagues).
  • 3rd party configuration import added (in this release SQL Squirrel and DBVisualizer are supported)
  • Mimer and HXTT DB engines were tested and added to supported DB list (special thanks to Wolf van Heeswijk). Extra DB configurations added to generic plugin.
  • Debian package is now available as Linux installer
  • Many bugfixes and minor UI fixes

New in DBeaver 1.0.0 RC 2 (Jan 28, 2011)

  • Major new features:
  • Bookmarks – any database objects can be added to bookmarks. Very usefull if you use only a little set of DB objects from a huge database with multiple schemas/tables/etc.
  • Scripts management. Now scripts are saved in special folders so you won’t loose any entered queries after script close. Scripts could be organized in folders.
  • Projects. Connections, scripts and bookmarks could be grouped into projects.
  • Additionally we have many bugfixes.

New in DBeaver 1.0.0 RC 1 (Jan 11, 2011)

  • Database objects search (tables, procedures, constraints. columns, etc)
  • Generic driver supports only tables and procedures (as it provided by JDBC API) but advanced plugins (MySQL in this version) may provide as many object types as underlying database supports.
  • MySQL enhancements: user and schema managemenet.
  • New drivers added/updated in generic plugin (Oracle 11, Sybase).
  • SQL editor autocomplete and hyperlinks are improved.