Re: postgres and xquery - Mailing list pgsql-general
On 05/14/2013 08:48 AM, kristian kvilekval wrote:
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.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 <pierce@hogranch.com> wrote:On 5/13/2013 9:31 PM, kristian kvilekval wrote: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?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?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pgsql-general by date: