Re: XML

At 21:33 -0400 6/27/02, MikeParton wrote:

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).

C'mon. XML is just data. There's no particular reason *not* to store it in a database. Is there? But usually people who ask about storing XML in MySQL seem to think MySQL should do something for them other than *just* store and retrieve it. The question is, what? That's what doesn't seem to get answered.

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