Recover HSQLDB file/directory structure

[switz]

My hard drives crashed but I was able to recover most of the data, albeit very unstructured.

I have backups of my subsonic database (binary file) and was hoping I could use it to get a listing of my directories/files (either by filename or hash). I could then write a quick script to map the files to their proper locations.

But I'm on a mac and I'm having trouble getting SQL access to the subsonic database to inspect the schema and write a query. I can access the SQL interface via the web UI but it crashes on any substantial query (file is > 200 MB, a few TB of tracks).

If I could convert the hsqldb file to a postgres database my life would be a heck of a lot easier. Anyone have any ideas?