2019-05-13, 16:32
One of my biggest pain points with kodi is, that there does not seem to be a performant "next episode" widget. There is of course the script.skin.helper.widgets and it works and I am very grateful that it exists, but for some reason (and my python is really not good enough yet to understand why) it is very slow. I have a mysql setup with ~ 7.500 episodes and it sometimes takes the widget more than 1 minute (form start of kodi), sometimes even more, to populate the widget (which is not bad, but it is simply not "nice" to watch the wait animation for a minute instead of watching the next episode).
I realize that the following sql does not sort by last seen shows, like script.skin.helper.widgets (which is very nice to have, but no "must) but with this quick select
"SELECT strFileName, MIN(c12), MIN(c13) FROM episode_view WHERE episode_view.playCount IS NULL and c12 <> 0 GROUP BY idShow" I have results in 0.094 seconds. Also plex, emby & co have this list for me in instantaneaously.
For people that watch more than one show at the same time such a widget is a "must" in my opinion and - again - although I am very grateful for marcelveldt's work !! - I think a native and perfromant widget would be very, very great.
If there is already something like this, please point me in the right direction...
I realize that the following sql does not sort by last seen shows, like script.skin.helper.widgets (which is very nice to have, but no "must) but with this quick select
"SELECT strFileName, MIN(c12), MIN(c13) FROM episode_view WHERE episode_view.playCount IS NULL and c12 <> 0 GROUP BY idShow" I have results in 0.094 seconds. Also plex, emby & co have this list for me in instantaneaously.
For people that watch more than one show at the same time such a widget is a "must" in my opinion and - again - although I am very grateful for marcelveldt's work !! - I think a native and perfromant widget would be very, very great.
If there is already something like this, please point me in the right direction...