September 29, 2011 · General · Email This Post

Sponsored Link
DBeaver is free universal database tool for developers and database administrators.

Usability is the main goal of this project, program UI is carefully designed and implemented.
It is freeware.
It is multiplatform.
It is based on opensource framework and allows writing of various extensions (plugins).
It supports any database having a JDBC driver.
It may handle any external datasource which may or may not have a JDBC driver.
There is a set of plugins for certain databases (MySQL and Oracle in version 1.x) and different database management utilities (e.g. ERD).

Supported (tested) databases:

MySQL
Oracle
PostgreSQL
IBM DB2
Microsoft SQL Server
Sybase
ODBC
Java DB (Derby)
Firebird (Interbase)
HSQLDB
SQLite
Mimer
H2
IBM Informix
SAP MAX DB
Cache
Ingres
Linter
Any JDBC compliant data source

General features:

Database metadata browse
Metadata editor (tables, columns, keys, indexes)
SQL statements/scripts execution
SQL highlighting (specific for each database engine)
Autocompletion and metadata hyperlinks in SQL editor
Result set/table edit
BLOB/CLOB support (view and edit modes)
Scrollable resultsets
Data (tables, query results) export
Transactions management
Database objects (tables, columns, constraints, procedures) search
ER diagrams
Database object bookmarks
SQL scripts management
Projects (connections, SQL scripts and bookmarks)

MySQL plugin features:

Enum/Set datatypes
Procedures/triggers view
Metadata DDL view
Session management
Users management
Catalogs management
Advanced metadata editor

Other Benefits:

DBeaver consumes much less memory than other popular similar software (SQuirreL, DBVisualizer)
Database metadata is loaded on demand and there is no long-running “metadata caching” procedure at connect time
ResultSet viewer (grid) is very fast and consumes very little ammount of memory
All remote database operations work in non-blocking mode so DBeaver does not hang if the database server does not respond or if there is a related network issue

Install DBeaver on ubuntu

Download deb package from here  once you have deb package you can double click on it to install.

Sponsored Link

Incoming search terms:

Related posts

Leave a Reply