DBeaver - 개발자와 DBA를 위한 무료 오픈소스(GPL) 데이터베이스 툴
저는 Eclipse 플러그인으로 된 DBeaver를 사용하고 있음. Oracle, Mysql, PostgreSQL, SQLite, H2, Java DB등 여러종류의 DBMS를 지원하고 OS도 Windows, Linux, Mac OS 모두 지원합니다.
무료 GUI DB툴 치고는 ERD 보여주는 기능 및 BLOB 보여주는 기능등등 여러가지 기능이 좋아서 소개합니다.
아래는 DBeaver 홈페이지에 있는 소개
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