__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. {quote} NEW: we have now refactored the code and added support for external {link:MySQL|http://www.mysql.org} databases: see the [downloads and documentation|Software/net.loadbang-SQL/MySQL]. {quote} 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 {link:HSQLDB|http://www.hsqldb.org/}, 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. 1 Installation You will need: - Java 1.5. Under OS X, this may or may not be the default (it is now downloaded and made active as a system update under OS X 10.4.6). If not, it can be downloaded from {link:Apple|http://www.apple.com/support/downloads/java2se50release1.html}. (This appears to be Release 1; a System Update should upgrade it to Release 4.) - HSQLDB itself. This can be {link:downloaded from SourceForge|http://sourceforge.net/project/showfiles.php?group_id=23316}, and we also have a copy of the JAR here, for convenience: {link:hsqldb-1.8.0.jar|/download/hsqldb-1.8.0.jar}. - log4j: this can be {link:downloaded from the Apache site|http://logging.apache.org/log4j/docs/download.html}, and we also have a copy of the JAR here: {link:log4j-1.2.12.jar|/download/log4j-1.2.12.jar}. - The [Software/net.loadbang-lib] library, available here: {link:net.loadbang-lib-1.0.jar|/download/net.loadbang-lib-1.0.jar}. - The ~~net.loadbang-SQL~~ library itself: {link:net.loadbang-SQL-1.4.jar|/download/net.loadbang-SQL-1.4.jar}. This contains a test MXJ object called {link:NoddySQL|/javadoc/net.loadbang-SQL/net/loadbang/sql/mxj/NoddySQL.html}. 1 Usage Make sure that MXJ is using Java 1.5. If this is not the default, put the statement {code} max.java.jvm.version 1.5 {code} into the file ~~max.java.config.txt~~ in the ~~Cycling '74/java~~ folder. 1 Testing To test out the ~~NoddySQL~~ MXJ object, download the patcher file and its associated place-holder: {link:NoddySQL.zip|/download/NoddySQL.zip}. 1 Documentation Javadoc: browse {link:/javadoc/net.loadbang-SQL/}, or download {link:/javadoc/net.loadbang-SQL.zip}. 2007-04-14 21:37:54.723 2006-03-01 13:54:08.192