3 ms·
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
by anty 1y 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?
- marcobambini 1y ago1. 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 https://docs.sqlitecloud.io/docs/rls. The "forbidden" rows are not synced About encryption: all communications are over TLS.
- anty 1y agoThanks for the clarification. Looking forward to see your solutions to the constraint problems.