G'day

With this blog, I aim to create a tutorial on designing a relational database for storing horse racing data.

I will be using open source software for the database and also Python to connect to the database and manipulate the data. I will explain basic SQL, and how to write scripts in Python to extract data from free websites to populate your database.

As there's no point in storing the data unless you are going to use it, I will also show you how to run queries to generate reports or test system ideas.

I hope it will be of some interest and useful. Even if you are not a programmer and have no wish to learn, I think knowing what is possible should be helpful if you employ a coder to write your software for you.

Cheers