PostgreSQL and XML support

From: "Andrey Fomichev" <fomichev(at)ispras(dot)ru>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Andrey Fomichev" <fomichev(at)ispras(dot)ru>
Subject: PostgreSQL and XML support
Date: 2005-09-06 14:48:01
Message-ID: KMEKJEPBHIGAGHJFMEHGOEJADPAA.fomichev@ispras.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I would like to raise a discussion about XML support in PostgreSQL.
I'm a person who is quite experienced in XML data management and new
to PostgreSQL. So, excuse me if I ask trivial questions about
PostgreSQL...

I tried to find something about support for XML in PostrgreSQL. As far
as I understand, PosgreSQL does not have native support for XML. But I've
found several works around.
1. XML databases build on top of PostgreSQL. They are XpSQL and XDB (sorry,
if I missed something). Are they alive and functionable?
2. Contribution made by John Gray (xml and xml2). This is a tool that uses
'shredding' for storing XML in relational tables (another words, it
decomposes XML document into nodes and places these nodes into tables in
such a way that we can reconstruct this document back). What do you think
about this tool?

In general, I have the following questions to PostgreSQL users.
- Are there any of you who need to store and query XML data?
- Do you already use PostgreSQL to store XML data or you are
just thinking about it?
- If you store XML data in PostgreSQL, how do you do it? What tool
do you use?
- Do you need some advanced query capabilities? Like XQuery, XPath 2.0
- Do you need some advanced update capabilities? Like node-level updates

And I have the following question to PostgreSQL developers.
Do you have any plans for native support for XML in PostgreSQL? By native
support I understand persistent data structured specially developed for
storing XML on disk and query/update it efficiently. As far as I know,
native
support for XML is a way other database vendors (Oracle, Microsoft, IBM) go.

Best regards,
Andrey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cristian Prieto 2005-09-06 14:55:26 Re: Insert Ignore or something similar...
Previous Message A. Kretschmer 2005-09-06 14:00:32 Re: Installation problem