PDA

View Full Version : Slimserver Database Question



jonheal
2008-02-13, 10:58
Please forgive a ludite, as I am still using version 6.3.1 and am completely content, but ...

I've been working on querying the database to build a list of our music for our web site.

We have quite a bit of classical music, but it seems that data from the "band/orchestra" or "album artist" tags does not appear in the SQLite database. Where is Slimserver grabbing this info when it displays it on the web interface?

funkstar
2008-02-13, 13:38
If it doesn't appear in the DB then it must be getting pulled directly from the file when listing the details of that track.

jonheal
2008-02-13, 16:32
I'm working around the problem by adding orchestra information in the "Comments" tag, which also appears in the "albums" table.

ceejay
2008-02-13, 16:52
6.3.1 was a long time ago and the rest of us have moved over to MySql ... but I'd have thought that the table structure might have been similar: have you looked for a "Contributor" table? AFAIK Conductor and AlbumArtist appear as Contributors, with an attribute that tells you what kind of contributor they are.

HTH
Ceejay

jonheal
2008-02-13, 18:05
6.3.1 was a long time ago and the rest of us have moved over to MySql ... but I'd have thought that the table structure might have been similar: have you looked for a "Contributor" table? AFAIK Conductor and AlbumArtist appear as Contributors, with an attribute that tells you what kind of contributor they are.

HTH
Ceejay
My Contributors table contains items associated with three contributor "roles": in my case, items that correspond to the tags: artist, composer and conductor.

There is an option to include conductors and orchestras/bands in the Squeezebox's Artist menu, but I have not checked those options because they make the Artist menu too verbose.

If they were checked, Slimserver might add more data to the contributors table, but I'm not going to do it for the reason previously stated.

As it is, kluging the Comments tag will work fine for me, I think.

Yes, I realize I'm still in the dark ages, Slimerver-wise, but 6.3.1 is serving me well. No complaints.

Was the conflict between 6.5.x and anti-virus software ever resolved?

ceejay
2008-02-14, 01:16
So, do you actually have BAND and ALBUM ARTIST tags in your files, and is Slimserver ignoring them? If that's your problem you might need to say more about the files types, and the exact tag names you are using. For example, in FLAC afaik ORCHESTRA is not recognised - it has to be "BAND" (thats the subject of an enhancement request I raised a long time ago). And I seem to recall there being something about "ALBUM ARTIST" vs "ALBUMARTIST", but I could be wrong.

You shouldn't need to check the "include ... in artists" boxes just to have the tags scanned.

As for the virus scanning problem, IIRC that was a problem with McAfee blocking Slimserver from the MySql database, which was easily resolvable by telling McAfee to ignore database files. Or are you thinking of something else?

Anyway, 6.5 itself will soon be history, we're about to move on to 7.0. So if I were you I'd hold off a little longer and then try it out - you might be surprised by how much has changed for the better.

HTH

jonheal
2008-02-14, 08:05
So, do you actually have BAND and ALBUM ARTIST tags in your files, and is Slimserver ignoring them? If that's your problem you might need to say more about the files types, and the exact tag names you are using. For example, in FLAC afaik ORCHESTRA is not recognised - it has to be "BAND" (thats the subject of an enhancement request I raised a long time ago). And I seem to recall there being something about "ALBUM ARTIST" vs "ALBUMARTIST", but I could be wrong.

You shouldn't need to check the "include ... in artists" boxes just to have the tags scanned.

As for the virus scanning problem, IIRC that was a problem with McAfee blocking Slimserver from the MySql database, which was easily resolvable by telling McAfee to ignore database files. Or are you thinking of something else?

Anyway, 6.5 itself will soon be history, we're about to move on to 7.0. So if I were you I'd hold off a little longer and then try it out - you might be surprised by how much has changed for the better.

HTH
The main reason I haven't upgraded is that I put together a considerable amount of scripting to link what is going on with the Squeezebox to our web site and I also modified the Perl of a plug-in I use.

It looked like upgrading would require much gutting of code, and I just wasn't in the mood after all of the effort it took to get things working in the first place.

So I'll stick with obsolescence for a bit longer.

I'll post a link to my music listing for the morbidly curious if and when I get it working.

jonheal
2008-02-23, 06:49
The main reason I haven't upgraded is that I put together a considerable amount of scripting to link what is going on with the Squeezebox to our web site and I also modified the Perl of a plug-in I use.

It looked like upgrading would require much gutting of code, and I just wasn't in the mood after all of the effort it took to get things working in the first place.

So I'll stick with obsolescence for a bit longer.

I'll post a link to my music listing for the morbidly curious if and when I get it working.

I managed to build "live" listings of our music on our web site by querying Slimserver's database. Listing the FLAC albums the way I wanted was pretty challenging and required adding numerous views to the database.

I wrote about the project here:
http://www.theheals.org/jon/more_from_slimserver_1.asp

... and the listings can be veiwed here:
http://www.theheals.org/miscellanea/sights_sounds.asp