https://www.inkandswitch.com/local-first.html
Snapshot: 2020-10-04 - Local-first software- You own your data, in spite of the cloud.html
A very interesting article that highlights the issues I had with web apps and local only apps.
They also provide a few directions on how to solve those issues. One is CRDT (Conflict-free Replicated Data Types).
CRDT basically allows you to merge different source of data without having conflicts (most of the time). It is suited to local-first applications that still want to collaborate with other users.
The article is from April 2019 and I don't know how's the state of the art now (as of Oct 2020).