New blog post: "PostgreSQL support in Orbeon Forms"

http://blog.orbeon.com/2014/12/postgresql-support-in-orbeon-forms.html

Enjoy,

Alex

That's a great option!

Does PostgreSQL have an optimized support like Oracle or does it has limitations like MySQL with Orbeon?

Regarding the next DB maybe you could support I think MongoDB would be the best option. I have seen websites increasingly choosing it as the main option.

Happy New Year!

Hi,

Good question. From Orbeon Forms' perspective, the code is pretty much the same on all databases, and it's "just" that some databases are much better than others are running XPath expressions on XML data. But I am not sure how good PostgreSQL is at running XPath on XML; the documentation (linked below) doesn't give me any reason to be particularly optimistic, as it doesn't list "performance" as reason to use the `xml` type of the `text` type.

http://www.postgresql.org/docs/9.4/static/datatype-xml.html

Alex