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.
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.
|