DBeaver 2.1.1

DBeaver 2.1.1 has been released.

Generally it is a minor hotfix version. Most important change is that now Eclipse 4.2.2 is a base platform for standalone version. It has many performance improvements and UI bugfixes.
Changelist:

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

DBeaver 2.1.0

DBeaver 2.1.0 has been released.
Changelist:

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

DBeaver 2.0.7

DBeaver 2.0.7 has been released.

Changelist:

  • 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

It is last planned 2.0.x version. Next release will be 2.1.0 and it will contain many improvements concerning result set view/edit (like columns reorder, pseudocolumns support, etc).
Also we are working hard upon NoSQL and Bigdata databases support. It is a serious challenge as we have to make proper data model and UI for them.
Read more about nosql/bigdata:
Read more ›

Posted in Releases

DBeaver 2.0.6

DBeaver 2.0.6 has been released!
This version contains really huge amount of fixes and improvements.
Thanks to everyone who send us feedbacks and bug reports, without your help this wouldn’t have happened.
So, brief changelist with pictures:

  • 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


(Note: screenshots contains data from sample databases which are shipped with standard Oracle/Derby distributions. No any personal information has not been disclosed and no any rabbits were harmed)

Posted in Releases

DBeaver 2.0.5

DBeaver 2.0.5 has been released.
Brief changelist:

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

DBeaver 2.0.4

DBeaver 2.0.4. has been released.

Brief changelist:

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

Cassandra driver

Latest DBeaver version contains driver for Apache Cassandra.
Currently it is accessible with Generic driver and JKISS Cassandra JDBC driver.
Apache Cassandra
Although Cassandra is not relational database some concepts are similar to regualr databases – metadata browser makes sense and CQL queries are just like SQL.
Main difference is that Cassandra’s column families are not relational tables and doesn’t have particular set of columns. Generally each row may have its own set of columns and it makes standard resultset viewer almost useless. However you may execute simple CQL and browse column families with strict structure.
We are going to add non-relational data viewer features in future versions of DBeaver (it’ planned for Cassandra, Mongo, Berkley and probably for hierachical dbs like IMS).
Read more ›

Posted in Articles

DBeaver 2.0.3

DBeaver 2.0.3 (minor hotfix version) has been released. Changelist:

  • 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

Posted in Releases

DBeaver 2.0

DBeaver 2.0 Final Release version is ready.
Brief changelist:

  • 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

Notes: If you migrating from DBeaver 1.x then it is possible that views layout will be corrupted (extra gray spaces, corrupted toolbar, etc). In this case go to Preferences (main menu File->Preferences->Interface->Appearance) and change the theme (e.g. on Classic).

Thanks to everyone who helped us to make DBeaver better, who sent feedbacks and bugreports.
Special thanks to Eugene for localizations support.

Have fun!

Posted in Releases

DBeaver 2 RC

Here is a DBeaver 2.0 release candiadate version. Well, what we have..

  • 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.
    BTW – if you have any SQL snippets that you think may be usefull for all please send them to us and we will include them in standard configuration.
  • 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.

It looks like Eclipse plugin version is not very popular at the moment, however I know that some people were very interested in it. Please send any feedbacks, I can’t test all plugin issues as good as in standalone version (because I use standalone version all the time) and the only hope to make it stable and good is user feedbacks and bugreports.

Apparently next version will be 2.0 final release. I hope to make it in November, not too long waiting.

Posted in Releases