Show app
Appati
Club Patí Vela Barcelona · 2022
I worked side by side with a colleague on the development of a tool that helped Club Patí Vela Barcelona store and share the different leaderboards of the different competitons they have throughout the week. We developed the app for the users as well as the portal where the admins where able to upload the results.
Problem
CPVB was relying on a spreadsheet to record and share the results of the regattas, which was not very user friendly. They wished they had a more professional and reliable way of storing the data and sharing it among the sailing community.
This was one of my very first big projects and I wanted to find the best way for me to develop the project as well as doing a good job for the club.
I tried different languages and approaches to solve the problem, both for the front end and the back end. It was of great help to meet Victor, a developer with years of career on web development.
We wanted to build a functional UI for the users and a easy and intuitive way for the administrators to upload the leaderboards.
We asked the club what was the current method to record the data and we tried to mimic the workflow so the change would not be difficult to adopt.
Our solution
After having all the information we needed, we started by building the database and creating a python script in order to save all the information from the spreadsheets into the database, since there where 2 years and close to 20 competitions worth of data. When we had all the information, we developed the portal where the admins could create new competitions, upload the weekly data, create sailors and modify previous results. Once that was build, we developed a PWA with a user friendly UI to enable the sailors to check their results.