reinholdk wrote: > Never looked to the artwork.db, but for the tracks table in the > library.db the columns are like this (LMS 7.8): > -cover column: contains the full file path to the cover > -coverid column: can be used to retrieve the cover from LMS using a url > like <lms ip>:9000/music/<coverid>/cover. Thanks very much.
On my 7.9 system cover contains just a plain number, not a path, so I don't know what that means. I now understand that the coverid can be used dynamically to get a cover from LMS, and I've tried it in a browser. However, what I'd really like to do is get the artwork from the database if that is at all feasible, since LMS may not be running or available when I'm looking at my derived database. I take a copy of the LMS databases, library.db, persist.db and artwork.db, dump them and then load them into one sqlite database so that I can analyse them all in one place using odbc and Libreoffice BASE. LMS 7.9 on VortexBox Midi box, Xubuntu 14.04, FLACs 16->24 bit, 44.1->192kbps. LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (to 405/2 amp & ESLs) & Marantz CR603 UPnP renderers. Alternatively Minimserver & Upplay to same & to upmpdcli/mpd PC renderers. Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones. Wireless Xubuntu 15.10 laptop firefox/upplay or Android 'phone with Squeeze-Commander/BubbleUPnP controls LMS/Minimserver. Also a Touch with EDO, plus spare, unused. ------------------------------------------------------------------------ PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=104800 _______________________________________________ Squeezecenter mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/squeezecenter
