Jump to content


Photo

MySQL vs XML for my new site


  • Please log in to reply
2 replies to this topic

#1 nloding

nloding
  • Members
  • PipPipPip
  • Advanced Member
  • 321 posts

Posted 11 July 2006 - 06:40 PM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 12 July 2006 - 03:10 AM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 12 July 2006 - 07:51 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users