Shulou(Shulou.com)05/31 Report--

This article is about how to download and install DBeaver. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

DBeaver is a free and open source general database management and development tool based on Java, using a very friendly ASL protocol. It can be downloaded through the official website or Github.

Because DBeaver is based on Java development, it can run on a variety of operating systems, including Windows, Linux, macOS and so on. DBeaver uses Eclipse framework to develop, supports plug-in extension, and provides many database management tools: ER diagram, data import / export, database comparison, simulation data generation and so on.

DBeaver connects to the database through JDBC and can support almost all database products, including MySQL, PostgreSQL, MariaDB, SQLite, Oracle, Db2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby and so on. The commercial version can support a variety of NoSQL and big data platforms: MongoDB, InfluxDB, Apache Cassandra, Redis, Apache Hive and so on.

Download and install

DBeaver Community Edition can be downloaded through the official website or Github. Both provide installation packages or unzipped versions for different operating systems, and you can choose whether you need to install JRE at the same time. In addition, the official website also provides DBeaver's Eclipse plug-in, which can be integrated in Eclipse.

DBeaver supports Chinese, and the installation process is very simple, needless to say, the only thing to note is that the operation of DBeaver depends on JRE. Not surprisingly, run dbeaver.exe in the installation directory after the installation is complete and you will see the following interface (Windows 10):

This interface is actually a new database connection, and we can see the various data platforms it supports; first click the "cancel" button to enter the main window interface.

At this point, it prompts us whether to build a sample database.

If you click "Yes", it creates a default SQLite sample database. The following picture is its main window interface.

DBeaver is similar to our commonly used software, with menu items and shortcut tools at the top, established database connections and project information on the left, and the main work area on the right.

Connect to the database

After opening DBeaver, the first thing to do is to create a database connection. You can open the New connection wizard window from the menu "Database"-> "New connection", which is the window that popped up when we first ran DBeaver.

Let's take PostgreSQL as an example to create a new database connection. Select the PostgreSQL icon and click next (N).

Then set the connection information of the database: host, port, database, user, password. The "Advanced settings" advanced setting options can configure SSH, SSL, agent, etc., or you can specify your own name and connection type for the connection (development, test, production).

Click "Test Link (T)" at the bottom to test the correctness of the connection configuration. When you first create a connection to a database, you are prompted to download the appropriate JDBC driver.

It has found the corresponding driver for us, just click "download", it is very convenient. After the download is complete, if the connection information is correct, you can see a prompt for a successful connection.

After confirmation, you can complete the connection configuration. A new database connection is added to the database navigation on the left.

Because the JDBC driver for some databases (such as Oracle, Db2) needs to be logged in before it can be downloaded, it can be configured manually. Select the menu Database-> driver Manager.

Select Oracle and click "Edit (E) …" Button.

Manually download the JDBC driver file for the Oracle database, such as ojdbc8.jar, via the URL prompted by the interface. Then click the "add File (F)" button to select and add the file.

You can use this driver the next time you establish an Oracle database connection.

After you create a new connection, you can access the corresponding database through these connections, view and edit the objects in the database, execute SQL statements, and complete various management and development tasks.

Generate ER diagram

Finally, I'll show you how to generate ER diagrams of database objects. Click the Project view next to Database Navigation on the left side of the window.

There is a "ER Diagrams", which is the entity relationship diagram. Right-click the option and click "create a new ER diagram".

Enter a name and select the database connection and the objects to be displayed, and then click "finish" to generate the corresponding ER diagram.

ER diagrams can be typesetting and display settings, and can also be printed as pictures. DBeaver currently does not support creating ER diagrams on its own, but can only generate them from existing databases.

Thank you for reading! This is the end of this article on "how to download and install DBeaver". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.