Home

HKUgram Wiki

HKUgram is a COMP3278 course project for a relational-database-backed social media platform. The system supports account registration, login, image posting, likes, comments, follow relationships, browsing history, notifications, analytics, full-text search, a read-only SQL query interface, and an approval-based AI discovery agent.

Project Snapshot

• Frontend: React + Vite
• Backend: FastAPI + SQLAlchemy
• Database: MySQL
• Deployment: Docker Compose
• License: GNU GPL v3.0

Quick Links

• Project Overview
• Architecture
• Database Design
• API Reference
• Run and Deploy
• Features
• License

Demo Services

Development defaults from the repository:

• Frontend: http://127.0.0.1:5173
• Backend API: http://127.0.0.1:8000
• MySQL: 127.0.0.1:3306
• Adminer: http://127.0.0.1:8080

Highlights

• Social feed with recent and popular sorting
• Profile pages with follow and follower statistics
• Image upload posts with category and caption
• Likes, comments, browsing history, and notifications
• Analytics dashboard for top posts and active users
• Search comparison between SQL-based approaches
• Approval-gated AI-assisted query and recommendation flow

Repository

Main repository: https://github.com/BYLinMou/COMP3278-Gp10