With apologies for being a bit slow. I have a long standing LMS system,
buit I don't quite get what the new DPL vs old DPL issues are.
I've read the FAQ and everything else I could find, but I don't really
understand what impact the new version will have on the dynamic play
lists I already have. These make extensive use of the database entries
created by custom scan and multilibrary. My use of LMS depends almost
completely on those database tables. I play almost exclusively
classical music, and 'works', so I have to use custom scan and browse,
and multilibrary. I did look at the Virtual Libraries but I failed to
understand how I could get it to work in a similar way to multilibrary.
I have several dozen queries that depend on the multilibrary database.
I don't understand what is meant by 'removes ties to other (unsupported)
plugins'. I see that it says that it may work with such plugins, but
I'm not sure what it means by 'ties'.
As an example dynamic sql (I have about 20), this one selects random
classical works (a series of movements/tracks) where one movement has a
top 'rating' of 90 or more. Will the new DPL at least initially still
work with this? Will it only fail if multilibrary or customscan fail to
create the database tables, or is there some deeper 'tie' that could
cause problems?
-- PlaylistName:Random Classical Top Rated Works
-- PlaylistGroups:Random
-- PlaylistOption Unlimited:1
create temporary table sqlplaylist_random_work as
select customscan_track_attributes.value as work, tracks.album as
album from customscan_track_attributes
join tracks on
customscan_track_attributes.track = tracks.id
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
join track_statistics on
tracks.url=track_statistics.url
and track_statistics.rating > 89
where
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='WORK' and
dynamicplaylist_history.id is null and
audio=1
group by customscan_track_attributes.value,
tracks.album
order by random()
limit 10;
select tracks.url from tracks
join customscan_track_attributes on tracks.id =
customscan_track_attributes.track
join sqlplaylist_random_work on tracks.album =
sqlplaylist_random_work.album
where sqlplaylist_random_work.work = customscan_track_attributes.value
and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='WORK' and
audio=1
group by tracks.id
order by tracks.album,tracks.disc,tracks.tracknum;
drop table sqlplaylist_random_work;
LMS 8.1 on PC, Xubuntu 20.04, FLACs 16->24 bit, 44.1->192kbps. 2
Touches & EDO.
LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (A308CR amp & ESLs) & Marantz
CR603 UPnP renderers.
Also Minimserver & Upplay to same & to upmpdcli/mpd PC renderers.
Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones.
Wireless Xubuntu 20.04 laptop firefox/upplay or Android mobile with
Squeeze-Ctrl/BubbleUPnP controls LMS/Minimserver.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=115501
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
