RE: [PHP-DB] Re: XML

Hi Interesting discussion. The question was actually about converting XML data and loading it into a MySql database. Should have been clearer in the original question :) i.e. XML -> convert to field data -> MySql table We have a website that has been self contained but increasingly needs to interface with other sites and servers. We are a portal site which takes orders from customers, finds the best supplier and passes the order to the supplier. To date, data interchange as been by users uploading csv data. We are progressing to live interfacing and want to use XML to query and/ or load data to and from remote servers. Not having worked with XML before and having to put a fixed price on the contract I was looking for techniques for converting XML -> MySql and MySql -> XML and any problems - don't want to over or under quote. Thanks for the replies, if anybody has anything to add in the light of the above I would be interested to hear from you. Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net info@sunmaia.net tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: MikeParton [mailto:mike.parton@nimblesdg.com] > Sent: 28 June 2002 02:33 > To: Ed Carp; Peter Lovatt; php-db@lists.php.net; mysql@lists.mysql.com > Subject: [PHP-DB] Re: XML > > > Would be interesting to hear from Peter on why he feels the urge to store > XML docs in MySQL (or, better said: I would be interested in hearing what > he is trying to accomplish and why he...or someone...feels XML stored in a > relational database is the way to go). > > mysql, sql, xql, xquery, query....what did I miss? > > Mike > > > ----- Original Message ----- > From: "Ed Carp" <erc@pobox.com> > To: "MikeParton" <mike.parton@nimblesdg.com>; "Peter Lovatt" > <pjln1@sunmaia.net>; <php-db@lists.php.net>; <mysql@lists.mysql.com> > Sent: Thursday, June 27, 2002 9:14 PM > Subject: RE: XML > > > > > On the other hand, proclaimed "native" XML databases (eg, > Software AG's > > > Tamino, Ixiasoft's TEXTML) store the "XML-wrapped" data in the > database...no > > > need to wrap and unwrap the metadata, document/data structure from the > data. > > > > Isn't that more than a bit stupid? Databases are for storing data, not > metadata. Ask Monty why he doesn't store data natively as > > XML. Short answer: it's stupid, unless all you ever want to > see from your > database is XML-wrapped data and never want to see it any > > other way. > > > > The whole world isn't XML, nor should it be. 40+ years of working with > data tells us that you ALWAYS want to store data in its > > simplest form. > > > > sql,db,mysql > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <mysql-thread113254@lists.mysql.com> > > To unsubscribe, e-mail > <mysql-unsubscribe-mike.parton=nimblesdg.com@lists.mysql.com> > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >