• git clone the file
• Install dependencies with npm i
• Create database with npm run db:create
• migrate tables with npm run migrate
• Then run node server.js

• JavaScript
• node.js
• Frameworks hapi.js & handlebars.js with CI (Continuos Integration technique)

For the things we have to learn before we can do them, we learn by doing them. ~Aristotle

For a user looking for a blog design with CMS.

• I want a blog where I can add, edit and publish my own writings.
• I want a blog where I can have my dashboard as the admin and where I can control my posts and other guest users comments.
• The blog should have a home page where guest users can see my latest posts.

• tbl_user stores the user information, including username and password.
• tbl_post stores the blog post information. It mainly consists of the following columns:
• title: required, title of the post;
• content: required, body content of the post.
• tbl_comment stores the post comment information. Each comment is associated with a post and mainly consists of the following columns:
  • author: required, the author name;
  • email: required, the author email;
  • url: optional, the author website URL;
  • content: required, the comment content in plain text format.

• Files structure
• Code structure

Following the TDD approach, test cases were conducted to make sure back-end, front-end, database functionality is authentic and easily maintained.