Direct Access to Database

[Nuggets]

This is quite convoluted but I will do my best to explain. Please ask any questions necessary.

First off, I would like to say that I love Subsonic! It's absolutely wonderful.

Before this goes anywhere I would like to note that I do know of the API and how to use it, but because of the way this will work I am asking to see if it can be done a different way.

I am in the early stages of building a "web application" based on the server portion of Subsonic. I am looking to use the information used in the database that Subsonic runs on. That is, the portion that holds all of the artist, album, and track info.

I would like the use that information as well as adding additional information to it. Subsonic uses HSQLDB as its database back-end. I have looked both in the db.view page and at trying to actually read the database on the server itself. Both of which have come to no avail. I have attempted to use the HSQLDB library itself along with the MySQL Migration toolkit.

Of course the ideal situation would be to have Subsonic utilize MySQL as a database back-end and modify the database and insert additional data as needed. I don't see this happening but I don't know what Sindre's plans are.

My question is this; How can I gain access to the data in the database directly either through migrating it to MySQL or just dumping the database to a file. I know this may sound vague but it is a rather simple request, but it seems out of my reach.

I would like to note that I am not entirely fluent with SQL or ODBC drivers. If it can be done and I have simply made a mistake please inform me.

Thank you for your help.