DBeaver - Universal Database Manager

[Nytro]

DBeaver - Universal Database Manager

Overview

DBeaver is free and open source (GPL) 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
  
• Teradata
  
• Vertica
  
• Any JDBC compliant data source
  

Supported OSes:

• Windows (2000/XP/2003/Vista/7)
  
• Linux
  
• Mac OS
  
• Solaris
  
• AIX
  
• HPUX
  

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
  

Oracle plugin features:

• XML, Cursor datatypes support
  
• Packages, procedures, triggers, indexes, tablespaces and other metadata objects browse/edit
  
• Metadata DDL view
  
• Session management
  
• Users 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
  

License

DBeaver is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

DBeaver is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

License full version

Contacts

Technical support – support@jkiss.org

Technical support, feature suggestions and any other questions – serge@jkiss.org

Download:

http://dbeaver.jkiss.org/download/

Sursa: DBeaver - Universal Database Manager