Secret Life of Local First Value
A deep dive into how CRDT-powered local-first apps track, merge, and sync every INSERT, UPDATE, and DELETE inside SQLite.
Visit Original Link →Secret Life of Local First Value
Link: https://marcobambini.substack.com/p/the-secret-life-of-a-local-first
Context
This is lovely. So well explained what CRDTs are. It’s like a log of what happened in a row of a table. Like column-level details of updation/insertion and deletion. It makes sense now. The metadata table is the crux of this structure. What would happen if the database itself crashes? That is unlikely, I think. SQLite cannot crash at least locally. Nice thinking here.
Source: techstructive-weekly-64