Movie database project

Hi,

I've actually done exactly what you are looking for here. But it's pretty hardcoded as it started out by just listing out my movie directory pretty plain, and then I started patching on it. It was back in the days, when my programming skills were pretty basic. So I won't release it or something, but I can give you an idea of how I did it.

I'm using PHP, mySQL, JavaScript and jQuery, and an Android application (I've moved to the Apple-world now, so I better make an iOS-version also, or a mobile web app).

All my movie and series information is stored in mySQL. I have a cron job that is executed every night, looking for new files in my series and movie folders. I am specific about how I name my files. This is because I check my episode against thetvdb.com that provides a nice API. Here I also download posters and stuff, that I store on my NAS web server and use to show the information. The movies are checked agaist Imdb. They don't provide an open API, so here I use a PHP-wrapper.

To fetch information from the DB I have created a REST-ish API with some PHP-scripts that delivers JSON. This way I can easily get the information using AJAX to my web site, and to my Android application. Both these apps allows me to browse my episodes and movies, as well as marking what I've seen and not. I've also made a script that checks if there are new episode of the series i already got. This info is show in a widget i my Android app, which is pretty sweet :)


Hope this was to any help and inspiration. You can come pretty far with the stack supported on the ReadyNAS.

Wow, that is impressive. Sounds like a nice set up. Thanks for the info. Now, at least I know it CAN be done.

For what it's worth, time-wise, you might want to consider buying something. A few years back I got a bar-code scanner that came with a media database. Instead of data entry, you just scan the code on the DVD box and it looks everything up (mostly using Amazon) and populates your database for you. Unless you just want to spend the time hacking something together. :)

I have an older version of the mini scanner shown here:

http://www.intelliscanner.com/index-home.html

As I said, it comes with several database applications (wine, comic books, and yes of course media) that would probably serve your purpose. I've been very happy with mine.