SC database model

[sand]

I am interested in what info there is in the SC database and how it is stored, so that I can write cool SQL queries..
Is there a database model somewhere?

[peter]

sand wrote:
> I am interested in what info there is in the SC database and how it is
> stored, so that I can write cool SQL queries..
> Is there a database model somewhere?
>

This is a good start:

mysqldump -d -h127.0.0.1 -P9092 slimserver

Regards,
Peter

[SuperQ]

I am interested in what info there is in the SC database and how it is stored, so that I can write cool SQL queries..
Is there a database model somewhere?

Yes, in the Squeezecenter package there is a schema file: MySQL/system.sql

[MrSinatra]

be aware, 7.3, which is due sometime this year, is supposed to sport a totally new DB model.