-
Notifications
You must be signed in to change notification settings - Fork 264
Detailed Windows PostgreSQL installation
ochawkeye edited this page Aug 1, 2014
·
13 revisions
- Download PostgreSQL-9.3.0-1-windows.exe
- Try to run downloaded file but halted by too smart for its own good OS
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
<img src="https://cloud.githubusercontent.com/assets/2996205/3774695/3e3cf8de-1931-11e4-9c41-6b793e52a622.png" width="400px"/>
25. From a command prompt, run `python top-ten-qbs.py`
<img src="https://cloud.githubusercontent.com/assets/2996205/3774699/6cdd4ebe-1931-11e4-8c16-4472589f55bf.png" width="400px"/>
26. Finally, run the `nfldb-update` script found in the `Python\Scripts` folder
<img src="https://cloud.githubusercontent.com/assets/2996205/3774710/e0f2a312-1931-11e4-96b9-ca531a999cbb.png" width="400px"/>
27. Congratulations - no one in the world has a more up-to-date `nfldb` database than you. Time to celebrate with a beer.