What's new in DBeaver 7.2.1
Sep 21, 2020
- Preference pages structure was reorganized (in the standalone and plugin versions)
- 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
- 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)
- Several minor bugs were fixed (NPE and UI glitches)
- Database navigator:
- Filters now support masks escape (_ and % characters)
- Connection state icons were replaced and adapted to dark themes
- 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
- Import from CSV/XLSX:
- Wrong rows can be skipped (with disabled "Batch import" option)
- Import parameters documentation was updated
New in DBeaver 6.3.3 (Jan 20, 2020)
- 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)
- 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
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 vefore data modifying query execute)
- SQL editor:
- Alias generation was improved
- Output log flush eas fixed
- Default database assign (for SQL script) was fixed
- Data editor: advances paste now respects NULLs for dates and numbers
- PostgreSQL:
- $$ strings parser was fixed
- Domain type arrays support was fixed
- 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
New in DBeaver 6.3.1 (Dec 27, 2019)
- 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
- 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
- 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
- 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
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)
- 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
- 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
New in DBeaver 6.2.4 (Nov 4, 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.3 (Oct 23, 2019)
- SQL Editor: parameters binding dialog improvements (value preview)
- Data viewer:
- Result tabs drag-n-drop support was added
- Spatial data viewer was fixed (tooltips generator)
- Task editor: add/remove tables for existing task was fixed
- Virtual foreign keys support was fixed (table rename support)
- Oracle: Q-style quoting support was added
- PostgreSQL:
- Foreign Data Wrappers configurator wizard was added
- $$-quote support was fixed
- Dependencies info reading was fixed (PG12)
- Function signature generator was fixed (FQ type names)
- MySQL: column autoincrement flag editor was fixed
- Elasticsearch: driver version was updated
- Windows: app crash problem was fixed
- MacOS: app notarization added for all distributions
- Eclipse plugin: create .dbeaver folder on demand
- A lot of minor UI fixes
New in DBeaver 6.2.2 (Oct 7, 2019)
- 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
- 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
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
New in DBeaver 6.1.4 (Aug 7, 2019)
- Many problems with workspace migration 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)
- 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
- 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
- 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
New in DBeaver 6.1.2 (Jul 12, 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.0 (Jun 19, 2019)
- 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 23, 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 8, 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 30, 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 10, 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 (Mar 19, 2019)
- Added support for different cloud databases in AWS and Azure,
- Significantly improved support for PostgreSQL and SQL Server
- Increased number supported drivers to more than 70.
- Renovated connection wizard and data migration tools.
- Added analytical panels, customizable dashboards, mock data generators, SQL debugger.
- Modernized UI, significantly improved dark theme support
- Closed more than 1600 issues on GitHub.
- And a lot of other things. Thank you for your support!
New in DBeaver 5.3.5 (Feb 19, 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 5, 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:
- 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.2 (Jan 8, 2019)
- Data editor:
- Open With menu was added (web browser and Excel)
- Next page auto-fetch was fixed
- UUID/GUID generate function was added
- ERD:
- Save as picture function was fixed (case-insensitive file path)
- Attributes visibility configuration was improved
- Data transfer: "truncate target table before load" function was fixed
- SQL editor:
- Parameters biding dialog + results scrolling glitch was fixed
- Glitch with first time reading of proposal was fixed
- Stored procedure auto-completion was fixed
- Syntax coloring: Color Themes support was fixed
- SQL Server:
- Default schema detection was fixed
- Column data type resolution was fixed
- Identifiers auto-completion was fixed
- NVarchar(MAX) data type resolution was fixed
- Exasol:
- Exasol V6.1 support was added
- Metadata reading performance was significantly improved
- Partitions information was added
- Security management was improved (roles, priority groups, policies, etc)
- PostgreSQL:
- Rules support was added (read-only)
- Stored procedures (PostgreSQL 11) support was added
- Aggregate functions meta information support was added
- Database tablespace edit support was added
- Reserved keywords update was added
- Greenplum:
- External table DDL generation fixes were added
- Redshift: column encoding information was added
- Oracle: PS/SQL blocks parser was fixed
- Huge code refactoring was made (separation of model and UI plugins)
- Many minor UI bugfixes
New in DBeaver 5.3.0 (Dec 13, 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 22, 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 12, 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.1 (Sep 30, 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.1.0 (Jun 11, 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.5 (May 21, 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 3.0.2 (Nov 19, 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 2.3.7 (Feb 5, 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 23, 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 17, 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 19, 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 29, 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 27, 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 27, 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.2 (Jun 18, 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 28, 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 14, 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 25, 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 2, 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