Jump to content

Archived

This topic is now archived and is closed to further replies.

nloding

MySQL vs XML for my new site

Recommended Posts

I briefly touched on this in the PHP Help forum, but that wasn't the place, so I'm bringing the question here:

I will be setting up a small movie database for a video rental company I'm doing a site for.  It will only feature movies on the New Release wall.  There shouldn't be more than 100 entries at one time.  Each movie needs a cover picture, director, actor, rating, description, dvd features, etc. -- some could get long, especially with the required description.  I would rather do a database of some sort than a new page for every movie.

I'm trying to decide between MySQL or XML -- which, in your opinion, would be better?  Both are pretty much just as easily called and referenced -- I don't need a high end search, or tons of relations between entries (at most, they'll all belong to 1 extra genre category, like Horror or Action).  So MySQL might be a bit much to set up for the simplicity of what I need, but perhaps it's easiest to utilize in the site.

Any opinions??

--Nathan

Share this post


Link to post
Share on other sites
XML is not a database, even if it's easy to query; not that MySQL 5 doesn't have an easy way to deal with XML data.  I'd go the MySQL route.

Share this post


Link to post
Share on other sites
MySQL. It's easy and it can do more advanced things easier than you would program a XML parser to do the same stuff.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.