Installing DBeaver in Ubuntu 22.04

DBeaver is an open source database management tool that can be used to work with various types of databases including MySQL, PostgreSQL, Oracle, SQLite, SQL Server, MongoDB and many others.

DBeaver Features

DBeaver provides a graphical user interface (GUI) for querying databases, and for managing databases and their objects such as tables, procedures, and views.

DBeaver has a number of useful features such as auto-complete, built-in SQL editor, support for exporting and importing data, the ability to create reports and charts, administration tools, and more.

The utility is available for installation in Ubuntu 22.04 via the official Ubuntu repository or via PPA (personal package archive) for newer versions.

Installing the program

Open a terminal and run the following command to add the DBeaver repository:

sudo add-apt-repository ppa:serge-rider/dbeaver-ce

Update the package list:

sudo apt update

Install DBeaver:

sudo apt install dbeaver-ce

Once installed, DBeaver should be available in the application menu.

Note: If you want to install DBeaver Enterprise Edition, you can download the corresponding .deb file from the official DBeaver website and run the following command:

sudo dpkg -i <путь_к_файлу.deb>

How to Setup and Run

1. After installation, you can launch DBeaver by selecting it from the application menu or type the command "dbeaver" in the terminal.

2. The first time you start DBeaver, you will have to select the type of database connection, such as MySQL or PostgreSQL. Select the desired type and enter the connection parameters such as hostname, port, username and password.

3. After entering the connection parameters, you can start working with the database using DBeaver. From the DBeaver interface, you can execute SQL queries, create and edit tables and other database objects, export and import data, create reports and charts, and more.

After installing DBeaver, you can also upgrade to the latest version by executing the following command in the terminal:

sudo apt update
sudo apt upgrade dbeaver-ce

This will update DBeaver to the latest version available in the Ubuntu repository.