top | item 44821774

(no title)

anty | 6 months ago

Very cool, I'm working on something similar!

Naturally I have some questions:

1. I don't see any examples for foreign key constraints (ON DELETE and ON UPDATE) or UNIQUE constraints. Are constraints still supported? 2. How is row-level privacy implemented? Are "forbidden" rows not synced by the server logic, or are they encrypted?

discuss

order

marcobambini|6 months ago

1. Good point, we are going to publish more details about constraints in the repo within a few days 2. We have implemented row-level security, so you are free to easily implement any privacy role you want: https://docs.sqlitecloud.io/docs/rls. The "forbidden" rows are not synced

About encryption: all communications are over TLS.

anty|6 months ago

Thanks for the clarification. Looking forward to see your solutions to the constraint problems.