Database for local storage

Question

I am looking for a database which I can use to store data about certain stock over a number of years. There will probably be a few thousand records. I am writing an application in Java and Clojure which will pull out data from this local database when required to display the data.

I was wondering if anyone knew of a good database to work with for this purpose? I only have experience with MySQL running on the server side.

Which database would be easiest to work with in Clojure and Java for local storage?

Thanks,

Adam

Answer 1

JDK 6 and greater comes bundled with Java DB which good enough for your use case.

Answer 2

For this kind of small-scale application it will almost certainly be easiest if you pick one of the many good embedded Java databases.

My personal top choices would probably be:

• H2 - probably the best performance pure Java database overall, and if you believe their benchmarks then it is considerably faster than MySQL and indeed most other databases when run in a single machine environment.
• Apache Derby - good all rounder, mature and well supported (Oracle have included a version branded as Java DB in recent JDKs)

After that, you should be able to use them pretty easily using the standard JDBC toolset, so not much different from MySQL.

If you're after a really nice DSL for interfacing with SQL databases with Clojure, you should definitely also take a look at Korma.

Answer 3

I have used Apache Derby for a similar application (although written mostly in Java). They have been running it for almost four years now, and performed more than 60,000 transactions with it with no major problems. Only the occasional bug on my part.

Derby is the same database as JavaDB, however with Derby its easier to keep up on the releases as you can just include it as a dependency, rather than wait on the whim of when the next JDK rev is coming out.

Also, IIRC, JavaDB is only included with JDK, not the JRE.

Answer 4

Depending on the nature of your data and application and your willingness and/or constraints in working with a new database modality, you might also want to consider one of the document-oriented databases, MongoDB or CouchDB. If your data and application are SQL oriented, use one of the databases suggested.