DBeaver is a desktop client for managing databases from a graphical interface.
If we work with MySQL, MariaDB, PostgreSQL, SQLite, or other databases, a graphical client helps us explore tables, run queries, and review data without doing everything from the console.
One of the most popular is DBeaver, a cross-platform SQL client and database administration tool. It supports a wide variety of database types such as MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, among others.
DBeaver is a desktop application written in Java. The interface is pleasant and functional. It provides commands to perform practically all the functions you might ever need to do in a database, in a simple way.
It has two types of licensing. The Community Edition (CE) is free and Open Source, distributed under the Apache license. There is also a commercial version that includes, among other features, compatibility with NoSQL databases.
To install DBeaver, we simply have to download and run the installer for our operating system (Debian package in the case of Raspberry Pi OS) from the project’s download page https://dbeaver.io/download/.
Once installed, we add the data sources we need. For most databases, it will be necessary to install the third-party driver. Fortunately, DBeaver provides us with instructions and the link to install the drivers.
Once connected to the database, using DBeaver is very intuitive. The windows and menus are intuitive yet powerful. It is easy to access the necessary functions and tools, such as creating/deleting/renaming databases or tables, running queries, exporting queries, among many others.
In short, DBeaver is a very interesting and recommended software if you are going to work regularly with databases on any operating system.
In projects where we use databases, DBeaver is a very convenient tool for reviewing tables, running queries, and managing connections. If you are going to work with SQL regularly, it is worth keeping it on your radar.
