SAE — BUT1 Academic project

SAE 2.3 — Game Library

Implementing a business IT solution: a full-stack web application for managing a game library, with user accounts, CRUD operations, and review system.

BUT1 — 2022/2023 Binôme (group of 2) Django / Python MySQL

Project overview

Introduction

This project required building a game library management interface using the Django framework. Users can browse games, write reviews, rate them, and manage a personal games list.

We worked as a binôme (pair) while all other groups had 3 members. My colleague handled Django and database integration, while I took care of CSS styling, virtual machine setup and Gantt planning.

Despite limited time, we delivered a fully functional project hosted on a VirtualBox VM, bridged to act as a real externally-accessible server. Only one minor feature was missing at submission.

Data schema

Database entities

Categories — id, name, description
Games — id, title, release year, cover, publisher, author, category
Authors — id, name, first name, age, photo
Players — id, name, email, password, type (pro / private)
Reviews — game, player, score, comment, date
User game list — personal list per player

Result

Game Library — interface

Final render of the game library web interface

Tech stack

Technologies used

Python

Backend logic

Django

Web framework

HTML5

Markup & templates

CSS

Styling & layout

MySQL

Relational database

VirtualBox

VM deployment

Organisation

Task distribution

Task breakdown between the two contributors

Source code

GitHub repositories

SAE23test

github.com/ZitoouN/SAE23test — project repository

TheWilli67

github.com/TheWilli67 — my GitHub profile

ZitoouN

github.com/ZitoouN — colleague's GitHub profile