Or maybe your nightly cron job would do
delete from playlist items where playlistid=154; insert into playlistitems ...
Ooh. Except I just noticed a full rescan deletes those. I’ll fix that for next nightly.
Ok, so it’s a semi-static playlist… then it’s no big difference than making a m3u-list…
What I was wishing for was a non-cron fully “automated” way to create sql queries.
Is it hard to implement some way where you could add the option to create a sql-query in the playlists-table ?
sqlite> insert into playlists (title,type,items,db_timestamp,idx,query) values ('Recent Adds',99,100,0,0, 'select xyz from abc');