DBeaver

Last updated
DBeaver
Original author(s) Serge Rider
Developer(s) Open-source community
Initial release2011;13 years ago (2011)
Stable release
24.1.0 [1]   OOjs UI icon edit-ltr-progressive.svg / 9 June 2024;30 days ago (9 June 2024)
Repository
Written in Java
Operating system Cross-platform
Platform Java
Available in Multilingual
Type SQL database administration tool
License Apache license
Website dbeaver.io

DBeaver is a SQL client software application and a database administration tool. For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver. For other databases (NoSQL) it uses proprietary database drivers. It provides an editor that supports code completion and syntax highlighting. It provides a plug-in architecture (based on the Eclipse plugins architecture) that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

Contents

The community edition (CE) of DBeaver is a free and open source software that is distributed under the Apache License. A closed-source enterprise edition of DBeaver is distributed under a commercial license.

History

DBeaver was started in 2010 as a hobby project. It was supposed to be free and open-source with a good-looking and convenient UI and to include frequently used features for database developers. The first official release was in 2011 on Freecode. [2] It quickly became a popular tool in the open-source community. [3] [4]

In the same year, the official web site was founded and the community support forum (now moved to GitHub) was created. [5] In 2012 an Eclipse plugin version was released - since then DBeaver has become one of the most popular database extensions for Eclipse (top 50-60 among all Eclipse extensions). [6]

Shortly after, various software vendors started to integrate with DBeaver (mostly as an extensions to their proprietary Eclipse RCP products: Zend Studio, [7] NXTware, [8] DeltaDNA, [9] etc.).

In 2014 the Enterprise Edition (EE) version was released. The EE version is based on CE but also provides support of NoSQL/BigData databases (Cassandra, MongoDB and Redis) and includes a few additional Eclipse plugins.

In 2015 the DBeaver source code/community moved to GitHub. [10]

In 2017 DBeaver CE was relicensed under Apache License (starting from version 4.x). [11]

In July 2017 DBeaver EE version became commercial in order to support CE version.

Supported platforms and languages

DBeaver is a cross-platform tool and works on platforms which are supported by Eclipse (Windows, Linux, MacOS X, Solaris), it is available in English, Chinese, Russian, Italian, and German.

Versions

Full list of all released versions [12]

Community Edition

Community Edition (CE) is the initial version of DBeaver. It was released in 2010 and became open-source (GPL) in 2011. CE version includes extended support of the following databases:

Besides relational databases, CE version supports WMI driver (Windows Management Instrumentation – works only in Windows version).

Eclipse Plugin Edition

After a year, and in response to multiple user requests an Eclipse plugin version was released on Eclipse Marketplace. This version is used by programmers who use the Eclipse IDE for software development and need a database management tool right in their IDE. The Eclipse plugin includes most features of Community Edition and is also released under GPL license.

Enterprise Edition

DBeaver 3.x announced support of NoSQL databases (Cassandra and MongoDB in the initial version). Since then DBeaver was divided on Community and Enterprise editions. Enterprise Edition has support of NoSQL databases, persistent query manager and a few other enterprise-level features. The EE version is not open-source and requires the purchase of a license (a trial license can be generated free of charge). List of additional features:

Features

DBeaver features include:

There are differences in the features available across different databases.

See also

Related Research Articles

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

<span class="mw-page-title-main">IntelliJ IDEA</span> Integrated development environment

IntelliJ IDEA is an integrated development environment (IDE) written in Java for developing computer software written in Java, Kotlin, Groovy, and other JVM-based languages. It is developed by JetBrains and is available as an Apache 2 Licensed community edition, and in a proprietary commercial edition. Both can be used for commercial development.

GNOME-DB is a database application by the GNOME community. The project aims to provide a free unified data access architecture to the GNOME project for all Unix platforms. GNOME-DB is useful for any application that accesses persistent data, since it contains a data management API.

Multi-master replication is a method of database replication which allows data to be stored by a group of computers, and updated by any member of the group. All members are responsive to client data queries. The multi-master replication system is responsible for propagating the data modifications made by each member to the rest of the group and resolving any conflicts that might arise between concurrent changes made by different members.

<span class="mw-page-title-main">LAMP (software bundle)</span> Acronym for a common web hosting solution

A LAMP is one of the most common software stacks for the web's most popular applications. Its generic software stack model has largely interchangeable components.

A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.

The SQuirreL SQL Client is a database administration tool. It uses JDBC to allow users to explore and interact with databases via a JDBC driver. It provides an editor that offers code completion and syntax highlighting for standard SQL. It also provides a plugin architecture that allows plugin writers to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. As this desktop application is written entirely in Java with Swing UI components, it should run on any platform that has a JVM.

<span class="mw-page-title-main">Navicat</span> SQL database management software

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

Web2py is an open-source web application framework written in the Python programming language. Web2py allows web developers to program dynamic web content using Python. Web2py is designed to help reduce tedious web development tasks, such as developing web forms from scratch, although a web developer may build a form from scratch if required.

MongoDB is a source-available, cross-platform, document-oriented database program. Classified as a NoSQL database product, MongoDB utilizes JSON-like documents with optional schemas. MongoDB is developed by MongoDB Inc. and current versions are licensed under the Server Side Public License (SSPL). MongoDB is a member of the MACH Alliance.

<span class="mw-page-title-main">Open-core model</span> Business model monetizing commercial open-source software

The open-core model is a business model for the monetization of commercially produced open-source software. The open-core model primarily involves offering a "core" or feature-limited version of a software product as free and open-source software, while offering "commercial" versions or add-ons as proprietary software. The term was coined by Andrew Lampitt in 2008.

<span class="mw-page-title-main">Opa (programming language)</span>

Opa is an open-source programming language for developing scalable web applications.

<span class="mw-page-title-main">Apache Drill</span> Open-source software framework

Apache Drill is an open-source software framework that supports data-intensive distributed applications for interactive analysis of large-scale datasets. Built chiefly by contributions from developers from MapR, Drill is inspired by Google's Dremel system. Drill is an Apache top-level project. Tom Shiran is the founder of the Apache Drill Project. It was designated an Apache Software Foundation top-level project in December 2016.

Percona is an American company based in Durham, North Carolina and the developer of a number of open source software projects for MySQL, MariaDB, PostgreSQL, MongoDB and RocksDB users. The company’s revenue of around $25 million a year is derived from support, consultancy and managed services of database systems.

Presto is a distributed query engine for big data using the SQL query language. Its architecture allows users to query data sources such as Hadoop, Cassandra, Kafka, AWS S3, Alluxio, MySQL, MongoDB and Teradata, and allows use of multiple data sources within a query. Presto is community-driven open-source software released under the Apache License.

<span class="mw-page-title-main">RocksDB</span> Embedded key-value database

RocksDB is a high performance embedded database for key-value data. It is a fork of Google's LevelDB optimized to exploit multi-core processors (CPUs), and make efficient use of fast storage, such as solid-state drives (SSD), for input/output (I/O) bound workloads. It is based on a log-structured merge-tree data structure. It is written in C++ and provides official language bindings for C++, C, and Java. Many third-party language bindings exist. RocksDB is free and open-source software, released originally under a BSD 3-clause license. However, in July 2017 the project was migrated to a dual license of both Apache 2.0 and GPLv2 license. This change helped its adoption in Apache Software Foundation's projects after blacklist of the previous BSD+Patents license clause.

TimescaleDB is an open-source time series database developed by Timescale Inc. It is written in C and extends PostgreSQL. TimescaleDB is a relational database and supports standard SQL queries. Additional SQL functions and table structures provide support for time series data oriented towards storage, performance, and analysis facilities for data-at-scale.

References

  1. "Release 24.1.0". 9 June 2024. Retrieved 21 June 2024.
  2. "Freecode DBeaver page". 2011. Archived from the original on 2016-12-03. Retrieved 2017-01-29.
  3. "Techrepublic: Manage databases with the cross-platform tool DBeaver". 2011. Archived from the original on 2017-10-28. Retrieved 2017-01-29.
  4. "DBeaver: Free Database Manager for Oracle, SQL Server, MySQL, PostgreSQL, DB2". 2011. Archived from the original on 2018-05-12. Retrieved 2017-01-29.
  5. "DBeaver legacy KnowledgeBase forum". 2011. Archived from the original on 2018-02-18. Retrieved 2017-01-29.
  6. "Eclipse Marketplace Metrics". 2016. Archived from the original on 2018-04-26. Retrieved 2017-01-29.
  7. "DBeaver in Zend Studio". 2013. Archived from the original on 2016-06-17. Retrieved 2017-01-29.
  8. "DBeaver in NXTware". 2013. Archived from the original on 2018-04-29. Retrieved 2017-01-29.
  9. "DBeaver in DeltaDNA". 2013. Archived from the original on 2017-02-02. Retrieved 2017-01-29.
  10. "DBeaver GitHub home". GitHub . 2016. Archived from the original on 2017-11-13. Retrieved 2017-01-29.
  11. "DBeaver relicense under EPL". GitHub . 2017.
  12. "DBeaver release notes on Softpedia". Archived from the original on 2018-04-29. Retrieved 2017-01-29.
  13. "Mock Data Generation in DBeaver". GitHub . 2018. Archived from the original on 2019-03-24. Retrieved 2018-04-09.