Blog Lite Web Application

This is a simple web application that allows users to create posts, follow other users, and interact with their posts by liking and commenting on them. The application also includes a REST API that allows external applications to access user engagement data.

Technologies Used

• Flask: web framework for building the web application
• Flask-SQLAlchemy: ORM for connecting to the database and performing CRUD operations
• Flask-RESTful: extension for building RESTful APIs
• Flask-Login: extension for user authentication and authorization
• Werkzeug for password hashing
• SQLite: database for storing user, post, and engagement data

Database Schema Design

The database used in this project is a SQLite database. The following tables were created:

• Users: Stores information about users, including their name, email, and password hash.
• Posts: Stores information about posts, including the text of the post and the user who created it.
• Comments: Stores information about comments, including the text of the comment and the user who created it.
• Likes: Stores information about likes, including the user who liked the post and the post that was liked.
• Followers: Stores information about followers, including the user who is following and the user who is being followed.

The relationships between these tables are as follows:

• Users has many Posts, Comments, and Likes
• Posts has many Comments and Likes
• Comments has many Likes
• Followers has many Users

This design allows for easy retrieval of information, such as all of a user's posts or all of the comments on a particular post. Additionally, it allows for easy tracking of likes and followers for each user.

API Design

The API was designed to retrieve information about a user's engagement on the platform, such as the number of posts, comments, likes, followers, and followed users. The API includes a single endpoint that takes a user ID as a parameter and returns a JSON object containing the engagement data.

Architecture and Features

The project is organized using the Model-View-Controller (MVC) pattern. In the application package, the views module contains the controllers for handling requests and rendering templates. The authentication module contains the controllers for handling user authentication and authorization. The models module contains the classes for the database tables. The templates folder contains the HTML templates for the views.