From: Ray Racine <ray@malema.com>
To: pgsql-sql@postgreSQL.org <pgsql-sql@postgreSQL.org>
Subject: XML DOM and Postgres
Date: Wed, 20 Jan 1999 14:13:50 -0500
Message-ID: <36A62AED.77FB6C43@malema.com> (raw)
Has anyone experimented on using Postgres and XML in one fashion or
another:
(1) XML documents stored as text with indexed keywords to recall
the document. The document would be stored as a single text blob or
sequence of lines. XML flagged keywords could be index to allow
searching for particular XML documents.
(2) I have seen some questions regarding "tree" storage in
Postgres. head, nodes etc.. Is anyone storing XML documents in DOM
format into Postgres. Is it wise or efficient to do so?
(3) Keep XML documents in separate files. Store keywords, and
file name in Postgres and index keywords.
I have been toying with a few methods but it appears XML is a square peg
in a SQL round hole. If anyone has an approach that they are using I
would like to hear about it.
Is there an Open Source ODBMS out there, that someone is aware of, that
would be a better fit for queryable persistent storage of XML DOM
documents?
Regards,
Ray Racine
ray@malema.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: ray@malema.com
Subject: Re: XML DOM and Postgres
In-Reply-To: <36A62AED.77FB6C43@malema.com>
References: <36A62AED.77FB6C43@malema.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox