Playlists location?

[gberg]

Where are playlists stored on a Ubuntu Subsonic installation?
In the config file /var/subsonic/subsonic.properties I see this line: PlaylistFolder=/var/playlists, but there are no playlist files i that folder?

[acroyear]

they're in the database.

using /db.view

select * from playlist
gets you the playlist id

select * from playlist_file where id = 3
gets you the songs (in order) for the playlist - those are 'media_file_id'

join that to media file
select * from playlist_file pf, media_file mf where pf.playlist_id = 3 and pf.media_file_id = mf.id

and there's your contents

[gberg]

Ok, thanks!
But what's the line: PlaylistFolder=/var/playlists for then?

[acroyear]

legacy. i think it was how playlists used to be managed in an earlier version.

[Jägs]

But what's the line: PlaylistFolder=/var/playlists for then?

It's also where Subsonic looks for playlists to import (by default).