If you decide to view the code, you will see that query parameters are listed as "REDACTED." If you would like infomation about the database design and architecture, please reach out to me for additional details.
This was one of my very first projects that I developed independently back in 2021 (I was 16 when I worte this lol). I developed this site to allow athletes from my high school to track their cross country and track performances and progress.
Users can search for individual athlete profiles, rank athletes based on event, class, and or season. They can also search for race results from different competitions and view custom articles. Additionally, there is a page for users to view current and future weather conditions. What makes this different from traditional weather forecasts is that I developed a "Run Index" which is a score out of 5 on how optimal it is to run. I tried to be as objective as possible with setting this metric up based on extensive research each athlete will always have their own preferences. I am thinking of implemented a large language model to gauge user preferences and generate a dynamic score based on user desires.
This site is written with HTML/CSS/JS and PHP. The entire site is powered by a Linux, Apache, MySQL, PHP (LAMP) software bundle on a Google Cloud Server running on Ubuntu. All athlete data and race performances are stored in a relational database that I configured using the phpMyAdmin interface. I scraped all the race result data with a custom Python script I wrote to automatically collect the data and push it to the database.
I am in the works of developing a full scale database platform to serve athlete data to high school and collegiate runners across the country. I want to leverage large language models (LLMs) to help provide guidance and prediction to athletes. This current site has not been attended to in a while and so it is not up to date and the code style and format deserves some much needed attention! 😅 Stay tuned....