Si are looking for an alternative to Microsoft SQL Server can opt for DBeaver, which is a cross-platform database tool. DBeaver is an SQL client and database administration tool.
It is intended for developers and supports not only Microsoft SQL, but also many other databases popular relational like MySQL, PostreSQL, SQLite, Oracle, DB2, MariaDB, Sybase, Teradata, Netezza, etc.
Also toIt supports some NoSQL databases like MongoDB, Cassandra, Redis, Apache Hive, etc. Today we will see the free (community) edition of this tool.
It is important to mention that also there is a paid version that can handle NoSQLo if you need some additional features like Office integration or need assistance.
Table of Contents
DBeaver supports all the most popular databases such as: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.
Supports any database with a JDBC driver. Although in reality, you can manipulate any external data source that may or may not have a JDBC driver.
In addition, It is based on the open source framework and allows the writing of various extensions (plugins).
There is a set of plug-ins for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis in version 3.x) and different database management utilities ( eg eg ERD).
Other features that stand out are:
- Database analysis - Provides visual diagrams of individual database objects and complete schematics.
- Data Editing - You can edit or view tables. You can export to many formats, such as CSV, HTML, XML, XLS, XLSX.
- Multiple views of data To adapt to the variety of user needs, for example, displaying image content (gif, png, jpeg, bmp) as images.
- Online data editing and in a dedicated space.
- also can join SQL queries which will be executed in the DB session right after the connection is established.
- Connection manager: There is a connection manager that allows you to configure the connection settings to different databases and also use some advanced properties like SSH tunnel, SOCKS proxy or run shell commands before or after database connection.
DBeaver is equally good for professional and hobbyist database administrators, as it makes working on databases and data intuitive, simple, and convenient.
With DBeaver, complex database administration and analysis tasks are easier than they might first appear. DBeaver does not require any special technical knowledge to back up your database in an up-to-date state and provides help when required.
How to install DBeaver on Linux?
If you are interested in installing this tool, you should know that one of the methods we have in order to install DBeaver Community on Linux via Flatpak
To install We just have to open a terminal and in it execute the following command:
flatpak install --user https://flathub.org/repo/appstream/io.dbeaver.DBeaverCommunity.flatpakref
With this they will be able to start using this application on their systems. Just search for the launcher within your application menu.
If you can't find it, you can run the application with the following command:
flatpak run io.dbeaver.DBeaverCommunit
Installation on Debian, Ubuntu and derivatives
If they are users of Debian, Deepin OS, Ubuntu, Linux Mint among other distributions with support for deb packages, they can download the deb package of the application.
For those who are 64bit system users, the package to download is the following:
While for those who are 32bit system users the package for your architecture is:
After downloading the package, we can install it with the following command:
sudo dpkg -i dbeaver-ce*.deb
And the dependencies we solve with:
sudo apt -f install
Installation via RPM package
This method is similar to the previous one, only it applies to distributions with support for RPM packages, such as Fedora, CentOS, RHEL, OpenSUSE and others.
In this case, the packages that we must download are the following, 64 bit:
Or for 32-bit systems:
Finally we install with:
sudo rpm -i dbeaver-ce-latest*.rpm
Be the first to comment