I have christened the first version of the MovieDB last night. It's not to where I want it yet but it does work and is serviceable. I used it for the first time last night to enter the latest batch of movies and it worked fine.
I feel this was a very simple task for a first project collaborating between myself and Ale and I am happy with what we have produced so far even though it probably took way longer than it should have. It is still a bit rough to work over Skype with each other. I feel if we were in the same room we'd have made better progress but whatever. Something is better than nothing.
The task was to create a database so that as I acquire digital copies of movies I can log them in so I know what I have, when I got them, file size, etc, etc. I thought to put several other attributes in associated with each movie as well so I pull different reports on them. Say I want to know what horror movies I have or something along those lines. I have been using a regular Excel spreadsheet to keep track of this but it was getting too much and it was time to start a database.
So we hashed that out and started making tables and a form. Not too difficult. Ale thought typing in the information for each movie was stupid though when in the file properties that information already existed so she branched off trying to invent what we have come to call the Magical Button. Apparently you can use the internet to acquire movie information from a bunch of different websites (Amazon, Netflix, IMDB) and she found a site called TagChimp where you can register and get some information on APIs to do just that. She got it up fairly quickly but it's not working 100% yet. I figure this will be something we will work on for version 2.0 of this project. I didn't mind the typing but I can see where once finished this could be a powerful tool plus it would be valuable experience in coding and development so I am happy she was able to research that option.
There were a couple additional issues working with new version of Access I had on my PC but we hammered through those. I was happy to be using a current tool for once. We still use ancient versions of Access and Excel at my work.
After the main form was established I got a switchboard working and made a few reports and it seems like we were ready to go. It worked just fine as I entered data in last night. I didn't have any problems but I already see room for improvement. We still have to get the keyword system implemented. That is another big fix that will bring some benefits as any crazy word we feel like entering and tagging to a title will be able to be searched on. I think that is when it will really feel like we did soemthing awesome.
Again I am very happy with how this turned out. I think it did take way too long to come up with it but oh well. I'm glad Ale was there to talk to and assist me with this. She is wonderful and the only person I've found in my life that cares about my concerns and it makes her happy to help me. She is so smart and awesome. I can't wait to start another project. (We are thinking about making a Firefox extension that can add a movie to your Netflix queue from any web page anywhere) I just know that working together we will become smarter and better than we would separately.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment