[introduction] dbaver is a cross platform database tool with friendly interface. It supports topic setting, keyword highlighting, exporting ER diagrams, supporting multiple databases, and the enterprise version supports NoSQL databases.
Do you use different client tools for database use in your daily development work? Oracle using sqldeveloper? MySQL uses Navicat? Redis uses another redismanager? Or struggling to find tools to crack? Imagine if there is a client that can support multiple databases at the same time, and has a very easy-to-use and cool interface. The key is open source and free. Will it arouse your curiosity? In this way, dbeaver successfully attracted my attention.
Dbaver is a free and open source database tool, which supports a variety of different databases, including community version (free) and enterprise version (paid). The connection of the community version is based on JDBC, that is, it supports all databases driven by JDBC, such as mysql, Oracle, etc. in addition to the function of the community version, the enterprise version also supports a variety of NoSQL databases, such as mongodb, redis, etc.
The address of this open source project is:
My personal actual trial experience is very good, with convenient operation and friendly interface.
Download and install
The download address is:
The source address is:
I chose the windows platform to download the community version zip package. The version is 7.2.3, which can be used after decompression. The following introduction is based on this and uses MySQL as the target database for full-text demonstration. After decompression, double-click dbeaver.exe to use it. Here, I will only introduce some functions of dbaver that I think are commonly used and that other tools are not easy to use or do not have. I will not introduce the conventional functions such as editing SQL statements and CRUD operations.
(however, in actual use, the SQL prompt function of dbeaver is more friendly. It will automatically help you set up table aliases, etc., and supports SQL statement formatting. It is recommended to try it yourself. There is no detailed introduction here.)
At present, dbeaver does not support many types of topics, but there are already dark topics that programmers like very much. The style of the interface is very similar to that of jetbrain’s development tools. As a developer, I feel very cordial.
The place to set the theme is in the window – preferences – General – Appearance:
Connect to MySQL
The process of connecting to MySQL and common database tools, input IP, database name, user name and password, and test.
If you are connecting to a database for the first time, there will be a process of downloading the jdbc driver package, which is automatic, but you need to wait for a while. After creation, you can officially use the function of dbaver.
BLOB field display
Dbeaver supports the display of binary data in hex or Base64 encoding in the query result window, and can also be exported, which provides great convenience. In actual development, binary data stored in the database usually needs hex or Base64 coding in network transmission. If we directly query the database, we need to copy and save the binary data of the query results, and then manually convert them to hex or Base64 coding. With dbeaver, binary data can be encoded for display and export.
BLOB field conversion
Select data row – right click – display / format – binaryformat string / hex / Base64. You can select hex or Base64 encoding.
BLOB field export
When exporting a BLOB field, you can choose not to export the field, export it to a file, or export it in hex or Base64 encoding. Take exporting CSV files as an example.
Export BLOB field is empty
Select data row – right click – export result set
Export to file
Export as Base64 encoding
Export as hex encoding
Export ER diagram
Dbeaver supports exporting Er graphs. Usually, when we develop a new system, we often modify the database, and there will be some adjustments in the iterative development process, resulting in that the database table structure and fields may be different from the original design. Naturally, the ER diagram is constantly updated and changing, and dbeaver supports exporting the ER diagram. No matter how the database changes, we only need to export it with one click to generate the ER diagram, Is it convenient to generate design documents?
It is also very simple for dbaver to generate ER diagram. For dual machine target database, a new tab will be created in the right window to display the database table and generate ER diagram options.
Export ER diagram. Note the position of the Export button in the following figure:
Export the generated graph like this, isn’t it convenient?
Select the database or table to compare, and then click database – > compare / migrate – > Simple compare on the toolbar. Click compare according to your needs. The comparison results can be saved as a file or directly open the browser display page.
Dbaver also supports database monitoring, which is a very useful function in both online and development environments. The method to open the monitoring panel is also very simple. Select database – right click – tools – Open dashboard. The monitoring contents include database traffic, data reading and writing, number of data queries, number of sessions, etc. (different databases have different monitoring contents. Take MySQL as an example)
As like as two peas or Eclipse plug-ins, DBeaver can also support plug-in extensions, which can be downloaded from plug-in market to DBeaver. The operation methods and procedures are exactly the same as those of Eclipse and IDEA, and the seamless connection is not carried out in detail here.
Open source outpostShare popular, interesting and practical open source projects on a daily basis. Participate in maintaining the open source technology resource library of 100000 + star, including python, Java, C / C + +, go, JS, CSS, node.js, PHP,. Net, etc.