MovieLens.sql

The MovieLens database in SQL

For easy importing to PostgreSQL, MySQL, SQLite, and others

How to Use

Clone this repo:

git clone https://github.com/ankane/movielens.sql.git
cd movielens.sql

Download the MovieLens 100k dataset, unzip, and run:

ruby generate.rb path/to/ml-100k > movielens.sql

Then import it into your database with one of the commands below.

PostgreSQL

createdb movielens
psql -d movielens < movielens.sql

MySQL

mysqladmin create movielens
mysql -u root movielens < movielens.sql

SQLite

sqlite3 movielens.sqlite3 < movielens.sql