now wot...?

For those of you who wished for a 'user-friendly' graphical interface for a HyperSQL database, your wait is over! OpenOffice.org Base is the preferred graphical environment for a HyperSQL database as OOo actually utilises HyperSQL as its embedded database engine. Here's what you'll need: A HyperSQL database server. You can download HyperSQL from here: http://sourceforge.net/projects/hsqldb/files/ OpenOffice.org Base. You can download the full OpenOffice.org suite from here: http://download.openoffice.org/   And here's how to get it up and running: 1. Extract the downloaded HyperSQL bundle to a location on your local machine, e.g. C:\hsqldb-1.8.0.10 [optional]: Add the following entries to your system environment variables: name: HSQLDB_HOME value: <path to your HyperSQL installation, e.g. C:\hsqldb-1.8.0.10> name: PATH value: ;%HSQLDB_HOME%\lib; Note: This value should be added to your existing PATH value! 2. Install OpenOffice.org. 3. Confi...

HyperSQL is a terrific lightweight Java database solution that can be embedded to applications. This post outlines a couple of simple scripts for safely starting / stopping a HyperSQL database server instance (hosting one or more individual databases). It also avoids the need to have the main HyperSQL jar file sitting alongside your database files. In the examples below, I'm configuring a local database instance called ' resdb '. You’ll need to configure three files: a start-up script called: start_hsqldb_server.bat a connection properties file called sqltool.rc a shutdown script called stop_hsqldb_server.bat The start-up script looks like this: #REM start_hsqldb_server.bat @echo off set HSQLDB_LIB= <path to hsqldb library> set DB_FILE=<path to your database .script file [minus the .script part]> set DB_ALIAS=<database alias name> start "HSQLDB Server" java -cp "%HSQLDB_LIB%" org.hsqldb.Server -database.0 file:"%DB_F...

Well, I must admit it hasn't been a very good start, looks like those 'good intentions' only lasted one post :-) Although, In my defence I have been quite busy and/or stressed over the last few weeks. This post finds me relocated to Melbourne ( Ivanhoe to be exact) on my own (more on that in a minute) and somewhat settled into my new position with Company A. I will endeavour catch up with recent events in some subsequent posts on “ Saying Goodbye to Nine Years ”, “ Surviving On-Road Boredom ”, “ An Entrance Guide to Melbourne, VIC ” and “ Newbie Paranoia ”; but I just wanted to slip this note in first. Yes, unfortunately I’ve made the move to Melbourne ahead of my family. At the moment we’re still waiting to sell our house before we’re able to completely relocate everyone to Victoria. This obviously puts a bit of stress on everyone, particularly my wife how has to take care of four children on her own (fortunately she’s a very resourceful person! :-) ).  Remote communi...