3 ms·
"Custom" would be the way Apple Notes or Evernote stores their data in opaque binary blobs. SQLite is standard and you can open it with plenty of third-party to
by laurent123456 3y ago
"Custom" would be the way Apple Notes or Evernote stores their data in opaque binary blobs. SQLite is standard and you can open it with plenty of third-party tools, but I see your point about plain text files being more convenient for certain tasks.
- zimpenfish 3y ago> SQLite is standard and you can open it with plenty of third-party tools Tends not to play well with things like Dropbox or Syncthing though. Although I guess you can use litestream or something for the replication instead.
- anta40 3y agoWhat's the issue? I guess it's just as simple as uploading the .db?
- Tomte 3y agoYou're changing some note on device A and the same note differently on device B. Both sync. You now have a conflict. With text files, you at least have obvious merge strategies. With SQLite it isn't quite as easy. I still don't mind SQLite in Joplin. It has advantages, as well.
- anta40 3y agoAh the multiple devices issue. I see...
- grepfru_it 3y agoHow about doing everything server side so you are just using a thin client (read: web browser) instead? See trilium: https://github.com/zadam/trilium https://github.com/zadam/trilium
- diydsp 3y agoI sync Joplin via Dropbox across phone and 2 laptops. In theory a prob? But in practice rare to never bc im only one user on one device at a time. And im making small changes at a time. There was 1 minor conflict once and Joplin saw it and i quickly resolved it.
- tredre3 3y ago> "Custom" would be the way Apple Notes or Evernote stores their data in opaque binary blobs. Apple Notes uses SQLite.
- tlavoie 3y agoSince the content is basically plain-text already, read-only access to all of them at the very least shouldn't cause any problems. I was wondering though, since my Nextcloud storage is encrypted, does the SQLite file get synced as well?