Re: Derby vs HSQLDB

hilz wrote:
Hi all...
There are those two 100% Java databases, Derby and HSQLDB.

I want to use one of them for a small web project...

does anyone have experience with both and can give recommendations about which one to pick?

thanks


I think that either will do the job for you. For what it's worth, HSQLDB is the db of choice in the Open Office software suite. Derby, however, is supported by IBM and Sun Microsystems, and is embedded in Sun's application servers.

I wrote an article about Derby embedded in desktop applications here:
http://java.sun.com/developer/technicalArticles/J2SE/Desktop/javadb/

I hope you find it helpful in evaluating Derby. The same principles apply to embedding this into a web project in which Derby is embedded in the server application.

Regards,
John O'Conner
.

Relevant Pages

  • Re: hsqldb vs. derby
    ... support a java DB either hsqldb or derby. ... I used hsqldb as memory-only db, and there, inserts and _simple_ queries ... take derby and trust their optimizer. ...
    (comp.lang.java.databases)
  • Re: Postgre oder MySQL
    ... dass HSQLDB viel zu wenig Features hat. ... Und wenn ich dann an das Ablegen einer DB als Textfile denke .... ... Ich glaube Derby iss um längen besser ... ... Sobald es um komplexe Anfragen auf großen Datenmengen geht, ist Derby ...
    (de.comp.lang.java)
  • Re: hsqldb vs. derby
    ... support a java DB either hsqldb or derby. ... I used hsqldb as memory-only db, and there, inserts and _simple_ queries ... take derby and trust their optimizer. ...
    (comp.lang.java.databases)
  • Derby vs HSQLDB
    ... There are those two 100% Java databases, Derby and HSQLDB. ... does anyone have experience with both and can give recommendations about which one to pick? ...
    (comp.lang.java.databases)