From: Christopher Browne <cbbrowne@libertyrms.info>
To: pgsql-hackers@postgresql.org
Subject: Re: is GiST still alive?
Date: Wed, 22 Oct 2003 16:48:46 -0400
Message-ID: <60ptgpf175.fsf@dev6.int.libertyrms.info> (raw)
References: <200310220438.h9M4cY232554@hosting.commandprompt.com>
<200310221219.43179.josh@agliodbs.com>
josh@agliodbs.com (Josh Berkus) writes:
> Gregor,
>> I'm developing a native XML database (C++) (which is supposed to become
>> open source one day) and I'm wondering wheather I could use GiST for it's
>> indexes. Is GiST still alive?
>
> Don't know, sorry.
>
>> Would PostgreSQL fit that requirement? And are you interested in having a
>> fast, scalable XML access method?
>
> We would welcome good XML tools for XML stored in databases.
>
> However, I'm not sure that PostgreSQL is the appropriate platform for an
> all-XML database; we're pretty dogmatically a relational database ... perhaps
> the grandfather of most relational databases.
It leaves open the question of what is the appropriate way of
expressing XML entities and attributes and CDATA in database form.
If the point of the exercise is to have some way of storing XML data
in a database, then you may readily declare it thus:
create table some_table (
-- key columns omitted
xml character varying,
-- additional columns omitted
);
And that's perfectly good at storing XML information.
But I think back to the XML generator I wrote for GnuCash; it has the
notion of building up a hierarchy of entities and attributes, each of
which is visible as an identifyable object of some sort. Mapping that
onto a set of PostgreSQL relations wouldn't work terribly well.
--
let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];;
<http://dev6.int.libertyrms.com/;
Christopher Browne
(416) 646 3304 x124 (land)
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-chat@postgresql.org
Cc: cbbrowne@libertyrms.info, pgsql-hackers@postgresql.org
Subject: Re: is GiST still alive?
In-Reply-To: <60ptgpf175.fsf@dev6.int.libertyrms.info>
References: <200310220438.h9M4cY232554@hosting.commandprompt.com> <200310221219.43179.josh@agliodbs.com> <60ptgpf175.fsf@dev6.int.libertyrms.info>
* 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