Windows Install

In general, the steps for installing nfldb in Windows are the same as instructions detailed here with a few exceptions.

1. Trying to pip install nfldb will fail because installing dependency psycopg2 fails
2. Manually install pyscopg from http://www.lfd.uci.edu/~gohlke/pythonlibs/#psycopg
3. Now we can pip install nfldb (or pip install --upgrade nfldb)
4. Download and install PostgreSQL from http://www.enterprisedb.com/postgresql-930-installers-win32?ls=Crossover&type=Crossover
   • Will be prompted to create a password for user postgres as part of install process
   • Once complete, navigate to "C:\Program Files (x86)\PostgreSQL\9.3\bin" which will be our working directory for next few steps
5. Create a new user

   C:\Program Files (x86)\PostgreSQL\9.3\bin>createuser.exe -U postgres -E -P nfldb
   Enter password for new role:
   Enter it again:
   Password:
   

6. Create a new db

   C:\Program Files (x86)\PostgreSQL\9.3\bin>createdb.exe -U postgres -O nfldb nfldb
   Password:
   

7. Enable fuzzystrmatch

   C:\Program Files (x86)\PostgreSQL\9.3\bin>psql.exe -U postgres -c "CREATE EXTENSION fuzzystrmatch;" nfldb
   Password for user postgres:
   CREATE EXTENSION
   

8. Login and connect to nfldb

   C:\Program Files (x86)\PostgreSQL\9.3\bin>psql.exe -U nfldb nfldb
   Password for user nfldb:
   psql (9.3.0)
   WARNING: Console code page (437) differs from Windows code page (1252)
            8-bit characters might not work correctly. See psql reference
            page "Notes for Windows users" for details.
   Type "help" for help.
   
   nfldb=> 
   

9. Download and unzip zip file of the SQL to create the database from http://burntsushi.net/stuff/nfldb/nfldb.sql.zip
10. Import the database (on old Q9300 @ 2.5GHz, 4GB this took just under 6 minutes)

    C:\Program Files (x86)\PostgreSQL\9.3\bin>psql.exe -U nfldb nfldb < c:\Users\Ben\Downloads\nfldb.sql\nfldb.sql
    Password for user nfldb: xxxxxx
    

11. Copy c:\Python27\share\nfldb\config.ini.sample to config.ini
12. Update nfldb config file with your nfldb password and timezone
13. Create and save a file called top-ten-qbs.py

    import nfldb
    
    db = nfldb.connect()
    q = nfldb.Query(db)
    
    q.game(season_year=2012, season_type='Regular')
    for pp in q.sort('passing_yds').limit(10).as_aggregate():
        print pp.player, pp.passing_yds

14. run python top-ten-qbs.py

    C:\Python27\Scripts>python "P:\Projects\Home Computer\Fantasy Football\nfldb\top-ten-qbs.py"
    Drew Brees (NO, QB) 5177
    Matthew Stafford (DET, QB) 4965
    Tony Romo (DAL, QB) 4903
    Tom Brady (NE, QB) 4799
    Matt Ryan (ATL, QB) 4719
    Peyton Manning (DEN, QB) 4667
    Andrew Luck (IND, QB) 4374
    Aaron Rodgers (GB, QB) 4303
    Josh Freeman (TB, QB) 4065
    Carson Palmer (ARI, QB) 4018
    

15. Finally, try running the nfldb-update script

    C:\Python27\Scripts>python nfldb-update
    -------------------------------------------------------------------------------
    STARTING NFLDB UPDATE AT 2013-09-23 11:40:49.144000
    Connecting to nfldb... done.
    Setting timezone to UTC... done.
    Updating player JSON database... (last update was 2013-09-22 14:48:38.196084+00:
    00)
    Loading games for REG 2013 week 3
    Downloading team rosters...
    32/32 complete. (100.00%)
    Done!
    done.
    Locking player table...
    Updating 5285 players... done.
    Locking write access to tables... done.
    Updating season phase, year and week... done.
    Bulk inserting data for 1 games...
            Sending batch of data to database...
    done.
    Closing database connection... done.
    FINISHED NFLDB UPDATE AT 2013-09-23 11:41:23.256000
    -------------------------------------------------------------------------------