10th March 2006 at 4:52 am #198
I have about 2,500 tracks, 98% of which are either rock, pop or alternative.
I have the following playlist:
genre includes “rock” OR genre includes “pop” OR genre includes “alt”
so this playlist should have 2,000+ tracks in it.
I’ve been playing this playlist on my SoundBridge using shuffle for the last few days (total of maybe 6-8 hours), however I keep hearing Queen’s Bohemian Rhapsody for some reason. Probably 5 or 6 times now. It also seems to play tracks from certain albums a lot as well.
OK, so I believe that the SoundBridge performs the shuffling, but how I can I found out how large this playlist is in terms of number of tracks? I want to work out if the playlist is not right or the SoundBridge shuffle doesn’t work properly (or how I expect)?
Post edited by: ajayre, at: 2006/03/09 20:5310th March 2006 at 7:56 am #4087
it’s in the playlists table, in the “items” column.
[email protected]:~$ sqlite3 /path/to/songs3.db
sqlite> select name, items from playlists;
Some other playlist|50
p.s. if you are using sqlite2, then it’s “sqlite /path/to/songs.db”10th March 2006 at 8:22 am #4088
I did the following:
sqlite> select title, items from playlists;
Music from Today|0
Rock, Pop and Alternative|0
90's and Later Rock|0
90's and Later Pop|0
90's and Later Alternative|0
which doesn’t appear to be right.
Andy10th March 2006 at 11:48 am #4089
It should update playlist counts when you connect. That’s really strange.
Try connecting with iTunes, then disconnecting. Then see if the total are updated.10th March 2006 at 12:19 pm #4090
Even with the SoundBridge connected and playing, and after turning off the SB, it shows the same result. Only two playlists have values and those are the iTunes xml playlists.
Andy10th March 2006 at 12:28 pm #4091
Dunno. Should be updating playlist item counts after every scan.
You can always enter that query manually:
select count(*) from songs where genre like ‘%rock%’ or genre like ‘%pop%’ or genre like ‘%alt%’10th March 2006 at 12:35 pm #4092
That worked, thanks. 🙂
Andy10th March 2006 at 12:47 pm #4093
If you have firefox or explorer, or a browser capable of displaying xml without a dtd (NOT safari), then you could also do something like:
then you’d see all your playlists, including the dmap.itemid of a playlist you wanted to inspect. Say the dmap.itemid was 307. To see what files are on that playlist, do:
and you’ll have a list of all your items, probably just with itemkind, itemid, and itemname. To see more interesting stuff, try something like this:
See, wouldn’t a nice ajaxian front-end on the web server be cool?
— Ron10th March 2006 at 12:55 pm #4094
Pretty nice. Can you use this interface to get things like play_count, bpm, etc?
Andy11th March 2006 at 1:10 pm #4095
You must be logged in to reply to this topic.