mardi 26 avril 2016

Is it possible to run queries on a SQLite DB that's in a OneDrive folder?

I have a "notes" app I'm working on and all of the user's notes are saved in a sqlite.db file. However, I would like this database file to be synchronized to the user's OneDrive cloud account so that the notes are up-to-date in the cloud. Eventually I will make the app compatible with Windows Phone and so the PC and Phone versions will stay synchronized through the OneDrive account.... if that even works out.

So I would like to know if it is possible to run queries on the sqlite.db file that's on the user's OneDrive account, or would I just have to re-sync the entire file every time there are changes in one location?

I could imagine that the latter approach would be a problem because I would need to know which individual records were modified or deleted and make changes accordingly, so yeah.... Help? :]

Aucun commentaire:

Enregistrer un commentaire