Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 4 of 4
  1. #1

    Playlists - How and where are they stored?

    I created a static playlist some time ago. Afterwards I retagged several audio files and rescanned the database. The playlist is still complete and I can listen to all songs.
    However I saw that some songs don't show a rating when the playlist is played though they have a rating, which is shown, when I look up and play the album.

    So I did some further investigations and looked into the database (playlist_track table) as described here: https://wiki.slimdevices.com/index.p...playlist_track
    Strangely enough I don't see these files when I run the SQL query: select * from tracks t join playlist_track pt on pt.playlist = <playlist ID> and pt.track = t.url

    So my question is from where does LMS retrieves the "complete" playlist as the database - in the playlist_track table - only contains part of the songs of the playlist.

    Does this make sense? (It doesn't make sense for me ...)

  2. #2
    Senior Member w3wilkes's Avatar
    Join Date
    Jan 2009
    Location
    Utah, USA
    Posts
    1,672
    It's in your Basic Settings in the Material Skin... Settings -> Server and you're now in basic Settings. You should see an entry towards the bottom of the page that defines the directory to your playlists.
    Main system - Rock Solid with LMS 8.2.1 on WHS 2011 - 2 Duets ( both WiFi, farthest unit gets 60% signal strength and always works since new power supply) and Squeeseslave
    Cabin system - Rock solid with LMS 8.2.1 on Win10 Pro - 1 RPi 3 Model B (WiFi) /Hifiberry DAC+ Pro/PiCorePlayer and Squeezeslave
    Squeezebox Boom - "At Large" player around both home and cabin
    Headphones and car - Android phone/Bluetooth w/full library on MicroSD card - PowerAmp music player app (similar to Material Skin)

  3. #3
    Thanks w3wilkes!

    I thought that these source of truth is in the DB and the playlist directory is only used as a backup or to import playlists.

    So I found the playlist and found that the songs which don't have a rating don't show the path but an "url": tmp:///mnt/music/Library/STU/Slowdive/Just%20For%20A%20Day/... instead of /mnt/music/Library/STU/Slowdive/Just For A Day/....
    Any idea why this has happened? The path of the track hasn't changed.

    The other question is when is the DB (playlist_track table) updated and what is it's purpose when the ultimate source of truth is the playlist stored on the file system?

  4. #4
    Senior Member
    Join Date
    Aug 2012
    Location
    Austria
    Posts
    1,282
    Quote Originally Posted by allwi View Post
    I thought that these source of truth is in the DB and the playlist directory is only used as a backup or to import playlists.

    So I found the playlist and found that the songs which don't have a rating don't show the path but an "url": tmp:///mnt/music/Library/STU/Slowdive/Just%20For%20A%20Day/... instead of /mnt/music/Library/STU/Slowdive/Just For A Day/....
    Any idea why this has happened? The path of the track hasn't changed.

    The other question is when is the DB (playlist_track table) updated and what is it's purpose when the ultimate source of truth is the playlist stored on the file system?
    The DB is the source of truth. It gets updated by re-scanning the playlists.
    tmp:// indicates a volatile track which "allow[s] files to be played without being stored in the database. This can be used to eg. browse music folder while a scan is running, or play files from removable media."
    Ratings are stored in a different DB than tracks. They are matched by the track URL. If the rating is for "file://<path>", then "tmp://<path>" will not be found.
    Various SW: Web Interface | Text Interface | Playlist Editor / Generator | Music Classification | Similar Music | Announce | EventTrigger | Ambient Noise Mixer | DB Optimizer | Image Enhancer | Chiptunes | LMSlib2go | ...
    Various HowTos: build a self-contained LMS | Bluetooth/ALSA | Control LMS with any device | ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •