Is collaborative edit possible (assume there is no simultaneous edit at the same time)?

zadam / trilium

Build your personal knowledge base with Trilium Notes

GNU Affero General Public License v3.0

26.74k stars 1.86k forks source link

Is collaborative edit possible (assume there is no simultaneous edit at the same time)? #1436

Closed hysci closed 3 years ago

hysci commented 3 years ago

I still didn't find a good way to sync local notes among different devices: Mac PC1, Windows PC2, Linux Server, etc. (Refer to issue: https://github.com/zadam/trilium/issues/1420)

Is it practical to sync "trilium-data" and "Trilium Notes" folder on the cloud (e.g., owncloud/nextcloud)? Is the config/DB compatible with cross-platform? Is it safe to do so in case that SQLite DB is a single file? There could be a potential issue that the conflict can't be resolved if I edit one page on one PC and edit another page on another PC unless I do a full synchronization before a new change.

tmaleshafske commented 3 years ago

@hysci That is what I am currently doing since I was having issues with sync. The biggest issue I am having with this is remembering to close down instances to avoid conflict. You will not be able to have multiple instances pulling from the same document.db The other thing you have to do is set a system variable for Trillium to the correct directory with each individual instance. Instructions on this are located here

zadam commented 3 years ago

Is the config/DB compatible with cross-platform?

Yes.

Is it safe to do so in case that SQLite DB is a single file? There could be a potential issue that the conflict can't be resolved if I edit one page on one PC and edit another page on another PC unless I do a full synchronization before a new change.

That's a problem and you need to be very careful in your usage (as @tmaleshafske ). In general I do not recommend this approach.

tmaleshafske commented 3 years ago

@zadam Couldn't agree with you more. It has been extremely challenging. My Internet at home finally goes on fiber today and I am hoping that will help the network throughput issues I was having with sync.

Flashwalker commented 1 year ago

It would be nice to have an option to sync the db to owncloud/nextcloud as a folders tree of separate plain .md files. Like Qownnotes does. And to local filesystem too. This comes out as a no db backend. Like Obsidian.

This would open up a wide range of opportunities for automating notes in various ways for users.

zadam commented 1 year ago

@Flashwalker that's a bit off topic, but here's some rationale: https://github.com/zadam/trilium/wiki/FAQ#why-database-instead-of-flat-files

Flashwalker commented 1 year ago

Well... how about to:

store the note as a file OR as a folder with index.md file, if it has content,
AND with a folder of sub-notes, if it has sub-notes.
store clones as relative symlinks/hardlinks to .md files (because we always have a note as a file).
store relations about clones, links, attributes, etc in metadata DB in notes folder.

So we have a flat files and all power of DB at once (like Qownnotes)

Something like this: notes folder: qownotes-notes-fs