Baza podataka i web-aplikacija za šah

undergraduate thesis

• Title (english): Database and Web Application for Chess
• Author: Roko Spahija
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Marina Ptiček (član povjerenstva)
• Committee member: Danijel Mlinarić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2020-07-06, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing

Abstract

Zadatak ovog završnog rada je izrada baze podataka i web aplikacije za šah. U bazi podataka se pohranjuju podaci o odigranim partijama, otvaranjima, vremenskim ograničenjima, korisnicima, te ostali podaci koje je potrebno pohraniti. Web aplikacija kroz korisničko sučelje omogućuje korisniku jednostavan pregled, unos, brisanje i izmjenu podataka. Sustav obrađuje poslane podatke od strane korisniškog sučelja, te ih nakon potrebne validacije sprema u bazu podataka. Također, kada korisničke sučelje zatraži pojedine podatke sustav ih dohvaća iz baze i šalje ih u prikladnom formatu. Baza podataka je izrađena koristeći PostgreSQL. Korisničko sučelje web aplikacije implementirano je koristeći tehnologije HTML, CSS, React, JavaScript, React i Socket.IO, a poslužiteljski dio aplikacije pomoću programskog jezika Java i radnog okvira Spring.

Abstract (english)

The task of this final thesis is to create a database and web application for chess. The database stores data on games played, openings, time controls, users, and other data that needs to be stored. With the help of the user interface the web application allows the user to easily view, enter, delete and modify data. Data sent by the user interface is processed by the server which then saves the data in the database after necessary validation. Also, when the user interface requests certain data, the system retrieves it from the database and sends it in a suitable format. The database was created using PostgreSQL. The user interface of the web application is implemented using the technologies HTML, CSS, React, JavaScript, React and Socket.IO, while the server part of the application was implemented using the Java programming language and Spring framework.

• Keywords: šah; baza podataka; SQL; PostgreSQL; Java; Spring; React; web aplikacija
• Keywords (english): chess; database; SQL; PostgreSQL; Java; Spring; React; web application
• Language: croatian
• URN:NBN: urn:nbn:hr:168:155365
• 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-01-13 16:07:02