New blog post: "PostgreSQL support in Orbeon Forms"

[Alessandro Vernet]

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

Enjoy,

Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
--
View this message in context: http://discuss.orbeon.com/New-blog-post-PostgreSQL-support-in-Orbeon-Forms-tp4659303.html
Sent from the Orbeon Forms community mailing list mailing list archive at Nabble.com.

[ali112]

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!

--
View this message in context: http://discuss.orbeon.com/New-blog-post-PostgreSQL-support-in-Orbeon-Forms-tp4659303p4659401.html

[Alessandro Vernet]

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

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

--
View this message in context: http://discuss.orbeon.com/New-blog-post-PostgreSQL-support-in-Orbeon-Forms-tp4659303p4659404.html