On Jul 12, 2011, at 5:02 AM, Ross Gardler wrote: > On 12 July 2011 01:46, Suresh Marru <[email protected]> wrote: > >> In any case, do folks have any practical experiences and preferences over >> any option? Just note that Airavata has more scalability and reliability >> requirements over performance. > > The only practical experience I have of Derby is as the default > database for Apache Wookie. As far as I am aware it has not been > tested at scale in this project, certainly I have not done so. > However, it is I that did the migration from MySQL to Derby and I > found it an easy process with no surprises around the corner. This is very good to hear. > In general I would recommend using an Apache project over another > third party project. Mainly because it's easier to be heard if we need > to engage with the project community. Over the coming years Airavata > contributors are almost certain to find themselves at the same events > as Derby contributors. Furthermore, even though merit does not > transfer from one ASF project to the next, it does send a strong > signal that you are a real open source contributor and thus are likely > to attract attention to your communications with the project (not that > Wookie has needed to engage with the Derby community in its use). + 1 for all of above.
I found interesting differences when I googled through. The third party comparisons widely varied and nothing conclusive [1][2][3]. As expected each of the database claimed its the best [4][5][6]. So I do not have any bias and Ross's and Lahiru's arguments are strong enough for me to pick Derby. Since I did not see any objections to Derby or other suggestions, I will not call for a vote. I will create JIRA tickets for this porting. Suresh [1] - http://www.encorewiki.org/display/encore/Open+Source+Databases+Comparison [2] - http://database-management-systems.findthebest.com/compare/6-15-16/Apache-Derby-vs-HSQLDB-vs-H2 [3] - http://www.sukhvinder.co.uk/articles/design-concepts/database-comparison-table-h2-hsqldb-derby-postgresql-mysql [4] - http://www.h2database.com/html/performance.html [5] - http://db.apache.org/ojb/docu/guides/performance.html [6] - http://hsqldb.org/images/imola_retrieve.jpg
