Recently, we are building wheels, from 0 to 1, which is not the interface of the front desk. You can look forward to it patiently. Some database tables need to be designed, which can be directly developed through Navicat, a graphical management tool, or through some database design tools, such as PowerDesigner, which is more professional.
Today, I recommend this open source database design tool Chiner for Chinese people. It has a beautiful interface and powerful functions. After experiencing it, I feel really fragrant
1、 About PowerDesigner
PowerDesigner is a very powerful modeling tool, which can be comparable to rational rose. Rose specializes in modeling UML object models before expanding to databases. PowerDesigner served for database modeling at the beginning, and later developed into a modeling tool with good comprehensive combat effectiveness.
However, to be honest, the interface of PowerDesigner is more classical. Here is the effect of designing dB with PowerDesigner.
2、 About Chiner
Chiner, pronunciation: [ka ɪˈ n ə r] , a meta modeling platform built using react + electron + Java technology system.
In 2018, the author and several community friends who are interested in open source began to polish the reasons for the product. After three generations, the new version 3.0 of ship was finally launched in July 2021.
At the end of 2019, the team was almost disbanded. Fortunately, several friends took care of it and gave the team two projects to do. This was the past.
It has to be said that it is not easy to do anything. Feelings alone may be able to survive the initial stage of the product, but the more you go back, it will be very difficult to survive.
Here, we must give the most sincere applause to every open source Author and hope that their products can have a world. I also hope that when my product appears in front of you in the future, I can give it a little more tolerance and support.
3、 Chiner installation
Chiner supports windows, MacOS and Linux. The download address is as follows:
The code cloud intercepts external links, resulting in direct copying of links to the address bar to complete the download. Let me take MacOS as an example.
This is what it looks like to open it for the first time after installation.
Chiner provides a very considerate operation manual and reference template. If you have enough time, you can go through the operation manual first and write it in great detail.
4、 Master
01. Import and export
Because I have a PowerDesigner file before, I can import it directly into Chiner.
The first step is to create a new project codingmore.
Step 2: select import PowerDesigner file.
Step 3: select the data table to add.
Step 4: after importing, you can click the billing table to view it.
Step 5: after the redesign, you can choose to export DDL to the database table.
Of course, you can also directly configure the database db so that you can directly connect to import and export.
The exported SQL file can be directly uploaded to the server through the pagoda panel, and then directly imported into the database.
If you need to use database description documents, you can also export them directly to word documents.
02. Maintenance data type
Chiner comes with several common data types, such as string, decimal, date, etc. we can also add new data types according to our own needs.
For example, the default string type is associated with other database types as follows:
A data field is a data type defined by the current project with certain business meaning based on the data type. For example, I maintain a name data field with a length of 90.
When I need to set the data field of a data field to “name”, the length will be automatically filled in as 90, and there is no need to set it manually.
03. Maintenance data sheet
Step 1: select a data table and right-click to select “add data table”
Step 2: fill in the data table name
After clicking “OK”, Chiner will automatically generate some common fields for us, such as creator, creation time, updater, update time, etc., which is very intelligent. Generally speaking, these fields are required.
If these default fields do not meet the requirements, you can also click “Settings” to add default fields, such as delete flag. Generally speaking, for security reasons, the database will adopt non physical deletion.
Generally speaking, we are more used to naming fields in lowercase, so we can directly select a column and then select case conversion.
It becomes lowercase.
04. Maintenance diagram
Step 1: select diagram and right-click to select new diagram
The second step is to drag the table to be associated to the right panel, and then connect according to the fields, which is very convenient. For example, the relationship between class and college table, class and major table is shown in the figure below.
Let’s take a look at the overall diagram, which is very refreshing.
5、 Epilogue
Chiner has more and more powerful functions. If you think it’s good, you can try it. If you use it skillfully, you can certainly improve the production efficiency to a great extent.
In terms of my personal experience, Chiner is lighter than PowerDesigner and more in line with daily operation habits. I like domestic and open source!
Project address:
Instruction manual:
This article has been included in the open source column “the way for Java programmers to advance” of star 1.3k + star on GitHub. The column is humorous, easy to understand and extremely friendly and comfortable for java lovers. The content includes but is not limited to core knowledge points such as Java foundation, Java collection framework, Java IO, Java Concurrent Programming, Java virtual machine, Java enterprise development (GIT, SSM, spring boot), etc。
Star has become a better java programmer by building this warehouse. You can click the link below to jump to the past star to witness this exciting moment.
Promise the editorial teacher of the publishing house that if the number of stars exceeds 10000, I will write this column into a book. Hahaha, I’m talking. Next, I’ll look at the partners. The decision whether to publish the book or not is up to you. I’ll be responsible for handing over the liver, hahaha
I am the second king of silence. Nothing makes me stay – except for the purpose. Even if there are roses, shade and quiet harbor on the shore, I am not a boat。