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

저작자 표시 비영리 동일 조건 변경 허락
신고
크리에이티브 커먼즈 라이선스
Creative Commons License

Web Developer. My native language is Korean(한국어) My hobby is Learning Language(English,中國語[繁體中文/简体中文],日本語) Interested Mobile & Web #Unicode #CJK #文字 #漢字 #이상한모임
저는 초등학교 3학년때 역삼동 아부지 회사에서 접해보았던 Netscape Browser를 보고 인터넷에 빠져들었습니다. Web에 대해 관심이 많으며 음악을 좋아합니다.
블로그 : http://blog.studioego.info
Twitter: @studioego
이 글은 StudioEgo 가 작성하였습니다.

댓글을 달아 주세요