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

This article mainly introduces what DBeaver is, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

For many developers, Navicat is no stranger to this software. I believe that this iridescent icon software can effectively help you with your development work. In the past, when I was at school, I used to crack with keys I found on the Internet, but I was always looking for a free tool to replace Navicat. Therefore, we recommend a perfect alternative tool-DBeaver (Github open source).

DBeaver official website introduction is a free multi-platform database tool for developers, database administrators, analysts and all those who need to use the database. Support for all popular databases: MySQL,PostgreSQL,SQLite,Oracle,DB2,SQL Server,Sybase,MS Access,Teradata,Firebird,Apache Hive,Phoenix,Presto, etc.

Characteristics

Developed in Java, supporting cross-platform operation.

UI is eclipse style, which is very pleasing to me when I used eclipse as a learning development tool when I was a student.

Based on the open source framework, support for writing a variety of plug-ins.

Based on Java development, that is to say, DBeaver supports all the databases that Java can link to. At the same time, it can handle any external data source that may or may not have a JDBC driver.

Support for data import / export, generation of ER diagrams, and support for simulation data generation is very powerful for development tests.

Support database comparison, generate comparison report directly in the browser, field name, length inconsistency and other information at a glance.

Function

1. Support multiple database links

All the databases listed in the above figure can be linked by DBeaver, although the enterprise paid version also supports links to some non-relational databases.

There is no driver to open the software for the first time, so we need to download the connection driver ourselves.

First configure Ali's maven download address. Window > > preferences > > DBeaver > > driver > > maven > > add, directly add the warehouse.

ID: alimaven name: maven.aliyun.comURL: http://maven.aliyun.com/nexus/content/groups/public/

Then the menu: database > driver Manager

Find the corresponding connection type, click Edit, and then select download / Update in the pop-up window to download the corresponding driver file.

Then you can create a new connection to the linked database from the menu "Database".

two。 Data visualization

One-click switch between data table properties and data, database read and write monitoring, CRUD monitoring.

3.SQL editing area

Support SQL syntax highlighting (prompt based on different databases)

Field, table name prompt, automatically name datasheet alias.

The data area supports direct filtering and sorting, etc.

4.ER diagram generation

5. Database comparison

You can choose to browse or save to a local file

Thank you for reading this article carefully. I hope the article "what is DBeaver" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.