Geek Answers Handbook

Database for local storage

I am looking for a database that I can use to store data on some stocks for several years. There will probably be several thousand records. I am writing a Java and Clojure application that pulls data from this local database if necessary to display data.

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

Which database is the easiest to work with in Clojure and Java for local storage?

Thanks,

Adam

+8
java database clojure local
source share
4 answers

JDK 6 and above comes bundled with Java DB , which is good enough for your use.

+13
source share

For such a small application, it will almost certainly be easiest if you choose one of the many good Java built-in databases .

My personal options are likely to be:

After that, you can easily use them with the standard JDBC toolkit, so it is not much different from MySQL.

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

+3
source share

I used Apache Derby for a similar application (although it is written mainly in Java). They have been launching it for almost four years and are carrying out more than 60,000 transactions with it without serious problems. Only a random mistake on my part.

Derby is the same database as JavaDB, but Derby is easier to track releases since you can just include it in a dependency rather than wait on a whim for the next JDK rev.

In addition, IIRC, JavaDB is only included in the JDK, not the JRE.

+3
source share

Depending on the nature of your data and applications, as well as your desires and / or limitations when working with the new database, you can also consider one of the documented databases MongoDB or CouchDB. If your data and applications are SQL-oriented, use one of the suggested databases.

+2
source share

More articles:


All Articles