1
3rd Party Plugins - (fb2k) / Re: [fb2k v2] SQLite Utilities (foo_sqlite)
Last post by regor -XSP playlists were never meant to be as powerful as SQL nor Autoplaylists. They are a format used by Kodi, which I support to:Well, just to be clear, what I'm thinking of is not to create F2k standard autoplaylists (I know those only work with standard library queries) but rather to automatically fill regular playlists based on SQL queries, without explicit user interaction. The main obstacle I can think of here is the question of how to schedule playlist updates. I don't know how autoplaylists update their contents, and I don't know whether those triggers are also exposed to components, or whether that would even be practical given the performance limitations of SQL requests.But exactly your request is present on my playlist manager, in "Smart Playlists", and they are updated on real time whenever the source changes. In this case they use other playlists as source, and apply a query on them. Such special playlist may also be locked by the component, so it can only be changed by it, whether on demand or by any callback.
Oh, I wasn't sure what they do, but I read something in the release notes about support for foo_sqlite stuff. So I guess that's what they're for. I'll take a look in the docs.
Hmm I looked at the docs and it doesn't seem like XSP queries as described there are nearly as powerful as SQL queries. I'm mainly using SQL queries for contextual queries, i.e. using the "OVER" operator to get statistical max(), min(), sum() etc. values from previously defined sets of tracks (especially artists and albums). Apart from the ability of XSP to use playlists as pools (which would require me to generate absurd numbers of playlists) it doesn't sound like smart playlists can do that sort of stuff. Is there another way to dynamically generate pools independently of playlists, analogously to partitions in SQL? Is there a more extensive documentation of XSP queries somewhere that I can refer to?
1. Provide direct translation between simple AutoPlaylists and Kodi systems.
2. Have an "AutoPlaylist" which can use other playlists as sources (#PLAYLIST# IS blabla).
That's all. And they were just a example of how a playlist in UI can be bound to arbitrary code and be updated with some callbacks or conditions (your request). You have full documentation on the readme PDF, which also links to kodi wikis.
Anyway, as I said, what you want has nothing to do with any kind of -existing- playlist. You want SQL and you want auto-updating of playlists by some triggers, and this is the component you need. Another thing is if your request is ever implemented.
Spoiler (click to show/hide)