locked
Local database

    Question

  • Best scores tracking is an important part of my app and I currently use a backend web service to track these.  My issue is that when the user is offline this important aspect is missing and I want to still provide it on a local basis, perhaps syncing with the backend service next time I go online.

    I had the thought to use SQLite locally, and I think that will work, but I am wondering about what happens when I do an update to my app.  If I use SQLite to maintain a local database in the AppData area, which seems to be the only place I can do that, and have a bunch of data stored locally, then when I do an update to my app that AppData location will change to the new package/version and my local data will be lost.  Is that not correct?

    I see that you can mark your app as allowing access to the local filesystem for certain file extensions.  I am not clear if that is just for the file picker, or can you programatically access files with specified extension?

    Or is there another place that is App Specific, but not version specific?

    Or is there a way to migrate App data from one version to another?

    Any help is appreciated.


    http://www.puttnutz.com

    Wednesday, March 27, 2013 7:41 PM

Answers

All replies