Your cart
  • IMG
    {{cart_item.name}}
    {{cart_item.variation_attribute_name}}: {{cart_item.variation_attribute_label}}
    {{cart_item.item_unit}}: {{ setCurrency(cart_item.price)}}
    {{ setCurrency(cart_item.price*cart_item.quantity)}}
    Invalid quantity more than stock
Total :
{{setCurrency(cart.sub_total)}}

There is no item in the cart. If you want to buy, Please click here.

DBreaver installation in Ubuntu OS

Complete guide to start Linux OS and install essential applications in Linux

Created by :
Linux
tutorial
Programming, Software and application
1408
2022-01-09 18:30:29

DBeaver is a database 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.


 DBeaver 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. If you need support for non-JDBC data sources such as WMI, MongoDB, Cassandra, Redis, then consider using DBeaver Enterprise Edition.


Follow steps below to Install DBeaver on Ubuntu 20.04|18.04 /16.04.


Step 1: Install Java (OpenJDK) on Ubuntu

OpenJDK is the default Java development and runtime available on Debian repository. Run the following commands to have Java installed and set as default Java on your Ubuntu 22.04|20.04|18.04|16.04.


sudo apt update 
sudo apt -y install default-jdk


Confirm version:

saidul@saidul-Inspiron-5502:~$ java -version
openjdk version "11.0.13" 2021-10-19
OpenJDK Runtime Environment (build 11.0.13+8-Ubuntu-0ubuntu1.20.04)
OpenJDK 64-Bit Server VM (build 11.0.13+8-Ubuntu-0ubuntu1.20.04, mixed mode, sharing)


Step 2: Add Debian repository and install DBeaver CE

Add DBeaver repository to your Debian / Ubuntu by running the commands below:


wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add - echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list


After adding the repo, update the apt list and install DBeaver CE:


sudo apt update 
sudo apt install dbeaver-ce


Install DBeaver version can be checked using:

saidul@saidul-Inspiron-5502:~$ apt policy  dbeaver-ce 
dbeaver-ce:
  Installed: 21.3.2
  Candidate: 21.3.2
  Version table:
 *** 21.3.2 500
        500 https://dbeaver.io/debs/dbeaver-ce  Packages
        100 /var/lib/dpkg/status


Step 3: Prepare Database Server

Before launching and configuring DBeaver service, you may first need to create a database and database user to connect to. For this demonstration, I’ll use the MariaDB database server.