Posts Tagged ‘Database’

The H2 Database engine now works with Raydo

Monday, November 5th, 2007

I have been doing a lot of work with Java. A lot of it in getting the     C++ and Java interfaces to align. So when I went looking for a database engine, I settled on H2 for the Java engine.

    Since you can run Raydo in an application, H2 can be run in an embedded mode, as well as HSQLDB and Derby. It can also be run as a client / server and a cluster.

The ‘plugin’ was added to the Java tree.
    So looking at the benchmarks, it seems that H2 is faster than HSQLDB & Derby in the embedded space, and comparable with Postgres and MySQL in the client/server space.

Install script

Sunday, October 14th, 2007

    I have added the first version of the install script. Only for POSIX type boxes ( Linux, OSX, HP-UX ) It is for the single box/instance version.

    The install script is for running the software on a single machine and using the SQLite database. You can run it as follows.

./install_single_sqlite.sh

SQLite database plugin

Wednesday, October 10th, 2007

    I have implemented sqlite as the first database plugin. It is not really a ‘plugin’ in the sense that you have to compile it in, but in the sense that it is a pluggable architecture. I am using a factory pattern as such., however I think that most users are going to pick a database and stick to it.