Monday, October 19, 2009

Which is the best to do database (Web site builders or database builders like Microsoft Office Acces

I want to build a professional database for my recorded movies, their casts (actors and actresses), scenes and their nudity 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 ?



Which is the best to do database (Web site builders or database builders like Microsoft Office Access) ?norton



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.



Which is the best to do database (Web site builders or database builders like Microsoft Office Access) ?spyware remover



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).
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 http://amazon.com/yourmedialibrary 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!
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.

No comments:

Post a Comment