Xml or Mysql?
Posted: Sat May 10, 2008 4:17 pm
My first post on this forum.
Im new to the world of Php and am learning very fast and enjoying the pleasures gained from bringing things to life:) I am currently a good chunk of my way through developement of a new site and I have one question that I already have a few answers for.
Basically for say a blog system, communicating the contents of a folder and captions (for dynamic picture gallery), internal email system and off the top of my head say a news system am I better off using xml or mysql?
For instance - the dynamic picture gallery automatically uploads images, creates thumbnails into specific user folders - then I will either read the src of the images and captions from the table in the database or from an xml file where they are stored. Pretty much the same theory for the rest. Also the usual delete and add theory for xml and database (as in the storage method is not going to get clogged up with redundant information)
I have read that xml is good for portability between programs as such and also that mysql is very fast - but I am still a little confused as to the best way to turn for the storage of this data. Considering php will be the face of submitting and retriving both forms of data and the processes used will be reflected across different user profiles. I obviously want the site I am creating to be as fast as possible and to be as scaleable as possible and basically wish to design and create it by using best practices.
So what do you say? Xml or Mysql
Anyway your thoughts would be appreciated on this.
Im new to the world of Php and am learning very fast and enjoying the pleasures gained from bringing things to life:) I am currently a good chunk of my way through developement of a new site and I have one question that I already have a few answers for.
Basically for say a blog system, communicating the contents of a folder and captions (for dynamic picture gallery), internal email system and off the top of my head say a news system am I better off using xml or mysql?
For instance - the dynamic picture gallery automatically uploads images, creates thumbnails into specific user folders - then I will either read the src of the images and captions from the table in the database or from an xml file where they are stored. Pretty much the same theory for the rest. Also the usual delete and add theory for xml and database (as in the storage method is not going to get clogged up with redundant information)
I have read that xml is good for portability between programs as such and also that mysql is very fast - but I am still a little confused as to the best way to turn for the storage of this data. Considering php will be the face of submitting and retriving both forms of data and the processes used will be reflected across different user profiles. I obviously want the site I am creating to be as fast as possible and to be as scaleable as possible and basically wish to design and create it by using best practices.
So what do you say? Xml or Mysql
Anyway your thoughts would be appreciated on this.