DBeaver, manage different types of databases from a single application

Si are looking for an alternative to Microsoft SQL Server can opt for DBeaver, which is a cross-platform database tool. DBeaver is an SQL client and database administration tool.

It is intended for developers and supports not only Microsoft SQL, but also many other databases popular relational like MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, etc.

Also toIt supports some NoSQL databases like MongoDB, Cassandra, Redis, Apache Hive, etc. Today we will see the free (community) edition of this tool.

It is important to mention that also there is a paid version that can handle NoSQLo if you need some additional features like Office integration or need assistance.

DBeaver Features

DBeaver supports all the most popular databases such as: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.

Supports any database with a JDBC driver. Although in reality, you can manipulate any external data source that may or may not have a JDBC driver.

In addition, It is based on the open source framework and allows the writing of various extensions (plugins).

There is a set of plug-ins for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis in version 3.x) and different database management utilities ( eg eg ERD).

Other features that stand out are:

• Database analysis - Provides visual diagrams of individual database objects and complete schematics.
• Data Editing - You can edit or view tables. You can export to many formats, such as CSV, HTML, XML, XLS, XLSX.
• Multiple views of data To adapt to the variety of user needs, for example, displaying image content (gif, png, jpeg, bmp) as images.
• Online data editing and in a dedicated space.
• also can join SQL queries which will be executed in the DB session right after the connection is established.
• Connection manager: There is a connection manager that allows you to configure the connection settings to different databases and also use some advanced properties like SSH tunnel, SOCKS proxy or run shell commands before or after database connection.

DBeaver is equally good for professional and hobbyist database administrators, as it makes working on databases and data intuitive, simple, and convenient.

With DBeaver, complex database administration and analysis tasks are easier than they might first appear. DBeaver does not require any special technical knowledge to back up your database in an up-to-date state and provides help when required.

How to install DBeaver on Linux?

If you are interested in installing this tool, you should know that one of the methods we have in order to install DBeaver Community on Linux via Flatpak

To install We just have to open a terminal and in it execute the following command:

flatpak install --user https://flathub.org/repo/appstream/io.dbeaver.DBeaverCommunity.flatpakref

With this they will be able to start using this application on their systems. Just search for the launcher within your application menu.

If you can't find it, you can run the application with the following command:

flatpak run io.dbeaver.DBeaverCommunit

Installation on Debian, Ubuntu and derivatives

If they are users of Debian, Deepin OS, Ubuntu, Linux Mint among other distributions with support for deb packages, they can download the deb package of the application.

For those who are 64bit system users, the package to download is the following:

wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb

While for those who are 32bit system users the package for your architecture is:

wget https://dbeaver.io/files/dbeaver-ce_latest_i386.deb

After downloading the package, we can install it with the following command:

sudo dpkg -i dbeaver-ce*.deb

And the dependencies we solve with:

sudo apt -f install

Installation via RPM package

This method is similar to the previous one, only it applies to distributions with support for RPM packages, such as Fedora, CentOS, RHEL, OpenSUSE and others.

In this case, the packages that we must download are the following, 64 bit:

wget https://dbeaver.io/files/dbeaver-ce-latest-stable.x86_64.rpm

Or for 32-bit systems:

wget https://dbeaver.io/files/dbeaver-ce-latest-stable.i386.rpm

Finally we install with:

sudo rpm -i dbeaver-ce-latest*.rpm