DBeaver 2.1.2

DBeaver 2.1.2 has been released.

Yet another bugfix version. Unfortunately we didn’t release major version in this April because I was very busy at my primary job.
Hopefully May will be more productive.
Brief changelist:

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

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