open-source utilities and extras for Max/MSP
[ start | index | login ]
start > Software > net.loadbang-SQL

net.loadbang-SQL

Created by nick. Last edited by nick, 7 years and 111 days ago. Viewed 10,061 times. #13
[diff] [history] [edit] [rdf]
labels
attachments
net.loadbang-SQL is an interface package for embedding an SQL database entirely within MXJ. There is no need to run a separate database server. The database content is stored in files which are automatically maintained in Max/MSP's search path - there is no configuration needed, apart from a single "place-holder" file in the search path which is used as an anchor.

NEW: we have now refactored the code and added support for external >>MySQL databases: see the downloads and documentation.

When a database is first created, HSQLDB creates a small set of files on disk to store the database settings and data. The MXJ object makes sure these files get saved to the same directory as the place-holder file. (So, the entire database state is kept in files in the Max/MSP search path.) Assuming that these database files and the place-holder file are kept together, the database will persist indefinitely; every time a new MXJ object is created naming that place-holder file, the database will reappear.

The database system is >>HSQLDB, which is a lightweight database engine written entirely in Java. It can be run in embedded mode, which is why a separate database server is not needed. (So, applications built with Max/MSP can contain a relational database and still be standalone.)

By default, databases are held entirely in RAM, and are saved to disk as files of SQL queries. For more demanding work, HSQLDB can adopt different caching and storage schemes.

Because HSQLDB is written in Java, this package runs under both OS X and Windows.

Installation

You will need:

Usage

Make sure that MXJ is using Java 1.5. If this is not the default, put the statement

max.java.jvm.version 1.5

into the file max.java.config.txt in the Cycling '74/java folder.

Testing

To test out the NoddySQL MXJ object, download the patcher file and its associated place-holder: >>NoddySQL.zip.

Documentation

Javadoc: browse >>/javadoc/net.loadbang-SQL/, or download >>/javadoc/net.loadbang-SQL.zip.

no comments | post comment



< August 2014 >
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
31

XHTML 1.0 validated
CSS validated
RSS 2.0 validated
RSS Feed

Contact: Nick Rothwell

Powered by SnipSnap 1.0b3-uttoxeter

Open Source Java and UI Software for MaxMSP

ff194

The fireflash spanning router for the >>monome.

shado-small

The shado compositing and sprite library for the >>monome.


jython-logo

The Python programming language embedded in MaxMSP/MXJ


groovy-50

The Groovy programming language embedded in MaxMSP


small_powered_by

A Jetty-based embedded web server for MaxMSP, with JSP support


hsqldb

SQL database support, using HSQL or Apache Derby (embedded), or MySQL


nixie

Nixie tubes for Max


buttonsx

Rotating, alignable, colourable, assignable, pattr-aware arrays of text


Legacy Software

snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt