In this article we are going to install and setup a Database management tool which is DBeaver. DBeaver is available for the cross platforms to support multiple databases including MySQL, Postgresql and GreenPlum. DBeaver can be used as an alternative of MySQL-Workbench and PGAdmin. It has a user-friendly interface that makes it more useful for its new users. Using DBeaver, you can create local databases and also configure the maximum result size to avoid session hanging issues in case the query results take time to process big queries.

DBeaver comes with a community edition which is free to use as well as with an enterprise edition that supports NoSQL Databases. We will be using its latest available community edition on a Linux CentOS 7 Desktop and LinuxMint Desktop.

Prerequisites:

The prerequisite for this article is to have a Linux System running with Linux based GUI system with user having sudo rights.

Login to your system and update with the latest available security updates using yum command as below.

For RHEL/CentOS:

For Ubuntu/LinuxMint:

Downloading DBeaver Community:

You can get the DBeaver Community edition download installer from their official web link https://dbeaver.io/download/ where you can choose the installer for your system.

Let’s get the RPM package for your RHEL/CentOS based system and DEBIAN in case you are using Ubuntu or LinuxMint.

Downloading DBeaver Community

Get it downloaded on your system and then upload on the server you have to make its setup or simply use the ‘wget’ command as below on your system.

On Ubuntu/LinuxMint:

Setup DBeaver

Installing DBeaver in Linux:

Once you have got your Dbeaver package uploaded, let install it using the command below.

On RHEL/CentOS:

On Debian/LinuxMint:

Installing DBeaver in Linux

Using DBeaver in Linux:

Now, as we have installed DBeaver, let’s open it from the menu or search it in the application finder.

Using DBeaver in Linux

You will be prompted with an option to create the sample database or start with a new connection.

Start work in DBeaver

Point to the Database tab and select to create a new connection by choosing your desired Database as shown below.

Point to the Database tab

Moving next to the database connection settings, give the details of your database server you want to connect with and click to finish.

Connection settings

As we have mentioned earlier, DBeaver supports multiple ranges of database engines, so in some cases, you may need to upload its jar files.

Just like in the image below, you can see that while loading the Greenplum DB it asks to load the required drivers that you can directly download.

Greenplum Database

In case if you don’t have internet access available on your system, you can take the offline jars required for your database and upload using the DBeaver Driver Manager.

DBeaver Driver Manager

Here, when you have successfully uploaded the jars, you can delete the old one which is not required for your db connection.

 

Setting JVM Parameters for DBeaver:

In case you have multiple databases and high workloads that may impact the performance of dbeaver. In that case you can also tweak its JVM parameters by editing the file below with its XMS and XMX values.

StarWind Backup Appliance (BA) is an industry-first all-NVMe backup appliance that provides unprecedented levels of backup and recovery speed. It comes as a tiny, pre-configured, ready-to-backup solution that eliminates the backup server storage bottleneck and fits even the strictest RTPO. Consisting of the best commodity hardware, your chosen hypervisor, and a StarWind SDS engine backed by 24/7/365 ProActive Support, StarWind BA ushers in a new age of a future-proof, eco-friendly, transparent, and reasonably priced backup infrastructure. Explore Backup Appliance from StarWind StarWind Backup Appliance Datasheet

Conclusion:

At the end of this article, you should be familiar with the DBeaver, its installation setup on Linux and use of making DB Connections of your choice. It has many features that many other database managers don’t have like its support for multiple databases, OpenSource edition, SQL query execution and SSH tunneling etc. Hope you have found this article much helpful while working on DBeaver or while searching for a best Database manager solution.

Back to blog
The following two tabs change content below.
Karim Buzdar
Karim Buzdar
Karim Buzdar holds a degree in telecommunication engineering and holds several sysadmin certifications. As an IT engineer and technical author, he writes for various websites.