Some quick notes that I jotted down about syncing a single database between two app instances.
Each app’s database will have a unique ID
- Generated at app startup if it doesn’t already exist
- Where stored?
- Create Account – email, password
- Sign In to Existing Account – email, password
- Azure Accounts table – email, password (hashed), database ID
@1, pwd 1, ID A
@2, pwd 2, ID B
- Share List
|@1 creates account||@1 ID A|
|@2 creates account||@1 ID A
@2 ID B
|@1 shares ID A with @2 (needs @2)||@1 ID A
@2 ID A
Database associated with @2 changed if @2 found
Need to flesh all this out more.