The sportdb command line tool now includes a new quick starter template command to (auto-)download Datafile scripts from the new openfootball/datafile registry.

For example, to build yourself a copy of the worldcup2014.db type:

$ sportdb new worldcup2014

The new command will run these steps:

  • Step 1: Download worldcup2014.rb Datafile (from GitHub) to your working folder as ./Datafile
  • Step 2: Run the sportdb build command
    • Step 2.a: Download all datasets listed in the Datafile as zip archives (from GitHub) to ./tmp
    • Step 2.b: Create the “empty” database, that is, table structure, indexes, etc. (schema)
    • Step 2.c: Read in all datasets from the zip archives in ./tmp (no need to unpack)

That’s it. All done and setup with a single command. Still early and rough.

PS: The first quick starter Datafile templates include:

  • worldcup => All World Cups 1930-2014
  • en => English Premier Leagues
  • en2014-15 => English Premier League 2014/15
  • cl2014-15 => (European) Champions League 2014/15