Let’s learn the commands and steps involved in installing and using DBeaver on Debian 11 Bullseye with the help of the terminal.
DBeaver is an open-source community tool to help the user in administrating different databases. It is a small in size tool that admins and developers can use to access databases to analyze data or manage the respective database. The tool is available for Windows, Linux, and macOS. A plug-in for Eclipse is also available.
Users can manage various databases such as MySQL, PostgreSQL, SQLite, Oracle, DB2, Microsoft SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, or Presto. However, a large number of other databases are available. The tool displays this in the open dialog.
Using the single interface of DBeaver, it is possible to connect different database systems and manage the databases. We can not only open and display the databases, but also perform queries in the databases, run scripts, and also export data from tables. Changing metadata in the tables and adjusting values are also possible with DBeaver. Several connections to different database systems can easily be set up in the user interface. After the connection is established, DBeaver displays the tables. Data can be adjusted or analyzed here. Data can be exported in various formats, for example HTML, CSV, MD, XML, SQL or TXT. The community edition is limited in terms of features, for more support and professional features, go for the Enterprise edition.
Steps to install DBeaver on Debian 11 Bullseye Linux
There are multiple ways to install DBeaver on Debian 11 Bullseye Linux, here we discussed all the simple and possible ways.
#1st method using Deb binary
1. Download DBeaver
The easiest possible way to install DBeaver is to directly download the DBeaver binary meant for the Debian system. You don’t need to visit its official website to get a package for installation. It can be done directly via the terminal command.
sudo apt install wget
2. Install DBeaver on Debian 11
If you have followed the commands given in the previous step you would already have the Debian binary of this Database Manager. Now, let’s use the APT package manager to install it. This will also resolve any dependencies required by the DBeaver.
sudo apt install ./dbeaver-ce_latest_amd64.deb
3. Run the Database Manager
Well, after running the above-given command, Dbeaver will be on your system. To launch it, go to the application launcher and search for it. As the icon of this community tool appears, click to run the same.
#2nd method using the repository
The problem with the first method is- running the system update command will not update the DBeaver. Hence, we have to manually install every new version of the software by running the above commands. To solve this issue we can use the official repository offered by the developers of this software.
4. Add DBeaver CE repository on Debian 11
Let’s first add the GPG key that requires by the system to ensure the packages we will have from the Dbeaver repository are from the original source.
curl -fsSL https://dbeaver.io/debs/dbeaver.gpg.key | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/dbeaver.gpg
echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list
sudo apt update
5. Use APT to install Database Manager
Once you have successfully added the repository and GPG key of DBeaver, we can install the Database Manager using the APT package manager.
sudo apt install dbeaver-ce
After installing it, like any other application, this one will also be available to run from the Application launcher area of Debian. Alternatively, the user can go for command-
6. How to update DBeaver
Well, if you have used this repository method, then we don’t have to download any other thing to get the latest version of this Database manager. Running the system update command will also install any latest version of the DBeaver, if available.
sudo apt update && sudo apt upgrade
#Use Snap method:
7. Use Snap to install the Dbeaver-CE edition
Well, unlike Ubuntu, Snap is not a part of Debian 11 by default. Therefore, we need to install SNAP, first.
sudo apt update sudo apt install snapd sudo snap install core
Once the Snap is on your system, run:
sudo snap install dbeaver-ce
After the above command, reboot your system.
8. Uninstall or Remove
If you have used Deb binary or repository, then the command to remove DBeaver will be this:
sudo apt autoremove --purge dbeaver-ce
For SNAP installed version:
sudo snap remove dbeaver-ce
All the given methods are good to go, however, we recommend choosing the repository method so that in the future you can easily get the available updates for Dbeaver using the command terminal.