Baza podataka i web-aplikacija za praćenje turnira za kartašku igru

undergraduate thesis

• Title (english): A database and web application for monitoring card game tournaments
• Author: Viktor Mladar
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Krešimir Fertalj (član povjerenstva)
• Committee member: Mario Brčić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2023-06-28, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

U ovom radu opisan je proces izrade web aplikacije za praćenje Magic: the Gathering
turnira. Aplikacija prati lige u kojima se odvijaju turnire na kojima sudjeluju igrači sa
svojim dekovima. Cilj aplikacije je ponuditi korisnicima dati uvid o rezultatima turnira i
liga te informacije o najpopularnijim i najuspješnijim dekovima.
Aplikacija je podjeljena na tri podsustava, bazu podataka, back-end i front-end.
U bazi podataka se trajno čuvaju podatci koje pratimo. Za opis baze koristimo relacijski
model i jezik SQL za definiranje tih relacija. Sustav za upravljanje bazom kod naše
aplikacije je PostgreSQL.
Back-end prima zahtjeve od front-enda, obrađuje ih i upravlja bazom podataka. Za
implementaciju je korišten Spring Boot radni okvir s arhitekturom Controller-ServiceRepository.
Front-end prikazuje korisniku grafičko sučelje preko kojeg može upravljati podatcima u
aplikaciji. Na određenu korisnikovu akciju, poslat će zahtjev back-endu. Za
implementaciju je korištena JavaScript biblioteka React.
Za puštanje aplikacije u pogon korišten je servis Render koji besplatno nudi udaljene
poslužitelje. Za puštanje aplikacije u pogon potrebno je koristiti Docker koji radi „virtualni
konetejner“ u kojemu se aplikacija pokreće.

Abstract (english)

This thesis covers the process of developing a web application for tracking Magic: the
Gathering tournaments. The application tracks leagues in which tournaments take place, in
which players participate with their decks. The goal of this application is to give users an
insight into tournament results and league standings and provide them with information
about the most popular and most successful decks.
The application is split into three parts; database, back-end and front-end.
The data we need to track is permanently stored in the database. To create a database, we
use the relational model along with the SQL language. The database management system
for our application is PostgreSQL.
The back-end receives requests from the front-end, processes them and controls the
database. Spring Boot framework with Controller-Service-Repository architecture was
used for implementation.
The front-end presents the user with a graphical interface through which he can manage
data in the application. On a certain user action, a request will be sent to the back-end.
JavaScript library React was used for implementation.
Render, a service which provides free remote servers, was used for deployment of the
application. Docker, a virtualization service which creates a “virtual container” in which an
application is run, was also used to aid the deployment.

• Keywords: Magic the Gathering; baza podataka; web aplikacija; Spring Boot; React
• Keywords (english): Magic the Gathering; database; web application; Spring Boot; React
• Language: croatian
• URN:NBN: urn:nbn:hr:168:387072
• Study programme: Title: Computing; Study programme type: university; Study level: undergraduate; Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2023-07-13 10:22:49