Recently we are building the wheel, from 0 to 1, the only thing missing is the foreground interface, you can wait for patience. You need to design some database tables. You can use Navicat, a graphical management tool, or you can use some database design tools, such as PowerDesigner, which is more professional.

Today I recommend the Chinese open source database design tool chiner, beautiful interface, powerful function, experience to my feeling is really sweet……

I. About PowerDesigner

PowerDesigner is a very powerful modeling tool, comparable to Rational Rose. Rose specialized in modeling UML object models before branching out into databases. PowerDesigner, on the other hand, started out as a database modeling tool, and later developed into a fairly comprehensive modeling tool.

However, to be honest, the PowerDesigner interface is a bit more classical. Here is what I did with the PowerDesigner DB.

Ii. About Chiner

Chiner is a nion modeling platform built using React+Electron+Java technology. Chiner is a nion modeling platform built using React+Electron+Java technology.

In 2018, the author and several friends in the community who are interested in open source began to polish the reasons for the product. After three generations, the new version 3.0 was finally released in July 2021.

At the end of 2019, the team was almost disbanded, but fortunately, some friends gave the team two projects to do, which finally made it through.

I have to say that it is not easy to do anything. Feelings alone may survive the initial stage of the product, but the further you go, it will be very difficult to survive.

Here, we must give our sincere applause to every open source author and hope that their products can make a difference. I also hope that when my product appears in front of everyone in the future, I can give it a little more tolerance and support.

Three, install chiner

Chiner supports Windows, macOS and Linux. Download from:

Gitee.com/robergroup/…

The code cloud did the blocking of external links, resulting in direct copy of the link to the address bar to complete the download. I’ll use macOS as an example.

This is what it looks like when it’s first opened after installation.

Chiner provides a very considerate operation manual and reference template. If you have enough time, you can first go over the operation manual and write it in detail.

Four, start the chiner

01. Import and export

Because I had a PowerDesigner file before, I could import it directly into Chiner.

First, create a new project, CodingMore.

Second, choose to import the PowerDesigner file.

Third, select the data table to add.

Step 4, after the import is complete, you can click open the table to view.

Fifth, when the redesign is complete, you have the option to export the DDL to the database tables.

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

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

If you need a database documentation, you can export it directly to a Word document.

02. Maintain data types

Chiner comes with several common data types, such as strings, decimals, dates, etc. We can also add new data types according to our own needs.

For example, the default string type associated with other database types looks like this:

A data field is a data type that has some business meaning based on the data type defined by the current project. For example, HERE I maintain a data field with a name of length 90.

When I need to set the data field of a data field to “name”, the length is automatically filled to 90 and I don’t need to manually set it.

03. Maintain data sheets

First step, select the data table, right-click and select “New Data Table”

Second, fill in the data table name

After clicking “OK”, Chiner will help us automatically generate some commonly used fields, such as creator, creation time, update person, update time, etc., very intelligent. In general, 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 marks, generally speaking, for security, database will use non-physical delete.

In general, we prefer to name fields in lower case, so you can simply select a column and then select case conversion.

It becomes lowercase.

Maintain the relationship diagram

First step, select “Diagram”, right-click “New Diagram”

The second step is to drag the table to be associated to the right of the panel, and then according to the field line, very convenient. For example, the class and college table, class and major table, as shown below.

Take a look at the overall given diagram, or very refreshing.

Five, the end

Chiner also has more powerful functions, if you feel good, you can try it. If it is used skillfully, it can certainly improve production efficiency to a great extent.

From my personal experience, Chiner is more lightweight than PowerDesigner, and more in line with daily operation habits. I like it for domestic open source!

Project Address:

Gitee.com/robergroup/…

User Manual:

www.yuque.com/chiner/docs…

This post has been adapted to GitHub’s 1.3K + Star open source column “The Path to Java Programmer Advancement”. This column is humorous, easy to understand, and extremely friendly and comfortable for Java enthusiasts 😄, The content includes but is not limited to Java foundation, Java Collection framework, Java IO, Java concurrent programming, Java virtual machine, Java enterprise development (Git, SSM, Spring Boot) and other core knowledge points.

Star the repository to become a better Java programmer. You can click the link below to jump to star and witness this exciting moment.

Github.com/itwanger/to…

Promise publishing house editor teacher, if the number of star more than 10,000 will write this column into a book, ha ha ha 😆, I am mouth hi, the next to see friends, not out of the book decision to everyone, I will be responsible for the liver handed out, ha ha ha

I am the King of Silence, with nothing to hold me but purpose, and though there be roses by the shore, and trees by the shore, and still harbours, I am unmoored.