I need a database for a standalone Java desktop application. Can anyone make any recommendations:
For now I have two options which I am considering, they are:
1. Hypersonic SQL
2. Java DB (from Sun)
Any ideas, am I on track with these options or should I look at something else?
Looking forward to hearing some thoughts on this.
SCJP 1.4, SCWCD 1.4
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."
- Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999
Those two are the ones worth checking out if you need an embedded SQL database. Derby (a.k.a. Java DB) is the high-end option, but HSQLDB is very capable as well; I'd probably go with it unless (and until) I ran into some limitation.
I also like SQLite quite well. It has Java drivers, and that way don't need SQLite itself. Just like HSQLDB, your database can be in-memory only, or in a file. HSQLDB is more powerful though, as it also can run in server mode.