In this short tutorial we will learn how to install DBeaver Community Edition (CE) on Ubuntu 22.04 LTS operating system.
Introduction
In today’s data-driven world, managing and interacting with various databases efficiently is a critical aspect of business and software development. DBeaver, an open-source database tool, has emerged as a versatile and powerful solution for developers, data analysts, and database administrators. In this article, we will explore the features and benefits of DBeaver, highlighting its role in simplifying database management tasks and its significance in the software development landscape.
A Universal Database Management Tool
DBeaver is often referred to as a universal database management tool because of its ability to connect and work with a wide variety of database systems. It supports some of the most popular databases, including MySQL, PostgreSQL, Oracle, Microsoft SQL Server, SQLite, and many more. This universal compatibility makes DBeaver an indispensable tool for professionals who deal with diverse database systems.
How To Install DBeaver on Ubuntu 22.04 Linux Operating System
There are several ways to install DBeaver on Ubuntu Linux, namely: via APT repository, snap and install directly from the binary file. In this tutorial we will use DBeaver Community Edition version 23.2.1.
Installing DBeaver Using APT Repository
To install DBeaver by using the APT repository method consists of several steps as follows.
- Adding DBeaver GPG Key
- Adding DBeaver CE repository on Ubuntu 22.04
- Update Ubuntu 22.04 System
- Install DBeaver On Ubuntu 22.04
1. Adding DBeaver GPG Key
In this step, we will use curl command line to add DBeaver GPG Key to our Ubuntu 22.04 system.
$ curl -fsSL https://dbeaver.io/debs/dbeaver.gpg.key | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/dbeaver.gpg
Output
ramansah@infodiginet:~$ curl -fsSL https://dbeaver.io/debs/dbeaver.gpg.key | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/dbeaver.gpg [sudo] password for ramansah:
2. Adding DBeaver CE Repository
In this step we will add DBeaver CE repository to our Ubuntu system. For this purpose we will submit the following command line.
$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list
Output :
ramansah@infodiginet:~$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list deb https://dbeaver.io/debs/dbeaver-ce /
3. Updating Ubuntu 22.04 System Package
We need to update our system package repository to ensure if we will get the newest updated package repository. For this purposer we will submit the following command line :
$ sudo apt update
4. Install DBeaver On Ubuntu 22.04
After all prerequisite were met, then we will install DBeaver databse tools by using command line :
$ sudo apt install dbeaver-ce
Output :
ramansah@infodiginet:~$ sudo apt install dbeaver-ce Reading package lists... Done Building dependency tree... Done Reading state information... Done The following NEW packages will be installed: dbeaver-ce 0 upgraded, 1 newly installed, 0 to remove and 231 not upgraded. Need to get 124 MB of archives. After this operation, 157 MB of additional disk space will be used. Get:1 https://dbeaver.io/debs/dbeaver-ce dbeaver-ce 23.2.1 [124 MB] Fetched 124 MB in 11min 0s (188 kB/s) Selecting previously unselected package dbeaver-ce. (Reading database ... 283647 files and directories currently installed.) Preparing to unpack .../dbeaver-ce_23.2.1_amd64.deb ... Unpacking dbeaver-ce (23.2.1) ... Setting up dbeaver-ce (23.2.1) ... Processing triggers for desktop-file-utils (0.26-1ubuntu3) ... Processing triggers for gnome-menus (3.36.0-1ubuntu3) ... Processing triggers for mailcap (3.70+nmu1ubuntu1) ...
Installing DBeaver on Ubuntu 22.04 Using SNAP
Install DBeaver on Ubuntu 22.04 by using SNAP is a simple thing. We only use one single command line as follow :
$ sudo snap install dbeaver-ce
Output :
ramansah@infodiginet:~$ sudo snap install dbeaver-ce [sudo] password for ramansah: dbeaver-ce 23.2.1.202309250303 from DBeaver (dbeaver-corp) installed
This step takes a few minutes until the installation is complete.
Use DBeaver Community Edition
After DBeaver installation is completed done, then we will run it by using command line or by using GUI.
1. Using command line, we just submit the following command line :
$ dbeaver-ce
2. Using GUI, we just find the DBeaver icon, then double click the icon.
The main page on DBeaver is as shown below :
Uninstalling DBeaver From Ubuntu 22.04
In this section we will discuss how to uninstall DBeaver from Ubuntu 22.04. To remove DBeaver from Linux system, we will use a simple command line as shown below :
$ sudo apt autoremove --purge dbeaver-ce
Output :
ramansah@infodiginet:~$ sudo apt autoremove --purge dbeaver-ce [sudo] password for ramansah: Reading package lists... Done Building dependency tree... Done Reading state information... Done The following packages will be REMOVED: dbeaver-ce* 0 upgraded, 0 newly installed, 1 to remove and 231 not upgraded. After this operation, 157 MB disk space will be freed. Do you want to continue? [Y/n] Y (Reading database ... 284555 files and directories currently installed.) Removing dbeaver-ce (23.2.1) ... Processing triggers for gnome-menus (3.36.0-1ubuntu3) ... Processing triggers for mailcap (3.70+nmu1ubuntu1) ... Processing triggers for desktop-file-utils (0.26-1ubuntu3) ...
Conclusion
Whether you’re a seasoned database expert or just beginning your journey, DBeaver is a tool worth exploring to enhance your database management capabilities. In this tutorial we have learned how to install, run and unistall DBeaver community edition on Ubuntu 22.04 LTS operating system
