11
3rd Party Plugins - (fb2k) / Re: [fb2k v2] SQLite Utilities (foo_sqlite)
Last post by dpc666 -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?
