News for hackers. Stuff that matters.
Re:Crsql – Multi-writer and CRDT support for SQLite by throwawaaarrgh on Tuesday November 15, 2022 @08:19AM (#33608780)
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.