Derby and HSQLDB

[Gregg Bolinger]

I've worked with both. They seem about the same to me. Anyone have a preference and why?

[David O'Meara]

I've only used HSQLDB, and I've found it 'good enough'. I'd never look at doing anythiong with it other than running basic tests or demo versions, so my requirements are pretty small.

[stu derby]

Originally posted by Gregg Bolinger:
I've worked with both. They seem about the same to me. Anyone have a preference and why?

How can there be any question? With that name, it's obvious that the Apache product is superior...

But seriously, I asked a trusted co-worker with serious experience with both; his opinion was that HSQLDB was better for small-footprint applications (e.g. embedded in a cellphone app or small part of a J2EE app), and Derby was the better choice as a desktop engine for most purposes. He mentioned that the version he worked with (prior to the most recent 10.1.1.0 release) had some small db2-like issues that were non-standard, but he didn't explain what those were.

[Nitin Agarwal]

Hi derby,

I m using Hypersonic DB with Java. I have created database. Now i want to create Stored Procedure. Is Hypersonic supports User defined Stored Procedure ? Because when i use command like "create procedure ....." then it gives error "unexpected token PROCEDURE". So please tell me how to create Stored Procedure in Hypersonic DB. If it does not support then please tell me alternative of it.

Thanks
Nitin

[David O'Meara]

Nitin,
You will have a better chance of a response if you create a new thread for your question since it is not directly associated with the current conversation.

Dave

[Gregg Bolinger]

Sorry for the late response. I appreciate the tips. I recently used Derby in a small utility at work and that is why I asked the question. I find datbases like Derby and HSQLDB useful for application where you would normally need to write information to a log file and then need to analize that log file later. It is much simpler to write SQL queries to obtain that data.

I wonder if anyone has compared the build in functions available in both databases and noticed one or the other have more/better options?

[steve souza]

This would be a good question to post at the hsqldb forum and also at the derby forum. The hsqldb forum is here:

http://sourceforge.net/forum/forum.php?forum_id=73674

One item I saw in there mentioned HSQLDB being faster that cloudscape though I haven't compared.
<<HSQLDB is the best java embedded database I have found, far better performance than derby/cloudscape, both when inserting and querying.>>

I use an in memory hsqdldb database for a live demo I have at www.fdsapi.com and have been happy with it, though I hardly stress the database.