Readit Newsmarcobambini commented on SQLite offline sync for Android quick start github.com/sqliteai/sqlit... · Posted by u/marcobambini
Does this have any relation to: https://github.com/vlcn-io/cr-sqlite ?
Some of the API naming is similar (db_version, site_id, seq, commit_alter, etc), although the project source is very different (C rather than Rust, different feature set).
crsqlite is no longer maintained so I might be interested in migrating.
API naming looks similar, probably because we are based on the same scientific paper: https://munin.uit.no/bitstream/handle/10037/24430/article.pd...
marcobambini commented on SQLite offline sync for Android quick start github.com/sqliteai/sqlit... · Posted by u/marcobambini
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?
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.
P.S. I am the author