Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Derby and HSQLDB

 
Gregg Bolinger
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've worked with both. They seem about the same to me. Anyone have a preference and why?
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic