search

vlcn-io / cr-sqlite

Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite
https://vlcn.io
MIT License
2.61k stars 69 forks source link

server side compensations #374

Open tantaman opened 9 months ago

tantaman commented 9 months ago
andrewluetgers commented 5 months ago

I need to support offline sync + teams and have looked into using ElectricSQL well but am really impressed with the idea of the CRDT being implemented within the database as opposed to an external sync service, it feels like the SQLite way to do it.

I brought the issue of permissions up on the Discord chat and was referred to this issue. Where you had mentioned"

You could apply filters before returning rows from crsql_changes.

You'd need to track if filtered out rows ever become visible again, however, so you can sync them back down.

To move this issue forward another step I think a further discussion here would be good to enumerate any of the challenges of properly implementing permissions with cr-sqlite and general thoughts on how you might go about it.