News for hackers. Stuff that matters.
Re:Crsql – Multi-writer and CRDT support for SQLite by smasher164 on Tuesday November 15, 2022 @01:15PM (#33612853)
This is phenomenal! I'm going to try experimenting with this. Hats off to the author.

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!

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.
Re:Crsql – Multi-writer and CRDT support for SQLite by tantaman on Thursday November 17, 2022 @06:46AM (#33637626)
I know that DiamondTypes does write to disk and acts much like a db itself. I was thinking it could be possible to expose that library as a virtual table in SQLite.
Re:Crsql – Multi-writer and CRDT support for SQLite by tantaman on Thursday November 17, 2022 @06:50AM (#33637662)
lmk if you need any help getting things set up.