Built the entity relationship diagram for my film rankings database in SQL 2008. This is going to be fun building the front-end for this!
Sounds neat! Do you have a way around entering movie info manually? I'm still mad that IMDB doesn't have any sort of API for their database.
Yeah it's going to be basically all manual. I'm not trying to make an exhaustive list like IMDB or Flickchart is doing. Just a way to catalog all the films I've got in my various spreadsheets now and it will grow with every movie I see. I want to make ranking easier and do some photo/screenshot tagging (like you would in facebook) so you can enter an actor's name and get all the graphics you have on file with that actor in it. It'll also help me track movies I've seen and movies by year and track my home library better.
It's mostly an excersize in getting better at web development. I've been mainly a client-server guy.
Yeah, that sounds cool. I wanted an API so I could do something similar, but where my rankings would correlate to IMDB title IDs, that way I would have the benefit of things like year, director, genres, cast, etc. without having to manually enter anything but the title. It was a nice idea at least.
What are you writing the front end in?