Update PostgreSQL Database?

[skywalkrNCSU]

First, thanks for putting all of this together, I am amazed at how easy it was for me to set up the PostgreSQL database and query all the data I could want. One thing I have a question about is how can I update the database just using PostgreSQL and not python? I have a background in SQL so I prefer that for my queries and I can also directly hook it up to other software programs like data visualization tools but I would like to be able to update it on a weekly basis if possible. I looked through the documentation and only saw updating information if you were using python.

Apologies if this is a stupid question and/or this is not the right place for such an inquiry. Any help is much appreciated and thanks again for this!

[BurntSushi]

Umm... Updating is an extremely complicated process. Particularly if you want to do it efficiently. That's precisely why nfldb comes with a nfldb-update script to do it for you. You really should be using that.

The only other way is to blow away your database and redownload the one I provide.

How else were you hoping to update the database?

[skywalkrNCSU]

Gotcha, I didn't know if there was something easier I missed (like a SQL script). Just to make sure, if I use the nfldb-update script, when I go to query in PostgreSQL it will be updated there too and not just when querying using python scripts? Sorry for the real basic questions, my knowledge is purely in the using SQL world and not in the setting things up and all that stuff.

[BurntSushi]

Yup that's right. :)
On Sep 24, 2014 5:29 PM, "skywalkrNCSU" [email protected] wrote:

Gotcha, I didn't know if there was something easier I missed (like a SQL
script). Just to make sure, if I use the nfldb-update script, when I go to
query in PostgreSQL it will be updated there too and not just when querying
using python scripts? Sorry for the real basic questions, my knowledge is
purely in the using SQL world and not in the setting things up and all that
stuff.

—
Reply to this email directly or view it on GitHub
#59 (comment).