On 13 Apr 2007, joel-garry_at_home.com wrote:
> On Apr 13, 8:51 am, DA Morgan <damor..._at_psoug.org> wrote:
>> joel garry wrote:
>> > Now, Daniel says never store XML in the DB,
>>
>> If I did I didn't intend to. I've no problem with XML stored in the
>> database if it is done as document storage in the same manner in
>> which I would store a .PDF or .MPG file.
>
> Apologies, I read it into your statements "I would never store XML
> inside a database if it could be reconstituted
> on demand.
> Without knowing the full set of requirements my initial reaction would
> be ... never store XML. "
> and "...the right job for XML is the one it was designed for which
> was not database storage. If the point of storing XML is document
> storage I'd suggest PKZIP or a compressed BLOB column."
But that isn't the question. That would be like asking should we store
BLOB's in the the database. The question is if I have to store XML vs
relational when/if should I choose one over the other.
--
Galen Boyer
Received on Fri Apr 13 2007 - 19:13:01 CDT
