PC: www.dbeaver.com |
DBeaver CE is a free and open-source multi-platform database management tool/SQL client designed for Developers, SQL programmers, Analysts, and Database administrators. It supports any database which has JDBC driver – MySQL/MariaDB, PostgreSQL, Oracle, DB2 LUW, Google BigQuery, Exasol, SQL Server, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc. DBeaver is based on the Eclipse platform and is a good workbench tool for building SQL queries, editing, and transferring data, viewing trees of objects, completing database administration tasks, monitoring database connection sessions, and a lot more.
Install Java on Ubuntu 16.04/18.04/20.04
Run the following commands to have Java installed and set as default Java on your Ubuntu 20.04/18.04/16.04.
sudo apt -y install openjdk-11-jdk openjdk-11-jre
To set as default Java in Ubuntu
sudo update-alternatives --config java
Confirm version:
java -version
Install OpenJDK on Debian 10/9
OpenJDK is the default Java development and runtime available on Debian 10/9 repository. Install it by running the command below:
sudo apt -y install default-jdk
Check Java Version:
java -version
Add DBeaver repository to your Debian by running the commands below:
sudo wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
sudo echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list
sudo apt update
sudo apt -y install dbeaver-ce
Add DBeaver repository to your Ubuntu by running the commands below:
sudo apt update
sudo apt -y install dbeaver-ce
Add DBeaver repository to your Ubuntu by running the commands below:
sudo add-apt-repository ppa:serge-rider/dbeaver-ce
sudo apt-get update
sudo apt-get install -y dbeaver-ce
sudo apt-get install -y dbeaver-ce
Install DBeaver version can be checked using:
sudo apt policy dbeaver-ce
sudo apt policy dbeaver-ce
How to fix – DBeaver MySQL/MariaDB Native client is not specified for connection
Reference: