News for hackers. Stuff that matters.
Re:Crsql – Multi-writer and CRDT support for SQLite by tantaman on Tuesday November 15, 2022 @11:50AM (#33611620)
Project author here (although not OP)

I like the idea of moving the syntax to inserts and had not seen https://www.sqlite.org/fts5.html#special_insert_commands

Will give it a shot & thanks for the resources.

> I personally am working on this problem, but I am approaching it from ephemeral tables.

Would love to trade ideas if you're open to it. @tantaman on twitter.

> Does this support CRDTs other than last-write-wins registers?

Not yet. I was thinking of collaborating with Seph to bring DiamondTypes in for sequence crdt support. If that is even possible -- just an idea at the moment.

Re:Crsql – Multi-writer and CRDT support for SQLite by cryptonector on Tuesday November 15, 2022 @12:41PM (#33612429)
You can use views with INSTEAD OF triggers to handle INSERTs.
Re:Crsql – Multi-writer and CRDT support for SQLite by faizshah on Wednesday November 16, 2022 @08:58AM (#33622942)
OP here, sorry if you didn’t want this posted yet. I had never seen such a simple way to implement realtime collaboration so I thought I would share it.
Re:Crsql – Multi-writer and CRDT support for SQLite by tantaman on Wednesday November 16, 2022 @09:05AM (#33623083)
np. Gives me a good reason to finish up those usage docs and example apps :)