MyMDb your local IMDB store

Paw Jershauge

Rate me:

5.00/5 (8 votes)

22 Jul 2013CPOL

61.7K

2.5K

Want your own movie database??? Download IMDB in 20 minutes.

Download source

Introduction

The program will help you to:

Create a local DB for Movies and Series
Download the data from one of IMDB's Interfaces
Synchronize your data

Today (22-07-2013) there where 2.583.953 movies and series

DB Layout

Click here to make large...

Using the code

Step 1: Telling the program which SQL Server to use, and test the connection

Step 2: Building the local database. If the DB exists you can rebuild it or skip this step.

Step 3: Choosing the IMDB Interface to download from...

Once you have selected the Interface check the files you want to download, and press Download data.

The program will automatically download and decompress the files.

Step 4: Synchronizing your data

Points of Interest

If you want to build your own movie database, so you don't have to scrape IMDB all the time, this could give you some idea to how you should go along with it...

History

22-07-2013: First draft posted.

TODO: Explain the code.

Download

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Paw Jershauge

Software Developer

Denmark

blog: C# And I
About.me Paw Jershauge
ListView Group Sorter
An Code Generator, for making SQL table into .Net Classses (2nd place in the Code Generation 2008 Competition)
A Class for getting the Rss feed list of a website
Seagate Date Code Calculator
DNSBL lookup Class
Base N converter (N = 10-62)
Lightweight Directory Access Protocol Uniform resource identifier (LDAPUri)
LoginHours from DirectoryEntry into boolean array

Prepare SQL Server for Operations... [20.11.2014 03:08:27] Change script command to MyMDb database... Success! [20.11.2014 03:08:27] Preparing the bulk tables... Success! [20.11.2014 03:08:27] Movies are being processed, please wait... [20.11.2014 03:11:59] Data has been send to the server... [20.11.2014 03:11:59] Commencing Synchronization, please wait on the SQL Server to finish... [20.11.2014 03:12:00] Movies failed to be synchronized!, please see the following Error message... Invalid column name '$ACTION'. [20.11.2014 03:12:00] Tag Lines are being processed, please wait... [20.11.2014 03:12:04] Data has been send to the server... [20.11.2014 03:12:04] Commencing Synchronization, please wait on the SQL Server to finish... [20.11.2014 03:12:04] Data has been send to the server... [20.11.2014 03:12:04] Commencing Synchronization, please wait on the SQL Server to finish... [20.11.2014 03:12:05] Tag Lines failed to be synchronized!, please see the following Error message... Invalid column name '$ACTION'

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.