Does anyone know of a good database or NoSql engine for Windows Phone 8 that can be used by my app?
I need to be able to open a read-only database file from the SD card. It needs to be able to cope with storing blobs (png images) as I want to use it to provide map tiles for offline use. 100,000's of image tiles will need to be stored in the database.
I've experimented with SQLite for Windows Phone via C# wrappers, but I don't seem to be able to get it to work with a database file located on the SD card.
There are limitations with Windows Phone apps accessing files located on an SD card, but it is possible: http://msdn.microsoft.com/library/windowsphone/develop/jj720573%28v=vs.105%29.aspx
Feedback from a Microsoft employee regarding my difficulties with SQLite:
Windows Phone apps can read specific file types from the SD card using the Microsoft.Phone.Storage APIs.
I expect that the SQLite implementation for the phone tries to open the database using standard C file API rather than using the Storage objects and so requires that the database be in the Xap or isolated storage and cannot access a database on the SD card (this is definitely the case for SQLite for Windows Store apps).
Feedback from SQLite SDK community:
Apparently it should be fairly straight forward to add support to the SQLite SDK for someone with some C++ skills (mine are a bit rusty!):
Replies:
- http://www.mail-archive.com/sqlite-users@sqlite.org/msg81059.html
- http://www.mail-archive.com/sqlite-users@sqlite.org/msg81060.html
To my original question: