Nexeo Embraces PostgreSQL
February 10, 2011
Nuxeo, a software manufacturer specializing in Enterprise Content Management, recently expressed criticism for one particular open source object-relational database system and in the process praised another.
Per the aptly titled post “Why Avoid MySQL?”, the case is made against MySQL in a joint effort by Nuxeo’s Founder and head of R&D. This is how the post opens: “Nuxeo can work with many databases (PostgreSQL, MySQL, Oracle, Microsoft SQL Server, and others could be added). But MySQL should be avoided if at all possible, because it has major deficiencies that Nuxeo cannot really work around.” What follows is a bullet list of fourteen points reinforcing that claim. The list cites dropped connections, row size limits as well as poor full text configuration, among other issues. They end saying, “All these problems lead us to recommend not using MySQL in production, and using PostgreSQL instead which is a much nicer database engine.”
A quick jump to the PostgreSQL site will provide ample information on the product for any reader to contrast. A few differences I found include MySQL’s row size, which peaks at 64 KB, whereas PostgreSQL’s extends to 1.6 TB. The former’s triggers fail to activate by cascading key actions. The latter’s on the other hand can be written in C and loaded as a library providing flexibility in pushing capabilities. The information page also includes links to testimonials and a list of awards spanning over a decade.
Our take: Is Oracle’s approach to MySQL giving some folks an added incentive to look at PostgreSQL?
Stephen E Arnold, February 10, 2011
Freebie
Comments
One Response to “Nexeo Embraces PostgreSQL”
-
- Subscribe to Beyond Search
Feature archive
News archive
-
[…] This post was mentioned on Twitter by Stephen E Arnold and ebarroca, Jean-Joseph THIBAULT. Jean-Joseph THIBAULT said: Nuxeo s'engage pour PostGreSQL : http://bit.ly/fieJPe […]