It's Alive!

[hollyking]

Having a bit of free time and wanting to get out of dodge hollyqueen and I went up to nerdvana early to help with the prep for the New Year's Eve party. I had some problems sleeping Friday night and spent the time working on resurrecting my movie collection web page. Between the night and other free time I was able to get the code in a usable state. Tonight when we got home I spent a few hours updating the database and sorting the movies on the shelf. So now you can view my movie collection.

If you go view the collection here is a short explanation of what you'll see:

• The three frames on the left are:
  1. Keywords: I have created a list of keywords and assigned them to movie titles. You can see how many movies have a given keyword by the number after the keyword. In the future clicking on a link will display only the movies with that keyword.Decades: This breaks down the collection by the release year in decades. In the future clicking on a decade will show you what movies were released in that decade.
  2. Media: My collection consists of movies in various formats. This section lists the number of movies in each format. Clicking the format will eventually display the movies in that format.
• The center frame is the list of movies. The fields listed for each movie are:
  1. Title: Do I really need to explain this one? If the database has the IMDb information the title is a link that will take you to the appropriate IMDb page.
  2. (Release Year): Again this should be pretty obvious. Clicking the year will, eventually, limit the display to movies that were released in the same year.
  3. { Format }: This is a list of what format I own for each movie. For some of the movies I have copies in more than one format. Clicking on a format will, eventually, display the all the movies in that foramt.
  4. [ Keywords ]: If I have associated any keywords with a movie they are listed in square brackets. Clicking on the link will, eventually, list all the titles associated with that keyword.

Right now the formatting is rough because I haven't actually created any formatting. I just whipped the page up real quick to test the features I want to include. My existing todo list for the page is:

1. Decide if I want to track any more fields in the database. Right now I'm considering adding the MPAA rating and running time. I would be interested to see how my collection breaks down by ratings. I'm not so sure if anything else would be very interesting.
2. Finalize the layout and format of the display page.
3. Finish the various filter links.
4. Add a way to sort the movie display. Right now the display is alphabetical by title, but I want to add be able to sort by year as well.
5. Create a script to save the decade, media and keyword counts each week.
6. Use the weekly counts to generate graphs showing how my collection changes over time.
7. Create some the web pages and code necessary to update the database. Right now the update process is a very error prone manual one.

8. After the movie collection pages are working it will be time to tackle the book collection. Egad, that's going to be huge. Not that the database or web pages will be any more difficult, we just have so many books. I've stopped myself from buying books the last few times we've been in a store because I can't remember if I had a copy already.