Saturday, September 8, 2007

Stalled Netflix work

I started looking at working on the Netflix dataset today, but got stalled when trying to load the data into a MySQL database.  Python doesn't have built-in database connections, and I didn't relish the idea of spending my Saturday wading around in unix path hell.  Another approach, perhaps, tomorrow.

2 comments:

Hugh Brown said...

Not an expert here, but a quick google for "python MySQL library" turned up a number of hits. No good?

http://mysql-python.sourceforge.net/MySQLdb.html
http://adodb.sourceforge.net/

William said...

I don't know how to do it for MySql specifically but I am sure Python has hooks to it. For Berkeley DB:

import dbhash\

db = dbhash.open(filename)
db["hi"] = "mydata"