1
3rd Party Plugins - (fb2k) / Re: [fb2k v2] SQLite Utilities (foo_sqlite)
Last post by regor -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?XSP playlists were never meant to be as powerful as SQL nor Autoplaylists. They are a format used by Kodi, which I support 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. My replies were primarily mean for the developer. 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. For sure, I would appreciate it too.. since query syntax is pretty limited in some cases and there have been no updates on years.
Spoiler (click to show/hide)