Re:Crsql – Multi-writer and CRDT support for SQLite
by smasher164 on Tuesday November 15, 2022 @01:57PM
(#33613368)
It looks like it doesn't have sequence support?
Dang -- I'll wait a while then.
Re:Crsql – Multi-writer and CRDT support for SQLite
by tantaman on Wednesday November 16, 2022 @09:02AM
(#33623031)
yeah, not yet. yjs and automerge have rust ports so _maybe_ (big maybe) sequence crdts can be added by creating a virtual table interface to those projects. TBD.
Re:Crsql – Multi-writer and CRDT support for SQLite
by smasher164 on Thursday November 17, 2022 @01:45AM
(#33635762)
That would be cool. One I issue I could see coming up is that automerge and yjs keep everything in memory (the reason why a DB CRDT is preferable in the first place), so I'm wondering how you'd make use of their APIs without doing a bunch of (de)serialization.
I was trying to re-implement a JSON CRDT on top of SQLite for my notes app, but this just made the whole database a CRDT!