On 05/14/2013 08:48 AM, kristian kvilekval wrote:
I was really hoping to see be able to store several ten's of millions
XML documents in postgres, but I would also like to use Xquery to
retrieve results. Back in 2010 there was some mailing list discussion
about using integrating the xquery processor of zorba into postgres.
I was trying to gauge the interest level and if anybody had attempted
it. As you say, JSON has stolen all the thunder, and in fact the
Zorba people have worked on JSONiq (an xquery processor for JSON data
structures), but our project uses XML. We like the flexibility you
get with Xquery and I am looking around for some solutions.
On Tue, May 14, 2013 at 12:37 AM, John R Pierce <[email protected]
<mailto:[email protected]>> wrote:
On 5/13/2013 9:31 PM, kristian kvilekval wrote:
I saw on the mailing list that back in 2010 there was some
discussion of using Zorba to add xquery capabilities to
postgres. I was wondering if any progress had been made on
this and what the current interest levels of supporting xml in
postgres are?
Zorba has a JDBC database interface, and JDBC can talk to
postgres. this would let you use zorba to query a postgres
database via xQuery. isn't that what you want?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list ([email protected]
<mailto:[email protected]>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Have you try xpath in postgres yet? We store xml, but do very little
xpathing against it. I do it mainly for trouble shooting. We have a
problem with multiple namespaces used in our content. Because of that
one is often left searching for '//*/name()="some-value"' to get around
the namespace differences inter and intra record. But xpath and
particularly xpath_table work quite well even with that constraint.
