I want to build a professional database for my recorded movies, their casts (actors and actresses), scenes and their ****** reviews,Which is the best way to do so ? is it by building a web site or by using database builders like Microsoft Office Access ?
4 Comments Received
July 27th, 2009 @7:38 pm
MS Access will do. But if you want others to read it such as on the web then you could use MySql its free but complicated and requires a server side scripting language like php.
July 29th, 2009 @10:59 am
Imdb, yahoo movies, wikipedia doesn’t do it for you? really? Just go to imdb, register and fill in the “my movies” with your movies. It will always be up to date with actor info and much faster and easier to use. An advanced programmer could also make a combination with yahoo pipes, but that might be a bit too much for your case.
July 30th, 2009 @7:55 pm
I’ll second the “my movies” suggestion from IMDB. Also, if you’ve used amazon, it has a similar feature called your media library - just go to and it’ll probably already have your stuff in there.
If you are wanting to roll your own just for the fun of it, I think it’ll be much easier to start and to visualize the concepts of a database using Access. Once you are familiar with the ideas of Records, Tables, and Relationships, then you could always export your database from Access to a simple SQL script that you could import to a website’s back-end.
Good luck!
August 1st, 2009 @12:18 pm
It really depends on what you’re planning to do with the database and how much experience you have/can hire. If the database is mostly for personal use then MS Access is fine. It’s easy to use, fairly quick and you can move it from computer to computer quite easily.
If you’re planning to make the database publically accessible in some form or if you have a number of people who will need to access/update it at the same time then you’d be much better off with a database server like MySQL, SQL Server or Oracle. These are designed to work very fast, guarantee the integrity of the database and be accessed by (potentially) thousands of people at the same time. The downside you pay for that power is that they are more complex to use and maintain and you’ll have to build your own interface to the database (whether that’s web pages or a custom application).
Leave A Reply