If you are a developer you know that the database is an important element of the process. That’s why knowing the data and managing it quickly and comfortably becomes a priority. On the other hand, it is necessary to recognize that graphic clients are a great solution to this problem. With this in mind, this post will teach you how to install DBeaver on Ubuntu 20.4 / 18.04.
DBeaver is a client for database managers, which allows managing in a comfortable way the data and options of the database instance. It supports the main database applications, such as MySQL, MariaDB, PostgreSQL, Microsoft SQLServer, IBM DB2 or Oracle.
But not only is limited to database relationships but supports the handling MongoDB, Cassandra, and Redis. In other words, NoSQL database.
So, let’s install DBeaver.
1. Upgrade the system
The first step, to install DBeaver properly is to upgrade the system. So, open a terminal and run.
:~$ sudo apt update && sudo apt upgrade
The advantage of doing this is that you will have the security patches installed. With this, your system will be more stable.
2. Install Java
DBeaver requires java to work. Its latest stable version adds support for Java 11, so you can use the steps outlined in our tutorial.
3. Install DBeaver on Ubuntu 20.04 / 18.04
To make it even easier to install DBeaver it’s a good idea to do it from your repository. With this also, it will be easier to have it updated.
First, add the GPG key.
:~$ wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
Next, add the repository.
:~$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list
Then, install DBeaver.
:~$ sudo apt update && sudo apt install dbeaver-ce
4. Test DBeaver
Now we have to try DBeaver. To do this, first install some of the database handlers supported by the application. I will install MariaDB.
:~$ sudo apt install mariadb-server
Next, create a database and user for DBeaver.
:~$ sudo mysql -u root -p CREATE DATABASE dbeaver; GRANT ALL PRIVILEGES ON dbeaver.* TO 'dbeaveruser'@'localhost' IDENTIFIED BY 'dbeaverpss'; FLUSH PRIVILEGES; exit;
Next, launch it. Yo will see this.
Now, Create a new database connection. Go to File -> New. On DBeaver section, select Database Connection.
Select MariaDB. Next, set the connection settings.
After defining the connection parameters, if there is no driver installed, DBeaver will download it and show you something like this.
Finally, you will see all the information about the connection.
Of course, having a large database, with lots of tables and data, you will understand the importance of DBeaver. For now, it won’t show any data.
Having a great tool to visualize the data and options of a database is very important if you are a developer. That’s why DBeaver is profiled as a pretty good tool focused on productivity. In addition, it has the advantage of being open source and supporting a large number of database handlers.
Please share this post with your friends. Happy new year.