Finding a good and easy database alternative that doesn't require installation

Question

I did my homework (for example, you asked;)), but I did not find anything that really meets my needs, so here it is:

I am a junior Java developer and I am working on a small project. The problem I am facing is that I want to be able to store and retrieve data in a small database. I tried to use text files, but they can only store data or immediately extract all the data, and you can’t choose which data you want to receive. I am looking for an alternative that does not require any installation or anything else, because I do not want my "costumer" to download anything else other than my application. I tried HSQLDB, but it needs some installation ...

So here is my question: is there any alternative for a database for Java that does not need any installation And where can I select and extract any data I need?

Answer 1

You can use SQLite and SQLite JDBC Adapter .

Answer 2

Apache derby is part of JDK 6 onwards. You can use this.

It is called Java DB and added to the JDK.

If you go to JAVA_HOME/db , you can find the installation.

Answer 3

You can use Microsoft Access. If you have Microsoft Office installed on your computer (assuming you use Windows), Microsoft Access may also have been installed. Just check it if it already exists, and if it is, then it is useful to start programming related to data in java using MS Access.

Answer 4

Have you seen Lucene ? This is like a database in which you can query your list of “documents” (sets of key-value pairs) in a number of nice complex ways. It is also very fast.