How to Install DBeaver on Ubuntu 20.04 / 22.04. First of all this article talks about universal database management tool, which is DBeaver. With it you are able to process, find all SQL, NoSQL, and cloud data sources. This guide introduces DBeaver, its advantages, features, then show you how to install DBeaver on Ubuntu.
Shall we start with How to Install DBeaver on Ubuntu 20.04 / 22.04.
What is DBeaver?
All in all, DBeaver is an all in one, open source database management tool that makes it easier for users to manage different database types. 80+ databases are supported by DBeaver, including MySQL, Oracle, Google Cloud, PostgreSQL, SQL Server, and SQLite.
Both the community version and the commercial enterprise edition are available for DBeaver. The community version is free, open source, and supports all types of relational databases. Relational databases are accessed through a JDBC adapter using the JDBC application programming interface (API).
On the other hand, the enterprise edition supports all NoSQL databases. Unlike relational databases, it uses proprietary database drivers for NoSQL databases.
Basically you are able to easily transfer the database management process with its excellent features. Additionally, it offers high level security and features that make it easy to analyse, compare, and transfer information in different formats. Using the plugins, you can even the application’s behavior and enhance functionality. Another best part about DBeaver is it works well with all operating systems, including macOS, Linux, and Windows.
Features of DBeaver
DBeaver offers access to various features, including:
- Data Editor: The convenient data editor allows users to handle a majority of data formats and has intuitive navigation. It further allows access to custom filters, and multiple data views, and enables users to sort results easily.
- Database browser: Users examines and controls database objects like views, tables, indexes, as well as stored procedures with the help of the database browser provided by DBeaver.
- SQL editor: DBeaver has a powerful SQL editor that supports syntax highlighting, aids in developing, executing, and storing scripts, and formatting, as well as uses data profiling for re using scripts. Additionally, the SQL history function allows users to quickly access previous queries.
- Data Transfer and Synchronization: With the help of data transfer and synchronization tools, users import/export information to/from files and synchronize data between databases. Users easily transfer files in different supported formats like XML, CSV, HTML, JSON, XLX, etc.
- Database Navigator: By expanding the collection of databases, Database Navigator enables you to navigate the database objects contained within each database.
- ER diagram editor: The ER diagram editor helps users create or edit database diagrams easily.
- Database Analysis: This feature allows users to create and export visual representations of database items and entire schemas.
- Driver manager: Another key feature of DBeaver is it allows users to handle database drivers and make new database connections using the driver manager.
- Data viewer: With the help of the data viewer, users easily view all the table data.
- Query Builder: Working with pre existing SQL queries is best done in visual mode. With the help of query builder, you always run a visually constructed query and see the outcomes on the screen at any time.
Advantages of DBeaver
No matter whether you want a database administration tool for managing relational or NoSQL databases, DBeaver is a great option. Have a look at a few benefits of DBeaver:
- Supports Multiple databases: Most developers and database administrators choose DBeaver over other platforms in the market for it offers support to 80+ databases and allows them to work simultaneously with different databases.
- SQL editor: The robust SQL editor in DBeaver enables formatting, code completion, and syntax highlighting as well as allows multiple result sets that ease the process of working with complex queries.
- User friendly interface: The user friendly interface of DBeaver makes things simple for beginners as well as regular users. With DBeaver, it is very simple to explore thanks to the intuitive layout and organisation of the interface.
- Easy to Customize: Another benefit of DBeaver is it is highly customizable. Users gain full access to adjust settings as per their choice or add plugins to improve performance and functionality.
We have arrived at the main part of the article How to Install DBeaver on Ubuntu 20.04 / 22.04
How to Install DBeaver on Ubuntu 20.04 / 22.04
Prerequisites
- A system running Ubuntu 20.04 or 22.04 desktop.
- A root user or a user with sudo privileges.
Install Java JDK
By default, Java is included in the Ubuntu default repository. Install it using the apt command.
apt install default-jdk -y
After installing Java package, verify the Java version using the following command.
java -version
Install DBeaver
By default, the latest version of DBeaver is not available in the Ubuntu default repository. You need to add the DBeaver repository to APT.
First, download and add the DBeaver GPG key using the following command.
curl -fsSL https://dbeaver.io/debs/dbeaver.gpg.key | gpg --dearmor -o /etc/apt/trusted.gpg.d/dbeaver.gpg
Next, add the DBeaver repository to apt with the following command.
echo "deb https://dbeaver.io/debs/dbeaver-ce /" | tee /etc/apt/sources.list.d/dbeaver.list
After that, update the repository cache using the following command.
apt update -y
Once the repository is updated, install the DBeaver with the following command.
apt install dbeaver-ce -y
After the successful installation, verify the DBeaver package with the following command.
apt policy dbeaver-ce
You should see the package information on the following screen.
Install and Configure MariaDB Server
apt install mariadb-server -y
After installing the MariaDB server, connect to the MariaDB shell with the following command.
mysql
Once you are connected to the MariaDB shell, create a database and user with the following command.
MariaDB [(none)]> CREATE DATABASE dbeaverdb;
MariaDB [(none)]> CREATE USER 'dbeaver'@'localhost' IDENTIFIED BY 'securepassword';
Next, grant all the privileges to the database with the following command.
MariaDB [(none)]> GRANT ALL PRIVILEGES ON dbeaverdb.* TO 'dbeaver'@'localhost';
Then, flush the privileges and exit from the MariaDB shell with the following command.
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> QUIT;
Once you are done, please proceed to the next step.
Connect MariaDB Database Using DBeaver
At this point, DBeaver is installed on the system. Now, open it from the Ubuntu dash.
A). After that, you shall see the DBeaver interface on the following screen.
B). Click on the New => Create Connection button to create a new database connection. You should see the following screen.
C). Provide your database host details, port, database name, username, password and click on the Test Connection button. You should see the Driver setting screen.
D). Click on the Download button to download the drive and connect to the MariaDB database. You should see your database on the following screen.
Thank you for reading How to Install DBeaver on Ubuntu 20.04 / 22.04. We shall conclude this article now.
How to Install DBeaver on Ubuntu 20.04 / 22.04 Conclusion
Finally, DBeaver is a user friendly and feature rich database management tool that helps developers as well as database administrators to manage multiple databases without any hassle. It has a unified interface that makes it easy for beginners to access, monitor, and handle several databases. Also call it a versatile tool for it supports over 80 databases.
Anyone dealing with database needs can switch to DBeaver because it offers a powerful SQL editor and a customizable interface. Additionally, it provides advanced features like a Data editor, Data Transfer, and Synchronization, Database Analysis, ER diagram editor, data import/export, query optimization, etc. Additionally, users create complex queries quickly and easily, view data in a variety of formats, and analyse big data quickly.
Please explore more of MariaDB content by navigating here.
