Database use

[p2ranger]

I'm curious what subsonic uses for the database. I see where it has a directory for it, but can't read what's inside. Is it a flat file db or is there a db server running with subsonic? I'm using the standalone version on linux.

I saw in another post where you can use the db.view file to query the database. I'm interested in trying to query the database for playcounts of individual files, not just the albums.

select * from music_file_info

Is there other ways to query the database besides just this web front? I'm considering writing a PHP script to query the database to pull out certain podcasts with 0 play_count and have it make a playlist file.

Thanks

Jason

[tacgnol]

I think subsonic uses an embedded HSQL database which means its only interface is probably JDBC. Thus I think accessing the data from PHP will probably be hard.

[p2ranger]

Thanks for the info. Yeah, I don't know anything about HSQL database nor JDBC.

Is there any way to get more information about the database? How to connect, the names of the tables, columns, etc.

Thanks

Jason