DPG Media Line-up, Substitution and MOTM tool

4 years ago

My role in this project was as a Backend developer at LiveWall Group.

For this project we had to make 3 tools: the Line-up tool, the substitution tool and the Man of the match tool. And these tools would be used for all the games of Belgium and the Netherlands during the WK of 2022.

The line-up tool would be used before the games, supporters could guess or input their favorite squad in the tool. And news websites could use a widget that we developed to show the favourite line-up of the supporters.

The substitution tool would be used during the game and supporters could chose every 5 minutes three substitutes. News websites could use a widget to show which three players the supporters wanted to be substituted off.

And last the man of the match tool would be used after the game ended and supporters could chose one man of the match. News websites could use a widget to show the top man of the match of that game and the percentage of the votes that the player got.

This project was really fun, because I had to study a sport API and with cron jobs I would get data out of the API and store it into an own designed database. I also learned to minimize my SQL query length and to use indexes in my database, because on one occasion all the databases crashed. Oopsie🤦🏻‍♂️