Dbeaver Supported Databases



Support for enterprise databases. If you’re planning to deploy your website or application, DBeaver is an ideal choice for you. DBeaver supports the most popular enterprise databases. Even if you work with a complicated and dense database, there is no need to worry about it not handling large amounts of data.

How to install DBeaver on CentOS

For ease of access and work with databases, it's always good to have the GUI. Yes, working with a large number of databases sometimes requires us to use GUI solutions. I personally prefer console access to the database. But, in scenarios with a focus on the underlying cause, any GUI is welcome. Today, we will run through the process of how to install DBeaver on CentOS.

  1. DBeaver Universal Database Tool Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.
  2. What is DBeaver? Database management tool that supports SQL editor, mock data generator, visual query builder, metadata browser, data transfer and more.
  3. Oracle database (Express or Enterprise) is one of the most advanced relational databases. Enterprise-level relational database developed by IBM. Supported drivers are: DB2 for LUW (Linux/Unix/Windows), DB2 for z/OS, DB2 for iSeries / AS400.
  4. DBeaver is desktop application. If you are looking for a web-based database management system – please check another of our products: CloudBeaver. It is also open-source and free.

DBeaver is the database management tool and if you are installing it on a remote CentOS server, make sure you have the RDP service installed first! Otherwise, just continue from here.

Pre-requirements

Before we can install DBeaver on CentOS let's make sure that we have at least one of the database engines installed. This is a list of DBeaver supported database engines:

  • MySQL
  • PostgreSQL
  • MariaDB
  • SQLite
  • Oracle
  • DB2
  • SQL Server
  • Sybase
  • MS Access
  • Teradata
  • Firebird
  • Derby

We are going to use the MariaDB server as it's already installed on our test server. If you don't have it, follow these steps to install MariaDB on CentOS server.

Now, let's install a must-have requirement, JAVA:

Check if it's installed by running:

Installation

Download the DBeaver package:

Execute the installation:

That's it! Now, find the launcher for DBeaver and hit it:

If you want, DBeaver can create a test database for you to begin exploring it. Otherwise, you can connect it to your own database and continue from there.

Dbeaver Supported Databases Free

Connect to Database

Databases

Let's connect the DBeaver to our database now! First, navigate to Database - New Database Connection:

Next, let's select our database engine (in our case MariaDB):

Almost there! Now, use our database user credentials to connect DBeaver to MariaDB:

That's it, now we can see our local databases served by MariaDB server:

Voila! Now, the real work can begin 😁! Read you later ✌️.

Related Articles:
How to install MariaDB on CentOS
How to install Remote Desktop Service on the CentOS

  • SQL editor:
    • “Open SQL console” action was added to the main toolbar and context menu
    • Support of very long sql scripts was improved
    • Parser hanging was fixed (partially) for queries with a lot of parenthesis
    • Auto-completion performance was improved
  • Data editor:
    • Drop-down inline editor was fixed (Linux)
    • Epoch time transformer now supports timezones
    • Copy As SQL: now uses correct SQL dialect
  • Metadata editor: support of pure unicode identifiers was added
  • Content assistant was fixed for drop-down selectors
  • Connection configuration import now supports target folders
  • GIS (spatial) data viewer:
    • MapBox tile configuration was fixed
    • 3D geometry objects now can be displayed on map
    • Geometry transformer for binary format (WKB) was added
  • Trino (ex-PrestoSQL) driver was added (thanks to @mosabua)
  • MariaDB: default driver version upgraded to 2.7.1
  • SQLite:
    • Spatial (gis) data viewer was added
    • Metadata refresh was fixed (wrong foreign key name)
  • PostgreSQL:
    • SQL formatting for custom data types was fixed (geometry and others)
    • Backup/restore now support non-standard authentication (e.g. IAM)
    • Redundant data types removed from navigator tree (arrays)
    • Nested multiline comments support was added
    • Database template list now contains all databases
  • Redshift: driver version was upgraded (bug with “session is read-only”)
  • Presto/Trino: GIS transformers support was added
  • Firebird:
    • SQL parser was fixed (code blocks)
    • Table/view type recognition was improved (for older FB versions)
  • Number of errors with wrong focus tracking fixed on MacOS
  • Clear message for Java version mismatch errors was added
  • Now DBeaver can be installed without bundled Java (Windows and Linux)
  • Problem with Eclipse Marketplace extension was fixed
  • Several minor UI bugs were fixed

Dbeaver Supported Databases Vs

Posted in Releases