Anyone who opens this article has never used database management tools. Navicat, DataGrip and other commonly used tools, yes, they are very easy to use, Navicat small and convenient, low system resources; DataGrip interface is beautiful and compatible with IDEA, which accounts for slightly higher system resources, but the problem is that both are not free.

I recently tried a free DBeaver because so many people like it. Boy, it really works. Here strongly recommend you, interested partners can install experience a…

DBeaver profile

DBeaver is an open source database management tool with 23.3KStar on Github as of press time. Very rich database support!

When we build new connections, we can see the whole picture from this interface. In addition to the usual MySQL, Oracle, DB2, there are all kinds of databases you’ve never seen or heard of. I counted 97…

DBeaver download and install

I will not repeat this here, it is the next step, the next step, with hands oh

Dbeaver. IO/Download /

\

When you install Mysql and run IT, you can create a database connection. If you look at the interface of Mysql, the “experienced” IT will realize: Boy, this UI is exactly the same as Eclipse. DBeaver was actually developed based on Eclipse.

Operations related to database tables

  • Double-click to open a table, select the properties TAB, you can see the detailed column attributes of the table;

  • Click properties, then click DDL to view the detailed DDL statement of the table;

  • Data label, you can page view the data in the table, in the top filter box directly enter the WHERE part of the SQL statement, you can directly filter the table data;

  • Right click Add field. In DBeaver, the [v] symbol means yes and [] means no. Here try creating a primary key ID, both autoincrement;

  • Select the create constraint, and then select the ID as the primary key constraint.

SQL operations

Here’s the SQL operation in DBeaver

  • Click the drop-down button on the right of SQL in the toolbar and select THE SQL editor to open the SQL interface for operation;

  • DBeaver’s input hints are also good, including support for SQL keywords, functions, database tables, aliases, and fields;

  • If you need to create an INSERT statement for all the fields, it is difficult to write it by hand. Here you can use the DBeaver generate SQL function directly, right-click a record and select Generate SQL.

  • We can find that CRUD statements based on full fields can be almost generated, which is very convenient.

Other database support

Surprisingly, common caching DB such as MongoDB and Redis is also supported for DBeaver, but not the community version **\

  • The enterprise version only supports Redis. After creating a Redis connection, you can see the data in Redis.

  • After creating a MongoDB connection, you can also see and manipulate the data in MongoDB.

conclusion

I believe that DBeaver is indeed an excellent open source database management tool, which is convenient to use, intelligent, rich, usually fully enough to develop, and the main free.

I the headline number: profile. Zjurl. Cn/rogue/ugc/p… The home page for Fan Stark. – Today’s headlines