[ended84]

Hi!

im in this situation right now i've got v18 on our XBOXone where we usually watch movies and new TV shows. We also have v17 on both my win10 PC and our RPi3 in the bedroom.

Did there end up being an addon or at least an SQL query I could plug my databases names in to so i can sync watch status across versions?

Although, now that i think about it, that query may be complicated depending on how your references work as IDs will be different  

Maybe i need one system to my the designated library updater and the have a simple query that replicates the ‘path’ and ‘file’ tables so all the IDs are the same...

[Klojum]

I've split your post from the thread you put it in, as it has really no link to the 'rant' in that other thread.

The solution for a centralized Kodi metadata library is via a MySQL database server. That will store all your metadata and the watch status and resume points for videos you watch. All connected Kodi devices will benefit from the centralized database.

Manual or automated replication of local database files from/to various Kodi clients is not a good idea.

[ponkotsu]

Also note that database versions differ between the different versions of Kodi, namely v17 and v18 in your case. Meaning, your XBOne's database will not be in sync with your PC and your RPi while the latter are on v17.

[ended84]

Also note that database versions differ between the different versions of Kodi, namely v17 and v18 in your case. Meaning, your XBOne's database will not be in sync with your PC and your RPi while the latter are on v17.

Yes, that is exactly my problem that I am dealing with. Been dealing with it since the release of the XBOX version.

I was wondering if anyone had written a SQL query that could sync between databases. I understand the risks. Just wanted to know if anyone had personnaly addressed this type of situation and was willing to share.

[Klojum]

Why not upgrade the Kodi versions on the PC and RPi3 devices? There are pretty stable v18 Beta builds available.

[scott967]

You might consider exporting your library and using advancedsettings to update watched/resume status on import on the other clients.

scott s.
.