In the next article we are going to take a look at DBeaver. This is an SQL client and a database administration tool. It is a desktop application written in Java and based on the Eclipse platform. If what we want is to work with relational databases, going to use uses the JDBC API to interact with databases through a JDBC driver. For other non-SQL databases use proprietary database drivers.
This client is going to provide us with a editor that supports code completion and syntax highlighting. We will also have a plug-in architecture based on the Eclipse plug-in architecture, which will allow users to modify a large part of the application's behavior to achieve specific functions or characteristics of the database.
This software is intended for developers and supports not only Microsoft SQL. It will also allow us to work with many other relational databases popular like MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, etc. At the same time admits some NoSQL databases as MongoDB, Cassandra, Redis, Apache Hive, etc..
It is important to mention that also there is a paid version, this will allow us to use NoSQL or if we need some additional features such as Office integration or assistance.
The Community Edition (CE) of DBeaver is free and open source software which is distributed under the Apache License. A closed source enterprise edition of DBeaver is distributed under a commercial license. In the following lines we will see the free (community) edition of this tool. For more information about this, you can consult the website of this project.
DBeaver Features
- This client supports the most popular databases such as: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, MS Access, DB2, SQL Server, Sybase, Teradata, etc. Supports any database with a JDBC driver.
- Although can manipulate any external data source that may or may not use a JDBC driver.
- There is a plug-in set for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis) and different database management utilities.
- We can get visual diagrams of database objects individual and complete schemes.
- Will allow us edit or view tables. We can also export to many formats, such as CSV, HTML, XML, XLS, XLSX.
- We will have multiple data views to adapt to the variety of user needs, such as the display of image content (gif, png, jpeg, bmp).
- Online data editing and in a dedicated space.
- Will allow us join SQL queries which will be executed in the DB session right after the connection is established.
- We will find a connection manager which will allow us to configure the connections to different databases and also use some advanced properties such as the SSH tunnel, the SOCKS proxy or execute shell commands before or after the database connection.
Install DBeaver on Ubuntu
Via .deb package
Users of Debian, Deepin OS, Ubuntu and Linux Mint among other distributions with support for deb packages, we will be able to download the application's .deb package. To do so, 64-bit users will only have to open a terminal (Ctrl + Alt + T) and use the following command:
wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb
Once the download of the package is finished, we will be able to install it with the following command from the folder where we have saved the .deb package:
sudo dpkg -i dbeaver-ce*.deb
Using Flatpak
If you are interested in installing this tool, another method that we have to be able to install DBeaver Community in Ubuntu, it is through its corresponding Flatpak package. To proceed with this installation, we will only have to use the flatpak package that we can download from flathub page or opening the Ubuntu software option and installing it directly from there.
After finishing the installation, we can start using this application on our Ubuntu system. We will only have to look for the pitcher in our team.
DBeaver is useful program for professional and amateur database administrators. This makes working in databases intuitive and simple.