{"id":1787,"date":"2014-04-03T21:49:00","date_gmt":"2014-04-03T21:49:00","guid":{"rendered":"http:\/\/galhano.com\/blog\/?p=1787"},"modified":"2014-04-03T21:50:04","modified_gmt":"2014-04-03T21:50:04","slug":"dbeaver-is-free-and-open-source-gpl-universal-database-tool","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=1787","title":{"rendered":"DBeaver is free and open source (GPL) universal database tool"},"content":{"rendered":"<p><a href=\"http:\/\/dbeaver.jkiss.org\/about\/\" target=\"_blank\"><strong>DBeaver<\/strong> <\/a>is free and open source (GPL) universal database tool for developers and database administrators.<\/p>\n<ul>\n<li>Usability is the main goal of this project, program UI is carefully designed and implemented.<\/li>\n<li>It is freeware.<\/li>\n<li>It is multiplatform.<\/li>\n<li>It is based on opensource framework and allows writing of various extensions (plugins).<\/li>\n<li>It supports any database having a JDBC driver.<\/li>\n<li>It may handle any external datasource which may or may not have a JDBC driver.<\/li>\n<li>There is a set of plugins for certain databases (MySQL and Oracle in version 1.x) and different database management utilities (e.g. ERD)<\/li>\n<\/ul>\n<p>http:\/\/dbeaver.jkiss.org\/about\/<!--more--><\/p>\n<p>&nbsp;<\/p>\n<h3>Supported (tested) databases:<\/h3>\n<ul>\n<li>MySQL<\/li>\n<li>Oracle<\/li>\n<li>PostgreSQL<\/li>\n<li>IBM DB2<\/li>\n<li>Microsoft SQL Server<\/li>\n<li>Sybase<\/li>\n<li>ODBC<\/li>\n<li>Java DB (Derby)<\/li>\n<li>Firebird (Interbase)<\/li>\n<li>HSQLDB<\/li>\n<li>SQLite<\/li>\n<li>Mimer<\/li>\n<li>H2<\/li>\n<li>IBM Informix<\/li>\n<li>SAP MAX DB<\/li>\n<li>Cache<\/li>\n<li>Ingres<\/li>\n<li>Linter<\/li>\n<li>Teradata<\/li>\n<li>Vertica<\/li>\n<li>Any JDBC compliant data source<\/li>\n<\/ul>\n<h3>Supported OSes:<\/h3>\n<ul>\n<li>Windows (2000\/XP\/2003\/Vista\/7)<\/li>\n<li>Linux<\/li>\n<li>Mac OS<\/li>\n<li>Solaris<\/li>\n<li>AIX<\/li>\n<li>HPUX<\/li>\n<\/ul>\n<h3>General features:<\/h3>\n<ul>\n<li>Database metadata browse<\/li>\n<li>Metadata editor (tables, columns, keys, indexes)<\/li>\n<li>SQL statements\/scripts execution<\/li>\n<li>SQL highlighting (specific for each database engine)<\/li>\n<li>Autocompletion and metadata hyperlinks in SQL editor<\/li>\n<li>Result set\/table edit<\/li>\n<li>BLOB\/CLOB support (view and edit modes)<\/li>\n<li>Scrollable resultsets<\/li>\n<li>Data (tables, query results) export<\/li>\n<li>Transactions management<\/li>\n<li>Database objects (tables, columns, constraints, procedures) search<\/li>\n<li>ER diagrams<\/li>\n<li>Database object bookmarks<\/li>\n<li>SQL scripts management<\/li>\n<li>Projects (connections, SQL scripts and bookmarks)<\/li>\n<\/ul>\n<h3>MySQL plugin features:<\/h3>\n<ul>\n<li>Enum\/Set datatypes<\/li>\n<li>Procedures\/triggers view<\/li>\n<li>Metadata DDL view<\/li>\n<li>Session management<\/li>\n<li>Users management<\/li>\n<li>Catalogs management<\/li>\n<li>Advanced metadata editor<\/li>\n<\/ul>\n<h3>Oracle plugin features:<\/h3>\n<ul>\n<li>XML, Cursor datatypes support<\/li>\n<li>Packages, procedures, triggers, indexes, tablespaces and other metadata objects browse\/edit<\/li>\n<li>Metadata DDL view<\/li>\n<li>Session management<\/li>\n<li>Users management<\/li>\n<li>Advanced metadata editor<\/li>\n<\/ul>\n<h3>Other Benefits:<\/h3>\n<ul>\n<li>DBeaver consumes much less memory than other popular similar software (SQuirreL, DBVisualizer)<\/li>\n<li>Database metadata is loaded on demand and there is no long-running \u201cmetadata caching\u201d procedure at connect time<\/li>\n<li>ResultSet viewer (grid) is very fast and consumes very little ammount of memory<\/li>\n<li>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<\/li>\n<\/ul>\n<h2>License<\/h2>\n<p>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.<\/p>\n<p>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.<\/p>\n<p><a href=\"http:\/\/dbeaver.jkiss.org\/files\/dbeaver_license.txt\">License full version<\/a><\/p>\n<h2>Contacts<\/h2>\n<p>Technical support \u2013 <a href=\"mailto:support@jkiss.org\">support@jkiss.org<\/a><br \/>\nTechnical support, feature suggestions and any other questions \u2013 <a href=\"mailto:serge@jkiss.org\">serge@jkiss.org<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[141],"tags":[],"class_list":["post-1787","post","type-post","status-publish","format-standard","hentry","category-databases","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1787"}],"version-history":[{"count":2,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1787\/revisions"}],"predecessor-version":[{"id":1789,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1787\/revisions\/1789"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1787"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}