mysql or xml for cms?
Posted: Fri Sep 15, 2006 3:26 pm
Hi folks,
i am a 3rd year IT student and for my final year project i am creating a web based multimedia database cms. This will act in a similar way to flickr or nuke but with subject specific additions. For the scripting side of things i have choosen PHP given my knowledge of this language and it's ease of use. However for the backend and datastorage i have the choice of mysql (which i am familiar with) or XML (which i am not familiar with).
I have seen many (MANY!) cms's built using php/mysql, but on initial searching there seem to be only a few based on php/XML.
Could someone give me a bullet list of pros and cons of using XML over mysql for my application? Is there a resounding reason not to use mysql for modern data storage solutions? I'm thinking long term data storage but also the ease of displaying that data easily on a website. Plus efficently searching the data (and there would likely be lots of data to search so my solution has to scale well), as well as saving multimedia files including text as well as still images (png), video clips, sound clips etc etc. Is XML capable of this sort of data storage? Perhaps some sort of MIME encoding? I was thinking that in mysql i would use blobs but am not familiar with XML's methods.
Sorry for the ramble, any insights would be useful. Thanks in advance
i am a 3rd year IT student and for my final year project i am creating a web based multimedia database cms. This will act in a similar way to flickr or nuke but with subject specific additions. For the scripting side of things i have choosen PHP given my knowledge of this language and it's ease of use. However for the backend and datastorage i have the choice of mysql (which i am familiar with) or XML (which i am not familiar with).
I have seen many (MANY!) cms's built using php/mysql, but on initial searching there seem to be only a few based on php/XML.
Could someone give me a bullet list of pros and cons of using XML over mysql for my application? Is there a resounding reason not to use mysql for modern data storage solutions? I'm thinking long term data storage but also the ease of displaying that data easily on a website. Plus efficently searching the data (and there would likely be lots of data to search so my solution has to scale well), as well as saving multimedia files including text as well as still images (png), video clips, sound clips etc etc. Is XML capable of this sort of data storage? Perhaps some sort of MIME encoding? I was thinking that in mysql i would use blobs but am not familiar with XML's methods.
Sorry for the ramble, any insights would be useful. Thanks in advance