News for hackers. Stuff that matters.

A comment on Consider SQLite. Parent comment

Re:Consider SQLite by dorian-marchal on Wednesday December 29, 2021 @02:18PM (#29728791)
How would we deal with conflicts (e.g. syncing back several conflicting offline clients for the same user) with something based on the Session Extension?
[ Parent | on HN ]
Re:Consider SQLite by samwillis on Wednesday December 29, 2021 @02:29PM (#29728950)
You have to handle the merge conflicts yourself, see https://www.sqlite.org/session/sqlite3changeset_apply.html

So you need to be carful how you design your schema, but very possible.

One option is to use something like Yjs and a JSON column to get proper CRDTs for merging.

https://github.com/yjs/yjs

[ Parent | on HN ]