Tags Database Conflicts in Multi-User-Tagging system
Posted: 07 Jan 2021 16:44
How to resolve sharedTags database conflicts in Multi-User-Tagging systems for remote users?
I work with a team of six and we are using the tags and comments which are saved to a sharedTags.dat in a OneDrive folder which all six of us have access too. The issue I am having is that onedrive can be slow to sync between two given users (lets call them A and B). If A updates a tag, depending on how busy the onedrive is, it can take up to 30 mins for the sharedTags.dat on B's computer to reflect the tag update. The 30 minute delay isn't the problem in itself, except that if B makes a change to the tags before his database has been updated, then the sharedTags.dat conflicts with A's (and oneDrive drops a copy of sharedTags-CONFLICT.dat into the folder, which obviously doesn't work).
What are some possible solutions which will allow us to avoid conflicts while having shared tags/comments on files and folders between 6 people who are working remotely?
My first thought was to have my tags sync through a MYSQL DB in AWS, but since that is a complex solution and might not work well either, I'm wondering if there's something simpler I may be missing.
I work with a team of six and we are using the tags and comments which are saved to a sharedTags.dat in a OneDrive folder which all six of us have access too. The issue I am having is that onedrive can be slow to sync between two given users (lets call them A and B). If A updates a tag, depending on how busy the onedrive is, it can take up to 30 mins for the sharedTags.dat on B's computer to reflect the tag update. The 30 minute delay isn't the problem in itself, except that if B makes a change to the tags before his database has been updated, then the sharedTags.dat conflicts with A's (and oneDrive drops a copy of sharedTags-CONFLICT.dat into the folder, which obviously doesn't work).
What are some possible solutions which will allow us to avoid conflicts while having shared tags/comments on files and folders between 6 people who are working remotely?
My first thought was to have my tags sync through a MYSQL DB in AWS, but since that is a complex solution and might not work well either, I'm wondering if there's something simpler I may be missing.