Site conversion from mysql to XML

Chuppa · 10-02-2006, 11:03 AM

Hey all,

I am working on a project for a company that wants to start using XML datasheets for their site's content instead of a mysql database. They intend to hire a company to store and update the XML files for all of their products.
????: NamePros.com http://www.namepros.com/programming/243484-site-conversion-from-mysql-to-xml.html

The assignment for me is to change the current, database-driven website to a XML driven website. I however don't have a clue of XML, and certainly not how to use it in a database-like manner.

So my question is: do you have good links to sites that explian how to use XML for this purpose? Tutorials or general info pages are equally appreciated. It's tough to find good info when you're new to a subject.

Thanks in advance for your help,
Chuppa

Barrucadu · 10-02-2006, 11:07 AM

I dont know much about xml - but here is the syntax:

Code:

<xml>
     <item 1>
          <name>Name Of Product</name>
          <desc>A sample product</desc>
     </item1>
</xml>

Chuppa · 10-04-2006, 03:21 PM

Thanks for that info, but I'm looking for some more specific info on how to work with XML files and using them as data sheets.

Anyone else?

Redleg · 10-04-2006, 04:39 PM

Just a quick question:
How large is the MySQL database(s) you're planning to convert to XML file(s)???
And why would you want to do that?

If it's a big DB then I wouldn't recommend you to do that since it can be really slow and server intensive to use XML files alone...

drakewla · 10-05-2006, 03:41 PM

Hello,

I guess reading information in XML files is OK, but writing is a heavy and dangerous process; what happens to the XML file if your web server stops, restarts or reboots during a write?

Also, SQL allows indexes, which can make a huge speed difference while looking for a field.

If it's for reading big XML files on the fly, I'd suggest to set up a caching system.

Chuppa · 10-14-2006, 05:50 AM

Thanks for your answers, and sorry for my late reply. I guess the notification system doesn't always work right

.

I am not converting the database myself, some company is doing that. It allows webshops etc to access the product information. My job is to change the original database-driven website of the company into an xml-driven website, using the same datasheets that the webshops would use (so information is consistent everywhere).
????: NamePros.com http://www.namepros.com/showthread.php?t=243484

www.ithaier.eu

Do you know which way to go about it is easier/better? I could be using XSL for getting all the data from the xml sheets and outputting it, and then including that XSL file into my php file so it shows up correctly into the webpage. Or, I could use something like data islands to put it directly into the website. Are there compaitibily issues, and what is the "common" way of doing things?
Or am I missing a different option that's better or easier?

10-02-2006, 11:03 AM	THREAD STARTER #1 (permalink)
Chuppa New Member Join Date: Jan 2006 Location: the Netherlands Posts: 7	Site conversion from mysql to XML Hey all, I am working on a project for a company that wants to start using XML datasheets for their site's content instead of a mysql database. They intend to hire a company to store and update the XML files for all of their products. ????: NamePros.com http://www.namepros.com/programming/243484-site-conversion-from-mysql-to-xml.html The assignment for me is to change the current, database-driven website to a XML driven website. I however don't have a clue of XML, and certainly not how to use it in a database-like manner. So my question is: do you have good links to sites that explian how to use XML for this purpose? Tutorials or general info pages are equally appreciated. It's tough to find good info when you're new to a subject. Thanks in advance for your help, Chuppa __________________ www.theChuppa.com http://chuppa.3dcaffeine.com www.3i-design.nl

10-02-2006, 11:07 AM	#2 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	I dont know much about xml - but here is the syntax: Code: <xml> <item 1> <name>Name Of Product</name> <desc>A sample product</desc> </item1> </xml> __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

10-04-2006, 03:21 PM	THREAD STARTER #3 (permalink)
Chuppa New Member Join Date: Jan 2006 Location: the Netherlands Posts: 7	Thanks for that info, but I'm looking for some more specific info on how to work with XML files and using them as data sheets. Anyone else? __________________ www.theChuppa.com http://chuppa.3dcaffeine.com www.3i-design.nl

10-04-2006, 04:39 PM	#4 (permalink)
Redleg Ultima Ratio Regum Join Date: Sep 2003 Location: Up North Posts: 2,082	Just a quick question: How large is the MySQL database(s) you're planning to convert to XML file(s)??? And why would you want to do that? If it's a big DB then I wouldn't recommend you to do that since it can be really slow and server intensive to use XML files alone... __________________ IP Whois + Geolocation\|Geolocate your IP\|Dynamic Forum Sigs <meta name="Jedi Mind Trick" content="Buy my domains, you will!">

10-05-2006, 03:41 PM	#5 (permalink)
drakewla NamePros Member Join Date: Mar 2006 Location: Luxembourg Posts: 87	Hello, I guess reading information in XML files is OK, but writing is a heavy and dangerous process; what happens to the XML file if your web server stops, restarts or reboots during a write? Also, SQL allows indexes, which can make a huge speed difference while looking for a field. If it's for reading big XML files on the fly, I'd suggest to set up a caching system. __________________ Word list domains: died or alive?

10-14-2006, 05:50 AM	THREAD STARTER #6 (permalink)
Chuppa New Member Join Date: Jan 2006 Location: the Netherlands Posts: 7	Thanks for your answers, and sorry for my late reply. I guess the notification system doesn't always work right . I am not converting the database myself, some company is doing that. It allows webshops etc to access the product information. My job is to change the original database-driven website of the company into an xml-driven website, using the same datasheets that the webshops would use (so information is consistent everywhere). ????: NamePros.com http://www.namepros.com/showthread.php?t=243484 www.ithaier.eu Do you know which way to go about it is easier/better? I could be using XSL for getting all the data from the xml sheets and outputting it, and then including that XSL file into my php file so it shows up correctly into the webpage. Or, I could use something like data islands to put it directly into the website. Are there compaitibily issues, and what is the "common" way of doing things? Or am I missing a different option that's better or easier? __________________ www.theChuppa.com http://chuppa.3dcaffeine.com www.3i-design.nl

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)