Quick glance at popular java databases in order to get a mock up - up and running
Java DB (Derby database) and HSQLDB seem to be the popular offline databases. HSQLDB is used by openoffice and can store up to 8GB of data on previous versions, and the one just released it s now up to 16GB. It's also under active development.
A good thing about this, is that the DB can be run both as a standalone server or within the same JVM as part of the installation. For dev work, we would use the server run settings, to connect up db tools, etc. But shipping it, we can start the DB "in-process", and therefore don't need to install anything at all - just distributing it with the rest of the Java app as a jar file. Also good, would mean that we could keep the same database to run a central repository too, as opposed to say have a central server running MySQL and clients running HSQLDB.
http://hsqldb.org/images/imola_retrieve.jpg
JavaDB i looked a little less at, but it's distributed with Java 1.6. (I was wondering if that complicates the way we distribute it - currently JSword runs on 1.4.2 I believe). It's also pretty good, but it seemed from some performance graphs indicated HSQLDB would be faster. This one is endorsed by Sun and therefore Oracle (i wonder if they'll continue supporting yet another database now that they've purchased Sun!). It's currently under active development.
I'll get a mock up down with HSQLDB first.
Let me know what all your thoughts are...
Chris
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment