Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From: Cecil Westerhof <Cecil@decebal.nl>
Newsgroups: comp.lang.java.help
Subject: Which database to use
Date: Thu, 16 Feb 2012 23:51:14 +0100
Organization: Decebal Computing
Lines: 19
Message-ID: <87mx8io0il.fsf@Compaq.site>
NNTP-Posting-Host: lYLrXPFpjyZ8237ODaoN+w.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@aioe.org
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.3 (gnu/linux)
X-Notice: Filtered by postfilter v. 0.8.2
Cancel-Lock: sha1:d7SKVjRzbYnywAIld93IS6968F8=
X-Homepage: http://www.decebal.nl/
Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.help:1573

I am thinking about writing a desktop application in Java. First I
wanted to use SQLite and truecrypt. (Truecrypt because it will be
installed on an USB stick.) I was thinking about SQLite, because the
data can be accessed with other languages also.

Then I found out that Derby has the possibility to encrypt the
database. That would remove the necessity for truecrypt. I would lose
the (easy) way to access the information with other languages, but the
simplifying made this a good idea.

Now I saw two other Java DB's: H2 and HSQLDB. It is said that the
performance of Derby is bad and that H2 would be a far better
solution. What are the pro's and the cons of the different
possibilities?

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof