Re: XML in MySQL
Jeremy Zawodny wrote: SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. And off-topic from the original question but to repeat myself from before, using XML and MySQL together isn't that difficult in most situations you may encounter. A little wrapping to be sure, but validating parsers are easy to get your hands on and designing an expat-based parser that knows your schema (XML & DB) for translation isn't a big chore for most data types I've come across. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
- Original Message - From: "Jon Haugsand" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 23, 2003 2:57 AM Subject: Re: XML in MySQL > * [EMAIL PROTECTED] > > geez mysql is an open source product you cannot expect so much too soon over > > a very expensive commercial product which has been out for years , for xml i > > usually generate it on the fly when i am extracting the data using the field > > names as the xml tag nodes. > > Converting a relational dbms into an XML frontend is like trying to > change a Chevrolet into a Beetle. (The problem is of course that too > many managers orders too much xml these days.) Hear, hear! A good place to look if you're interested in the views of relational DB "purists" (and what they think of XML, etc) is http://www.dbdebunk.com/ -S > > -- > Jon Haugsand, [EMAIL PROTECTED] > http://www.norges-bank.no > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
* [EMAIL PROTECTED] > geez mysql is an open source product you cannot expect so much too soon over > a very expensive commercial product which has been out for years , for xml i > usually generate it on the fly when i am extracting the data using the field > names as the xml tag nodes. Converting a relational dbms into an XML frontend is like trying to change a Chevrolet into a Beetle. (The problem is of course that too many managers orders too much xml these days.) -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
well you probably want to import and export XML into tables.. is this what you want to do? IF you want to process it qua XML as opposed to TEXT or BLOB then it 's not that hard, right? You have data in XML that needs to be put in columns and visa-versaI am not *certain* what you're looking for...here's a resource for you- http://www.xmlphp.com/ I am sure there are probably others books and packages out there.. that';s why God gave you Google.. -C - Original Message - From: "chad pratt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 29, 2003 7:53 PM Subject: Re: XML in MySQL > but see SOAP and WSDL support add ons which are freely available and > probably what you want anyway > > -C > - Original Message - > From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > To: "Joel Amoussou" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Sunday, June 22, 2003 4:56 PM > Subject: Re: XML in MySQL > > > > On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: > > > Hello, > > > > > > What is the level of support for XML in MySQL. Is there any kit > > > similar to the Oracle XML Developper Kit or the XML features in SQL > > > Server 2000? > > > > No. MySQL doesn't nativel deal with XML. > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Mon, Jun 23, 2003 at 07:58:51AM +1000, electroteque wrote: > > geez mysql is an open source product you cannot expect so much too > soon over a very expensive commercial product which has been out for > years , for xml i usually generate it on the fly when i am > extracting the data using the field names as the xml tag nodes. This has nothing to do with my expectations and everything to do with answering Joel Amoussou's question(s). As a long-time MySQL and open source software user, I'm well aware of the development differences between OS and commercial software. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,460,949 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: XML in MySQL
geez mysql is an open source product you cannot expect so much too soon over a very expensive commercial product which has been out for years , for xml i usually generate it on the fly when i am extracting the data using the field names as the xml tag nodes. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 7:55 AM To: chad pratt Cc: [EMAIL PROTECTED] Subject: Re: XML in MySQL On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote: > PHP-SOAP, > PEAR SOAP, > NuSOAP > > need more SOAP? SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,269,579 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote: > PHP-SOAP, > PEAR SOAP, > NuSOAP > > need more SOAP? SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,269,579 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
PHP-SOAP, PEAR SOAP, NuSOAP need more SOAP? -C - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "chad pratt" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 22, 2003 5:04 PM Subject: Re: XML in MySQL > On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote: > > but see SOAP and WSDL support add ons which are freely available and > > probably what you want anyway > > I don't buy that. If you've really looked at what Oracle is offering, > it's hard to argue that the MySQL addons really solve the same > problems. > > Have you seen otherwise? Maybe the addons are quite a bit better than > last time I looked? > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 19 days, processed 619,598,219 queries (366/sec. avg) > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote: > but see SOAP and WSDL support add ons which are freely available and > probably what you want anyway I don't buy that. If you've really looked at what Oracle is offering, it's hard to argue that the MySQL addons really solve the same problems. Have you seen otherwise? Maybe the addons are quite a bit better than last time I looked? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,598,219 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
but see SOAP and WSDL support add ons which are freely available and probably what you want anyway -C - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Joel Amoussou" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 22, 2003 4:56 PM Subject: Re: XML in MySQL > On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: > > Hello, > > > > What is the level of support for XML in MySQL. Is there any kit > > similar to the Oracle XML Developper Kit or the XML features in SQL > > Server 2000? > > No. MySQL doesn't nativel deal with XML. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: > Hello, > > What is the level of support for XML in MySQL. Is there any kit > similar to the Oracle XML Developper Kit or the XML features in SQL > Server 2000? No. MySQL doesn't nativel deal with XML. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]