I am trying to write a simple database application to manage my daily expenditure. To maximize the portability across different platforms, I planned to use Java to develop and would need a lightweight embed database engine.
Spending some time researching on the web, I may choose one of the followings to be the database back end:
- HSQLDB - the database engine used in OpenOffice.org 2.0.
- H2 Database Engine - another fast and reliable database engine, less well known but seems to have more features.
Another option is Apache Derby, but various reviews and benchmark tests on the web pointed out its relatively low performance to the other options. It would probably be my last choice.