I’ve been working on embedding the HSQL database inside a library for
MXJ. HSQLDB is 100% Java, and in its default mode is 100% plain file
based, so it’s pretty easy to wrap up and link in to Max’s search
path machinery. The result is a full SQL database with basically no
installation or configuration needed, and easy access to the data files.
It also seems to be robust. A couple of months ago I wrote an OSC
sequencer object, using SQL to timestamp and store all the data
(coming from some wearable computer gear which was putting out
messages at 10msec intervals). Load and cue time were not
inconsiderable on my TiBook, but it all held together. Worked fine on
Windows too (and the data files are portable).
The only actual MXJ object I have to release at the moment is
something which takes in full SQL statements and puts out result rows
as lists of Atoms; at some stage soon I want to rewrite the
cassiel.registry object to be SQL-based, and also put out some
example objects which do proper PreparedStatement JDBC (like the OSC
sequencer, although that’s a bit too complicated to serve as an
example).
Oh, and all this code should work, unmodified, on any forthcoming Max/
MSP running natively on an Intel Mac.
Info/download at: http://www.loadbang.net/space/Software/
net.loadbang-SQL
If there are any holes in the software or the documentation, please
let me know. I’ve not zipped up the sources yet – will do so when I
have a spare moment. Also, if you do use it and want to be kept
informed of updates, drop me a line.
I’m also keen to put together some more examples of utilities and
applications. Anyone got any ideas?
— N.
nick rothwell — composition, systems, performance — http://
www.cassiel.com