Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Time:2022-5-24

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

Kill PowerDesigner! This Chinese open source database design tool is 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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

3、 Chiner installation

Chiner supports windows, MacOS and Linux. The download address is as follows:

https://gitee.com/robergroup/chiner/releases

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

This is what it looks like to open it for the first time after installation.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Step 3: select the data table to add.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Step 4: after importing, you can click the billing table to view it.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Step 5: after the redesign, you can choose to export DDL to the database table.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Of course, you can also directly configure the database db so that you can directly connect to import and export.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

The exported SQL file can be directly uploaded to the server through the pagoda panel, and then directly imported into the database.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

If you need to use database description documents, you can also export them directly to word documents.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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:

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

03. Maintenance data sheet

Step 1: select a data table and right-click to select “add data table”

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Step 2: fill in the data table name

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Generally speaking, we are more used to naming fields in lowercase, so we can directly select a column and then select case conversion.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

It becomes lowercase.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

Let’s take a look at the overall diagram, which is very refreshing.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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:

https://gitee.com/robergroup/chiner

Instruction manual:

https://www.yuque.com/chiner/docs/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

https://github.com/itwanger/toBeBetterJavaer

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.

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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

Kill PowerDesigner! This Chinese open source database design tool is really fragrant!

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