Download IMDB's public data from AWS, import it to different types of databases and query it.
...a work in progress...to help me learn stuff...
- AWS account and credentials (to download the data from IMDB - requester pays for the download)
- Docker 17.12.0
- npm 5.6.0
- node 8.9.0
- This is a monorepo, so check out the instructions in the relevant DB package (e.g. ./packages/imdb-dbs-mongo)
- MongoDB - pretty much there
- neo4j - next up
- PostgreSQL - one day
- Show the latest 10 movies a given actor has been in
- For a given actor, find their 5 most highly rated films
- Find the top rated 10 films with more than n votes
- Given two people, list what movies they appeared in together
- List all of the cast and crew in a given movie
- Find the most prolific actor is a given period
- Find the 5 most prolific actors in a given genre
- For a given person (actor or cast), find the 5 people they've worked with the most
- 6 degrees of Kevin Bacon - given 2 actors, find the shortest link between them
Information courtesy of IMDb (http://www.imdb.com). Used with permission.