I know realistically there are better options by going with shared mySQL library but i have some free cycles recently and have been playing around with my kodi instances.
I have two boxes both running Jarvis, (local SQlite DB). My goal is to only scan once, and have both libraries update.
what i tried first:
– make a copy of MyVideos99.db on Box A
– run a scan / library update
– run sqldiff on the copy and the after db
– use the code and have it execute on Box B (dnt worry about bookmarks and watch status for the sake of this question)
In theory that should do the job, but the problem is Kodi (jarvis) seems to do a lot to the DB behind the scenes; unique asset numbering, thumbnailing… So never mind the library update if i run a diff on a sqlite DB after being idle for a few hours there are big differences.
So my question is how do i separate the library query changes from the idle background kodi changes.
Is there a way to get just the library update query?
Thanks,