RE: [PHP-DB] Re: XML From: Peter Lovatt (pjln1 <email protected>)
Date: 06/28/02

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 <email protected>
tel. 0121-242-1473
-----------------------------------------------

> -----Original Message-----
> From: MikeParton [mailto:mike.parton <email protected>]
> Sent: 28 June 2002 02:33
> To: Ed Carp; Peter Lovatt; php-db <email protected>; mysql <email protected>
> 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 <email protected>>
> To: "MikeParton" <mike.parton <email protected>>; "Peter Lovatt"
> <pjln1 <email protected>>; <php-db <email protected>>; <mysql <email protected>>
> 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 <email protected>>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-mike.parton=nimblesdg.com <email protected>>
> > 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
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php