Project Overview

Project Overview

HKUgram is a social media web application built for the COMP3278 course project Scenario 2. It uses a relational database as the system of record and demonstrates both normal product workflows and database-oriented query capabilities on top of the same dataset.

Core Goals

• Build a usable social media application backed by MySQL
• Demonstrate relational schema design and SQL querying
• Provide a modern frontend and API-backed workflow
• Support deployment through Docker Compose

Main User Workflows

• Register and log in to an account
• Create image posts by upload or URL
• Browse the feed with recent or popular sorting
• Like and comment on posts
• Follow other users and inspect profile pages
• Review browsing history
• Read notifications for likes, comments, and follows
• Explore analytics and database-query demos

Technology Stack

• Frontend: React, Vite, custom CSS
• Backend: FastAPI, SQLAlchemy, Pydantic
• Database: MySQL
• Supporting tools: Docker Compose, Adminer

Design Direction

The frontend follows an Art Deco visual style with dark luxury colors, gold accents, geometric framing, and strong typographic hierarchy.

Related Pages

• Architecture
• Features
• Run and Deploy