Novice in the development of their own blog How to design a database, file classification, to teach experience.

When I started blogging, I found that I couldn't get a hand, the file didn't know how to classify it, and I didn't know how to organize the code.
I hope the technical cow can point out, thank you:)

Reply content:

When I started blogging, I found that I couldn't get a hand, the file didn't know how to classify it, and I didn't know how to organize the code.
I hope the technical cow can point out, thank you:)

Give you one of the simplest designs, two tables, Article table post and classification table category.
One of the articles can only belong to one category, one category, no hierarchy between categories

Post

• ID INT (10) Self-increment primary key

• Title varchar (100)

• Content text

• category_id Int (10) Category ID

• Create_time Int (10) Creation time, Unix timestamp

• Modify_time Int (10)

Category

• ID INT (10) Self-increment primary key

• Title varchar (100)

• Create_time Int (10)

After how to expand their own ways (such as classification to multi-level, the article can support multiple categories, add user support, add article status, etc.)

is plain html not better? An article a file.

Build a page directly on GitHub, then markdown write the article, git push release. As a programmer, such a blog you deserve to have!

Finally, post my own https://lloydzhou.github.io.

