Re:Crsql – Multi-writer and CRDT support for SQLite
by throwawaaarrgh on Tuesday November 15, 2022 @08:19AM
(#33608780)
It's complicated, but you can grok it: https://en.m.wikipedia.org/wiki/Conflict-free_replicated_dat...
[ Parent
| on HN ]
Re:Crsql – Multi-writer and CRDT support for SQLite
by bawolff on Tuesday November 15, 2022 @08:46AM
(#33609066)
The part i dont understand is as far as i understand, CRDT requires data types with commutative update functions, but SQL does not have that. The part i dont understand is how these two technologies that seem to have conflicting requirements are being joined.
Re:Crsql – Multi-writer and CRDT support for SQLite
by zodester on Tuesday November 15, 2022 @09:58AM
(#33609870)
Columns are LWW (last writer wins) registers within rows which are LWW maps. When concurrent writes occur because peers may not be communicating, there is typically an arbitrary but convergent selection based on peer id.