Raceform Database

The original dataset is Horse Racing results - UK/Ireland 1988-2026 in Kaggle.

Environment variables

Before building your dev container, copy .devcontainer/.env.example to .devcontainer/.env and edit it to your liking..

Environment Variable	Description
COMPOSE_USER_ID	the UID of your OS account invoking docker compose command
COMPOSE_GROUP_ID	the GID of the account above
POSTGRES_USER	the name of the database owner
POSTGRES_PASSWORD	the password of the database owner
POSTGRES_DB	the name of the database to build
ANALYST_PASSWORD	the password of the database user analyst, which will be used by read-only database applications

How to build the importing program

In the dev container, invoke the following command.

gradle clean build

How to import the dataset

1. Place the original dataset file in CSV format here, named raceform.csv.

2. Import the file to the staging table.

   psql -f import-to-staging.sql

3. Run the importing program.

   java -jar build/libs/raceform-database.jar

Copyright notice

This program is licensed under the Apache License Version 2.0.