QOwnNotes icon indicating copy to clipboard operation
QOwnNotes copied to clipboard

Merging notes.sqlite in case of a sync conflict

Open pbek opened this issue 5 years ago • 4 comments

It would be great if the data of notes.sqlite could be merged in case of a sync conflict (if it was changed on two computers).

A complete merge would be very difficult. Maybe starting on more easy parts first.

  • [x] Checking if conflicted database file differs at all
  • [x] Delete conflicted copies of the note folder database notes.sqlite immediately if tags and tag assignments are not different to the ones from the current notes.sqlite
  • [x] Handling different database versions? (not needed, will be ignored)
  • [x] Merging trash table? (not needed, will be ignored)
  • [ ] Merging tags and tag assignments

pbek avatar Feb 13 '20 05:02 pbek

@dsamersoff, one for you

20.2.4

  • conflicted copies of the note folder database notes.sqlite are now immediately deleted if they are not different to the current notes.sqlite

pbek avatar Feb 13 '20 20:02 pbek

@dsamersoff, another one for you

20.2.8

  • conflicted copies of the note folder database notes.sqlite are now immediately deleted if tags and tag assignments are not different to the ones from the current notes.sqlite
    • all other table differences can be safely ignored

pbek avatar Feb 19 '20 16:02 pbek

There now is a new release, could you please test it and report if it works for you?

pbek avatar Feb 19 '20 16:02 pbek

I'll try to test it this week.

dsamersoff avatar Feb 19 '20 17:02 dsamersoff