DBeaver, manage different types of databases in a simple way

about DBeaver

In the next section, we will look at DBeaver. This is a SQL client and a database administration tool. It is a desktop application written in Java and based on the Eclipse platform. If what we want is to work with relational databases, will use using JDB API to interact with the database through the JDBC driver. For other non-SQL databases, use the proprietary database driver.

You are watching: What is Dbeaver?

This customer will give us the editor supports code completion and syntax highlighting. We will also have a plugin architecture based on the Eclipse plugin architecture, which will allow the user to modify a large portion of the application's behavior to achieve database specific functions or characteristics.

This software is intended for developers and does not only support Microsoft SQL. It will also allow us to work with many Relational database popular like MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, etc. Also admits some NoSQL databases like MongoDB, Cassandra, Redis, Apache Hive, etc.

It is important to mention that also there is a paid versionthis will allow us to use NoSQL or if we need some additional features such as Office integration or support.

See also: What does "Stroke" mean: Definition, Example in English

database available with dbeaver

DBeaver Community Edition (CE) is free and open source software distributed under the Apache License. The closed source enterprise edition of DBeaver is distributed under a commercial license. In the next few lines we will see the free (community) version of this tool. For more information on this, you can refer to website of this project.

Features of DBeaver

bd data dbeaver

This client supports the most popular databases such as: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, MS Access, DB2, SQL Server, Sybase, Teradata, etc. Supports any database with JDBC driver.

In spite of can manipulate any external data source that may or may not use the JDBC driver.

Only one plug-in set for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis) and various database management utilities.

We can get visual diagram of database objects individual and complete programs.

Will allow us edit or view the table. We can also export to many formats, such as CSV, HTML, XML, XLS, XLSX.

We will have multiple data views to adapt to a variety of user needs, such as displaying image content (gif, png, jpeg, bmp).

Online data editing and in a dedicated space.

Will allow us join SQL queries will be executed in the DB session as soon as the connection is established.

We will find a Connection manager this will allow us to configure connections to different databases and also use some advanced properties like SSH tunneling, SOCKS proxies or execute shell commands before or after the base connection database.

Install DBeaver on Ubuntu

Via the .deb . package

Users of Debian, Deepin OS, Ubuntu and Linux Mint among other distributions with deb package support, we will be able to download the app .deb package. To do this, 64-bit users will only have to open a terminal (Ctrl + Alt + T) and use the following command:

download DBeaver .deb . package

wget

Once the package download is complete, we will be able to install it using the following command from the directory where we saved the .deb . package:

Reference: What is 20W50 lubricant? Oil 20w50 used for which engine?

install .deb . package

sudo dpkg -i dbeaver-ce*.deb

Using Flatpak

If you are interested in installing this tool, another method we must have to be able to install DBeaver Community in Ubuntu, it's through its respective Flatpak package. To proceed with this installation we will only have to use the flatpak package that we can download from flathub . site or open Ubuntu Software Options and install it directly from there.

flatpak package from software option