JeopardyDatabase: Difference between revisions

Content added Content deleted
Line 38: Line 38:
Inside the <code>JeopardyDatabase</code> folder is a file called <code>jeopardy.dump</code> which contains a SQL database dump. We need to turn that database dump into a SQLite database.
Inside the <code>JeopardyDatabase</code> folder is a file called <code>jeopardy.dump</code> which contains a SQL database dump. We need to turn that database dump into a SQLite database.


Once you have SQLite installed, you can create a database from jeopardy.dump with:
Once you have SQLite installed, you can create a database from jeopardy.dump with (this needs to be run in the command prompt):


<pre>sqlite3 jeopardy.db < jeopardy.dump</pre>
<pre>sqlite3 jeopardy.db < jeopardy.dump</pre>