Hi, Thanks for making your useful SQLite libraries freely available - much appreciated!
I'm wondering if there's plans for the Windows Phone implementation to support read-only databases on the SD card? Here's some feedback from a Microsoft employee I had while trying to work with SQLite DB's on an SD card... Your app doesn't have direct access to the files on the SD card. It can't open them directly with file system API, but needs to use the ExternalStorageFile<http://msdn.microsoft.com/en-us/library/windowsphone/develop/microsoft.phone.storage.externalstoragefile%28v=vs.105%29.aspx>and ExternalStorageFolder<http://msdn.microsoft.com/en-us/library/windowsphone/develop/microsoft.phone.storage.externalstoragefolder%28v=vs.105%29.aspx>interfaces from Windows.Storage. To quote from Reading from the SD card on Windows Phone 8:<http://msdn.microsoft.com/en-us/library/windowsphone/develop/jj720573%28v=vs.105%29.aspx> Windows Phone apps can read specific file types from the SD card using the Microsoft.Phone.Storage<http://msdn.microsoft.com/en-us/library/windowsphone/develop/microsoft.phone.storage%28v=vs.105%29.aspx>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). In theory it would be possible to update SQLite to use Storage objects, but I suspect it would be a significant project to do so. Here's some links to discussions I've had trying to work with SQLite: http://social.msdn.microsoft.com/Forums/en-US/42d40b72-4010-4b8c-abe5-bad0e215fa95/how-to-retrieve-data-from-sqlite-db-on-sd-card-on-wp8?forum=wpdevelop http://stackoverflow.com/questions/20324380/unable-to-retrieve-data-from-sqlite-db-on-sd-card-on-wp8 Cheers, Gavin .................................................................... WEB / MOBILE / SOFTWARE DEVELOPMENT Gavin Harriss :: Professional Developer, New Zealand www.gavinharriss.com .................................................................... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
