Slashdot Mirror

Derby is slow, but there are other open source Java databases: H2, and HSQLDB.

If I am reading the information correctly, this will be the new db: http://hsqldb.org/

1. He suggests SQLite instead of BDB. Which means that the system must have native APIs exposed.

2. He mentions that BDB's "library-based archtecture" is a problem for said platforms. This denotes that he statically compiles SQLite on systems lacking dynamic libarary support.

3. Nowhere does he mention Java capabilities, such as the type you'd use to power an engine like HSQL. Instead he goes off into discussions about larger native engines like MySQL.

Argue all you want, but he was referring to non-Java platforms. As such, this version of BDB wouldn't be very useful. Also, while I haven't checked out the code yet, it's even likely that it won't run on a J2ME device due to optimizations utilizing memory mapping and File Channels. This is a key optimization in the C version, so it's likely that the design has been moved over to take advantage of J5SE's NIO capabilities.

Readerware has everything you need - http://www.readerware.com/.

Scan the barcode of a book or enter the ISBN, it does the rest. If you scan by location, it can record that information too as you go. Runs on Linux, Mac even Windows.

It uses an open source database, http://hsqldb.org/. Don't think it works with MySQL, but you can export the data from Readerware.

oo.org base also has .odb format. using embedded hsqldb, i think.
http://dba.openoffice.org/miscellaneous/dba20.html
http://www.hsqldb.org/web/openoffice.html

or HSQLDB http://hsqldb.org/

hsqldb.org

I'm not sure if JDBC drivers are used for all external dbs, but probably.

The only thing in Java is HSQLDB (and, presumably, some trivial code to interface to it). So all you have to do is write a full-featured, file-backed, in process, SQL database in Python. Or you could write it in C++ and not require a language that OO doesn't already use.

(HSQLDB is a database that works a bit like MS Access, except that it works correctly, for cases where you want to have database files and send them to people in much the same way that you move spreadsheet files around, rather than use The Database Server with The Database on it. As far as I know, there aren't any other open source projects that do this.)

You forgot hsqldb.