DBeaver 3.5.6

DBeaver 3.5.6 has been released:

  • 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
Posted in Releases

DBeaver 3.5.5

DBeaver 3.5.5 has been released.

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

filter-panel2

  • 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
Posted in Releases

DBeaver 3.5.4

Dbeaver 3.5.4 has been released. It is a kind of hotfix version.
Brief changelist:

  • 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
Posted in Releases

DBeaver 3.5.3

Brief changelist:

  • Drivers download UI was fixed.
  • Linux: RPM installer has been added, DEB installer has been fixed (version update).
  • Macos: DMG archive has been added.
  • 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.
Posted in Releases

DBeaver 3.5.2

DBeaver 3.5.2 has been released.

Warning: if you upgraded from 3.5.1 and you see IOException error during driver dependencies resolution then you need to fix the driver. Go to driver editor (click on “Edit Driver” on download page), press “Reset to defaults” button, press Ok and restart DBeaver.

Changelist:

  • 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
Posted in Releases

DBeaver on GitHub

github-logo

Good news for developers and DBeaver community. Those who just need recent DBeaver version please ignore it and proceed to download.

Finally DBeaver has moved to GitHub.
In the nearest future I’ll describe build procedure and write some other docs which will let to work with DBeaver sources easier.
I didn’t yet decide how to manage bug reports and feature requests better.
For now you can use our good old forum or (better) create issues in GitHub issue tracker. Eventually I’m planning to move all bug reports to GitHub or some other tracker.
If you have any suggestions/ideas – please write me.
PS Please star the dbeaver repository! ;)

Posted in Articles, News

DBeaver 3.5.1

Brief changelist:

  • 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

Note: if you upgraded from a previous version and DBeaver doesn’t start: try to run it with command line parameter “-clean” (“dbeaver -clean”)

Posted in Releases

DBeaver 3.5.0

Brief changelist:

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

Since version 3.5.0 we no longer provide prebuilt archives for Solaris, AIX, 32-bit MacOS and Linux RPM (but you can always build them from sources).
If you need any of them – please write me or make a feature request on forum.

Posted in Releases

DBeaver 3.4.5

DBeaver 3.4.5 has been released.
Brief changelist:

  • 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
Posted in Releases

DBeaver 3.4.4

DBeaver 3.4.4 has been released.
Note: Version 3.4.4 was released at 29.07.2015. It is a hotfix version of 3.4.3. It fixes missing ER diagrams tab.
This is a really major version with a big number of fixes, improvements and a few new features.
Please report any bugs you will find. Once again thanks for everyone who posts bug reports and feature requests!

Brief changelist:

  • 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)
  • DB2: INOUT parameters support fixed
  • 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

doc-oracle-xml

doc-mongo-json

Posted in Releases