DBeaver 1.3.2 (powered by sun*)

Yep, it’s a vacation season. And as a result we had a pause in development. But do not worry – we’re back and new DBeaver version just has been released.

So, the changelist:

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

Also we migrated to Eclipse 3.7. It contains many bugfixes in UI plugins but I’m afraid that it could contain a new bugs. Anyway, at the moment we didn’t find them.
And we started i18n phase – as it’ll be finished we’ll start localizations.

Have a good rest of the summer!

* Not by the Oracle sun, but by the sun sun. Closest star, you know. It is not an advertisement ;)

Posted in Releases

DBeaver 1.3.1

This minor release contains fixes of two tiny but quite nasty bugs:
1. Oracle 9i metadata browser fix (table/view lists reading was broken in 1.3.0)
2. DB2 clob/blob reading (DB2 driver doesn’t support scrollable result sets if LOB columns presents in it).

Also here are a few tips concerning DB2 driver and especially error messages:
Read more ›

Posted in Releases

DBeaver 1.3.0


DBeaver 1.3.0 has been released!
This version is mainly devoted to Oracle. New plugin was added to distribution. So, the changelist:

  • 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 don’t ship 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
Posted in Releases

DBeaver 1.2.2


New major release – DBeaver 1.2.2.
Main new feature – integrated context help system and first version of product documentation. Actually existing documentation in rough draft form, but we believe it is much better than nothing.
Brief changelist:

  • 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

Note about SQLite drivers. Three different drivers were added. You will need to choose the best one for you. Zentus driver is the oldest and most “standard” JDBC driver for SQLite. Xerial driver based on Zentus and provides some additional features. Driver written by Christian Werner provides more information about DB structure (keys, indexes) but it only works under Windows (it may work in other OSes but it requires SQLite native library and only Windows dll supplied with DBeaver – but you may build this library from sources by yourself, of course)

Note about SSO. This feature allows you to connect to MS SQL Server with your local/domain windows account. Just leave user name/password blank and connect. jTDS driver uses native libraries to implement this feature so it works only in Windows version of DBeaver. Special thanks to Adam Peaslee for idea of this feature.

Posted in Releases

DBeaver 1.2.0


DBeaver 1.2.0 major release is ready!
We made a lot of tests during last weeks and it looks quite stable.

Brief (very brief) changelist:

  • 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 (especially in Linux/gtk version)

Generic driver uses subset of SQL-92 to manipulate database objects. MySQL driver uses MySQL extensions.
Read additional metadata editor notes in 1.2.0 EA announce .

Posted in Releases

How to use DBeaver with “external” database hosting

It happens very often that we do not have direct access to our databases, especially if we are talking about internet hosting.
As a rule due to security reasons hosting provider closes all “non-standard” ports (except HTTP, FTP, SSH and some other). As a result users are forced to use various weird solutions like phpMyAdmin. Poor things…
If you have SSH access to your hosting then you are lucky (just as me).
Here we will talk about how to use SSH tunnels to access our “unaccessible” databases from Windows (I believe most of Unix-guys knows how to use SSH-tunneling).

Read more ›

Posted in Articles

Metadata Editor


Finally we have working version of metadata editor.
It allows visual edit of primary relational database entities:

  • Tables
  • Columns
  • Unique keys
  • Foreign keys
  • Indexes

Generic driver uses SQL-92 DDL to manipulate meta objects. MySQL driver uses MySQL extensions.
This is not a release, it is not yet fully tested. You may get working copy from Early Access folder.
It is not recommended to use new features in mission-critical databases. Always check generated SQL script before saving changes.
Stable version of metadata editor will be available in DBeaver 1.2 which will be published in following 2 weeks.
Besides metadata editor this version includes many UI fixes and additions to MySQL plugin (charsets, collations).
You may check for additional metadata editor notes on our forum.

Download Early Access version 1.1.4

Posted in Articles

DBeaver 1.1.3


Well here we are again.
We had no any news or other visible activity for a week or so. To be honest, last few days we tried to port DBeaver on GLaDOS. Tried very hard. At last we have no working port but at least we had a lot of fun.

From the other hand we succeded with support of other legacy systems. Here is version 1.1.3 changelist:
– 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

Also we updated documentation. Check for FAQ, Roadmap and About pages.

Posted in Releases

DBeaver 1.1.0


We had plans to release new version with metadata editor support, however there were too many changes in UI so we decided to make this intermediate major version. So, here it is – DBeaver 1.1.0.

Changelist:

  • 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

Thanks to everyone who sent us bug reports and feature requests, we really appreciate this!

Posted in Releases

DBeaver 1.0.5


New stable version 1.0.5 has been released!

Changelist:

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

Have a good day and thanks for all feedbacks!

Posted in Releases