RacingTracker

🇪🇸 Docs · Report issue

ℹ️ About

RacingTracker is a free and open source web application that allows you to manage races in the world of motor racing with an innovative scoring system.

Why RacingTracker?

In motor racing, the predominant scoring system is based exclusively on the final position of the participants. This traditional approach assigns fixed scores to each position without considering key factors such as relative performance, prior expectations or the particular conditions of each driver or team. As a result, the current system has two main shortcomings:

1. Lack of recognition of relative performance: A driver or team with limited resources who achieves a modest result could be performing at an exceptional level based on their capabilities, but the system does not reflect this merit.

2. Little appreciation for exceeding expectations: A pilot from a leading team who finishes in a high position simply meets expectations, without receiving additional recognition if his performance exceeds initial projections.

These limitations raise a fundamental question: is a scoring system that only considers final position without assessing context and relative performance really equitable? The answer, from my perspective, is no. I therefore propose the development of a fairer and more dynamic ranking system, capable of more accurately reflecting the true merit of each driver and team.

📁 Project structure

📁 root/
|-- app/                         # Application core
|   |-- Http/
|   |   |-- Controllers          # Route controllers
|   |   |-- Middleware           # HTTP middleware
|   |   \-- Requests             # Form request validation
|   |-- Models                   # Eloquent models
|   \-- Providers                # Service providers
|
|-- database/                    # Database files
|   |-- factories                # Model factories for seeding
|   |-- migrations               # Database schema migrations
|   |-- seeders                  # Database seeders
|   \-- database.sqlite          # SQLite database
|
|-- documents/                   # Project documentation
|   |-- resources                # Images, diagrams, etc.
|   \-- memoria.docx             # Project document
|
|-- public/                      # Publicly accessible files
|
|-- resources/                   # Frontend resources
|   |-- css                      # CSS styles
|   |-- js/                      # TypeScript frontend code
|   |   |-- components           # Reusable components
|   |   |-- hooks                # Custom React hooks
|   |   |-- layouts              # Layout components
|   |   |-- lib                  # Utility functions
|   |   |-- pages                # Page-level components
|   |   \-- types                # TypeScript types/interfaces
|   \-- views                    # Blade views
|
\-- routes/                      # Route definitions

📊 Points calculation

Variables

• β: performance deviation (μ/6.0)
• μ: current driver points (25.0)
• τ: dynamic factor of change (μ/300.0)
• σ: current driver uncertainty (μ/3.0)
• A: expected average position
• F: final position in the race
• P: number of race participants

Operations

Performance deviation:

$β=μ/6.0$

Dynamic factor of change:

$τ=μ/300.0$

Combined variance of performance:

$C=σ^2+β^2$

Updating factor:

$K=σ^2/C$

Error between expected and actual position:

$E=A-F$

Updating μ:

$μ_{new}=μ+KE$

Impact of error in σ:

$I=∣E∣/P$

Proposed change in σ:

$σ_{change}=τ(0.5−I)$

σ maximum change limit (15%):

$M_{change}=σ(0.15)$

Application of limits to σ change if $σ_{change}>0$:

$σ_{change}=min⁡(σ_{change}, M_{change})$

Application of limits to σ change if $σ_{change}<0$:

$σ_{change}=max⁡(σ_{change}, -M_{change})$

σ update (with minimum 0.001):

$σ_{new}=max⁡(0.001, σ+σ_{change})$

🚀 Deployment locally

Prerequisites

• PHP ^8.2
• Node.js ^22.14
• Composer ^2.8

Installation

1. Clone the repository:

git clone https://github.com/Qv1ko/RacingTracker.git

2. Change the working directory:

cd RacingTracker

3. Install the dependencies:

composer install && npm install

4. Copy the .env.example file to .env:

cp .env.example .env

5. Generate the application key:

php artisan key:generate

6. Run the migrations:

php artisan migrate

7. Run the seeders:

php artisan db:seed

8. Run the server:

npm run build && php artisan serve

9. Open http://localhost:8000 in your browser.

☁️ Deployment on AWS

Prerequisites

• AWS account
• Fork the RacingTracker repository

Installation

Create the AWS infrastructure

1. Create a new VPC in AWS.

2. Create a new EC2 instance in AWS:

   • Select Ubuntu OS
   • Create a new key pair
   • Select the VPC you created in the previous step in the network settings
   • Select the public subnet in the network settings
   • Enable the auto-assign public IP option in the network settings
   • Create two new security groups rules:
     • Type: HTTP (80), Source type: Anywhere
     • Type: HTTPS (443), Source type: Anywhere

3. Edit key pair permissions in your local machine:

sudo chmod 0600 "path/to/your/key.pem"

Prepare Ubuntu

1. Connect with SSH to the EC2 instance:

ssh -i "path/to/your/key.pem" ubuntu@ec2-public-ip-address`

2. Update the system:

sudo apt update && sudo apt upgrade -y

3. Reboot the instance in AWS.

4. Install the necessary packages:

sudo apt install nginx -y && sudo add-apt-repository ppa:ondrej/php -y && sudo apt install -y php8.2-fpm php8.2-curl php8.2-xml php8.2-mbstring php8.2-zip php8.2-mysql php8.2-sqlite3 php8.2-redis zip unzip && sudo curl -sS https://getcomposer.org/installer | php && sudo mv ~/composer.phar /usr/local/bin/composer && curl -fsSL https://deb.nodesource.com/setup_22.x | sudo -E bash - && sudo apt install nodejs -y && composer --version && node -v && npm -v

5. Create a new user to make deployment more secure:

sudo adduser deploy-user

6. Access the new user home directory:

sudo su deploy-user && cd ~

7. Generate GitHub ssh keys for the new user:

ssh-keygen -f /home/deploy-user/.ssh/github_rsa -t rsa

8. Create a new GitHub config file:

nano /home/deploy-user/.ssh/config

Host github.com
  IdentityFile ~/.ssh/github_rsa
  IdentitiesOnly yes

9. Change ssh directory and files permissions:

chmod 700 ~/.ssh && chmod 600 ~/.ssh/*

Application deployment

1. Add a new deploy key in the forked GitHub repository where its value will be the key github_rsa.pub:

cat ~/.ssh/github_rsa.pub

2. Clone the forked repository:

git clone [email protected]:your-username/RacingTracker.git code && cd code

3. Install the dependencies:

composer install && npm install

4. Copy the .env.example file to .env:

cp .env.example .env

5. Generate the application key:

php artisan key:generate

6. Run the migrations:

php artisan migrate

7. Run the seeders:

php artisan db:seed

8. Build the frontend:

npm run build

9. Remove default file in sites-enabled:

exit

sudo rm /etc/nginx/sites-enabled/default

10. Create a config file in sites-available:

sudo nano /etc/nginx/sites-available/racingtracker.conf

server {
    listen 80 default_server;
    listen [::]:80 default_server;
    server_name _;
    root /home/deploy-user/code/public; # Change deploy-user to your username
    index index.html index.htm index.php;

    charset utf-8;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        fastcgi_pass unix:/var/run/php/php8.2-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
        include fastcgi_params;
    }

    location ~ /\.(?!well-known).* {
        deny all;
    }
}

11. Create a symlink to the config file in sites-enabled:

sudo ln -s /etc/nginx/sites-available/racingtracker.conf /etc/nginx/sites-enabled/

12. Test if the configuration is correct:

sudo nginx -t

13. Reload the nginx service:

sudo service nginx reload

14. Add the nginx user in a new group with deploy-user:

sudo usermod -aG deploy-user www-data

15. Modify php-fpm pool configuration:

sudo nano /etc/php/8.2/fpm/pool.d/www.conf

; pool name ('www' here)
[deploy-user]

...

user = deploy-user
group = deploy-user

...

listen.owner = deploy-user
listen.group = deploy-user

16. Restart the php-fpm service:

sudo service php8.2-fpm restart

17. You can now access the application at http://ec2-public-ip-address.

Installing a self-signed SSL/TLS certificate

1. Install the necessary dependencies:

sudo apt install openssl -y

2. Create a new directory for the SSL/TLS certificate:

sudo su deploy-user

mkdir ~/.ssl && cd ~/.ssl

3. Create a config file in a new directory:

nano san.cnf

[req]
default_bits       = 2048
prompt             = no
default_md         = sha256
req_extensions     = req_ext
distinguished_name = dn

[dn]
C  = # Country
ST = # State
L  = # Locality
O  = # Organization
OU = # Organizational Unit
CN = XX.XX.XX.XX # EC2 instance public IP address

[req_ext]
subjectAltName = @alt_names

[alt_names]
IP.1 = XX.XX.XX.XX # EC2 instance public IP address

4. Generate a RSA key pair:

openssl genrsa -out server.key 2048

5. Generate the certificate signing request (CSR):

openssl req -x509 -nodes -newkey rsa:2048 \
  -keyout server.key \
  -out server.crt \
  -days 365 \
  -subj "/CN=XX.XX.XX.XX"

6. Edit nginx configuration file:

exit

sudo nano /etc/nginx/sites-available/racingtracker.conf

server {
    listen 80 default_server;
    listen [::]:80 default_server;
    listen 443 ssl;
    server_name XX.XX.XX.XX; # EC2 instance public IP address
    root /home/deploy-user/code/public; # Change deploy-user to your username
    index index.html index.htm index.php;

    ssl_certificate     /home/deploy-user/.ssl/server.crt; # Change deploy-user to your username
    ssl_certificate_key /home/deploy-user/.ssl/server.key; # Change deploy-user to your username

    # Redirect HTTP to HTTPS
    if ($scheme != "https") {
      return 301 https://$server_name$request_uri;
    }

    charset utf-8;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~ \.php$ {
        fastcgi_pass unix:/var/run/php/php8.2-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
        include fastcgi_params;
    }

    location ~ /\.(?!well-known).* {
        deny all;
    }
}

7. Check if the configuration is correct and reload the nginx service:

sudo nginx -t && sudo systemctl reload nginx

8. You can now access the application at https://ec2-public-ip-address.

📄 License

Distributed under the MIT License. See LICENSE for more information.

📚 References

• Mr V's Garage inspiring video
• TrueSkill System
• Pitwall App