Database persistence without an SQL server

Question

I'm seeking a solution that would allow persistence without requiring an SQL server to be installed on the host and could be bundled along with a desktop application. Does such a thing exist?

Answer 1

You could use an embeddable database written in Java like Java DB (Sun's supported distribution of Apache Derby), HSQLDB, or H2 (by the creator of HSQLDB). H2 has my preference performance wise and features wise (some comparisons here, here and here) and because of the compatibility mode with other databases (very nice when H2 is not your target database but maybe irrelevant in your context).

Answer 2

I think you want something like SQLite (Java bindings) (a fast flat-file general purpose embeddable database).