I have been collecting DVD movies for years now, and on some occasions, I have forgotten that I already owned a movie. More times than I hate to admit, I have ended up with two copies. This past weekend, I revised my Flex DVD Library application. By combining Flex with a ColdFusion, CFC-based backend that allows me to store my DVD inventory in a mySQL database, I should no longer buy more than one copy of the same movie. :-)
This Flex application displays the inventory in a DataGrid with an itemRenderer that displays the DVD cover art, and it utilizes an updated Amazon Product API (as of August 15, 2009, you are required to send a security request authentication signature) webservice to dynamically locate the URL of a medium-sized image of the cover. I used Flex Builder's ColdFusion CFC Value Object Wizard to quickly create the server-side components and, bam, got er done - storing all the DVD's pertinent information in a mySQL 5 database. Leveraging the YouTube API, the application also captures the DVD's trailer link. A final call to an IMDB webservice, and the app grabs the movie's running time and genre. I added the edit capability to allow easy updating of the DVD archive's information. The source code is provided.
Try It
Source code
Documentation that you may find helpful:
The mySQL script for generating the database table is:
http://labs.insideflex.com/flextraining/movies/tbl_movie.zip
Tip Jar:
|