server side compensations

[tantaman]

• Read permissions
• Write permissions
• Integrity / data validation

[andrewluetgers]

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.