Month: January 2007

Looks like when it comes to Google, Microsoft has some catching up to do on the Gadget Developer Relations front.

Having spent 10+ years working with, or on a super-fun, easily hackable, and powerful Microsoft

Worth a read, if only for the title of the post.

Uncategorized

I spent a little time last night on a small upgrade to my Good Flicks Netflix+IMDB+RSS mash-up.

Now each movie goes up as its own post, instead of all the week’s new releases going into a single post. This has the dual advantage that the RSS feed has an entry for each movie, which renders much better in the aggregators I’m using at the moment (and probably most others), and thet you can now leave comments next to each movie, in case you want to tell me it sucked, and by the way so does my app.

The other thing I did was to change the UI slightly, to accommodate the title/link/description model, so now below each movie title, you’ll see links to add to your queue, to visit the Netflix page for the movie, and also to visit the corresponding IMDB page.

Lastly, a couple of tips:

You can see a less crufty version of the page by using the print-friendly version (a feature of Manila).

And if you’re using the RSS feed on a mobile device, and your aggregator allows you to specify the User-Agent, use the IE Mobile User-Agent to get a version of the feed that links to the Netflix mobile site, instead of the big, heavy full site.

That User-Agent value is:

Mozilla/4.0 (compatible; MSIE 4.01; Windows CE; PPC; 240x320)

Though anything that contains Windows CE should work.

Hacks and Mash-Ups

Politics

I did a short programming project over the long weekend, building on a script I wrote last summer — it’s an IMDB+Netflix mash-up. Once a week, typically on Tuesdays, my computer at home goes through all the new DVD releases for the week, looks up the user ratings on IMDB, and then builds a post here on JakeSavin.com with links to all the movies in IMDB and Netflix, including links to add to my Netflix queue. Why, you ask? Read on…

Netflix and RSS

I love Netflix, and while the Netflix recommendation system is really cool, it doesn’t help me to find new releases in a timely manner. Now, Netflix does have some RSS feeds, in particular one that lists all the new DVD releases each week, which is a cool feature, but it doesn’t tie into the recommendation system, so its value is minimal as far as my Netflix experience is concerned. After all, I can get a list of new DVD releases in lots of places online and off, including the wall behind the counter at my local Blockbuster or Hollywood Video store.

The trouble with user ratings

Now, while I love Netflix recommendations, their user ratings have the same problems for me that Amazon’s and Yahoo’s do — most movie watchers have less discriminating tastes than I do, and a 5-star rating system doesn’t capture enough granularity to make the rating for a single movie work for me. In aggregate, it works great for the Netflix recommendation engine, but for a single movie it’s hit-or-miss at best. It may also be that there just aren’t enough users rating movies on these systems for the rating to carry much meaning, especially for movies that have just been released. This is where IMDB fits in.

IMDB has really high-quality user ratings

If you’re not familiar with IMDB, it’s a long lived, public database of movies and TV shows, with user ratings, and tons of other data about just about any movie you can think of. Aside from its vast capability for settling movie trivia arguments at parties, the thing I like the most about IMDB is the user ratings.

For whatever reason, IMDB users’ ratings match mine and Cindy’s tastes much more closely than do the ratings on Netflix or Amazon or Yahoo. This is probably at least in part because there may be more users providing ratings on IMDB, but it’s more likely that ratings have been collecting on IMDB for a longer period of time at the point that new DVDs are released, since they enter the IMDB system as soon as their existence is known, rather than near the DVD release date.

My guess is that the IMDB user ratings will also be more accurate than Netflix for other discriminating movie watchers as well.

The IMDB + Google + Netflix + RSS mash-up

So a while back, armed with this knowledge and some pretty good scripting skills, I hacked together a mash-up that loads the Netflix new release RSS feed, looks up all the titles using IMDB’s search engine, scrapes the user ratings from the HTML in the search result, and builds an outline (in OPML) on my computer with links to movies with ratings over 6.0. It worked pretty well for a while, and found lots of great movies I would otherwise have passed by. But it had some problems:

  • Many times, IMDB would return multiple results, and not necessarily for the movie I wanted
  • Sometimes the IMDB search would return the wrong movie — their search isn’t as good as Google’s
  • The resulting document was only useful for me: Cindy didn’t want to get on my computer to look at it, and so when I get busy with work or whatever, the new movies don’t make it into our queue — not to mention that nobody else could see them at all

So over the weekend I updated my hack. Here’s what I changed:

  • Now it uses Google to find the movies on IMDB, using a search like "movie title" 2006 inurl:title site:imdb.com — this usually gets to the correct page on IMDB
  • Once all the results have been found and IMDB user ratings compiled, it builds the HTML for a post on my blog, and sends it up to my New DVD Releases category — and the HTML now includes links straight to the Netflix AddToQueue page for the movie — this category is linked to under Good Flicks in my site navigation
  • As a bonus, my site is now checking the user-agent, so when serving to IE on Windows Mobile, all the Netflix links go to the appropriate page on the Netflix Mobile site, to make for happy mobile Netflix’ing

The end result: A page where anyone who has a Netflix account can go to find great new movies, sorted by IMDB user ratings. Just log into Netflix, go to my Good Flix page, and click the title of any movie to add it to your Netflix queue.

There’s still the occasional wrong movie returned by Google — for example right now it’s showing IMDB information for Cars instead of a new release called The Route — but far fewer than before. Also, movies that have been rated by only a few people, say under 400 or so, may not actually be any good since the first raters seem to be biased towards higher ratings, for whatever reason. For example, Tweek City is probably not worthy of an 8.2 out of 10, but that’s what the first 15 raters seem to think — I wonder how many of them are affiliated with the making of the movie. But — movies with high IMDB user ratings by 500 or more people are almost always worth watching. For example, Beer League might actually be funny with a 6.1 for 652 votes. At least the movies my mash-up finds are likely to be worth watching by me, and if you like them too, then all the better.

This would all work much better if IMDB had a reliable API for finding movies and getting their user rating data, but as far as I know they don’t, so for now it’s a hack. Maybe they’ll open up their database more in the future to stay competitive. After all, IMDB is owned by Amazon, and they’re definitely hip to web APIs in general. We’ll see…

So have fun, and let me know what you think of this hack?

Hacks and Mash-Ups