Skip to content
This repository has been archived by the owner on Sep 19, 2018. It is now read-only.

On-device database schema enhancements for sync #78

Closed
linuxwolf opened this issue Jan 24, 2018 · 0 comments
Closed

On-device database schema enhancements for sync #78

linuxwolf opened this issue Jan 24, 2018 · 0 comments
Assignees
Labels
Milestone

Comments

@linuxwolf
Copy link
Contributor

linuxwolf commented Jan 24, 2018

In service to sync, the on-device IndexedDB requires additional collections/tables:

  • pending to track changes to be applied (locally and remotely)
  • markers to track the last sync point for each collection (items and keystores)

Further modifications to the existing keystores table are necessary:

  • remove uuid from the indexes
  • add id to the record (indexed), set to HASH(group)
  • add last_modified to record (but not indexed) to track the server-provided timestamp

Additional changes to the items table are necessary:

  • add last_modified to record (but not indexed) to track the server-provided timestamp

Related

@sandysage sandysage added backlog We have looked at and understand the issue. Prioritized with alignment to product initiatives. chore labels Jan 24, 2018
@sandysage sandysage added to do and removed backlog We have looked at and understand the issue. Prioritized with alignment to product initiatives. labels Feb 8, 2018
@sandysage sandysage added this to the 0.1.7 milestone Feb 9, 2018
@ghost ghost added in progress We are actively working on it. and removed to do labels Feb 13, 2018
@ghost ghost removed the in progress We are actively working on it. label Feb 15, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

2 participants