Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Possible "Multiple SQLite problem" (corruption problem) on multiple platforms #626

Open
brodycj opened this issue Jan 27, 2017 · 1 comment

Comments

@brodycj
Copy link
Contributor

brodycj commented Jan 27, 2017

on Android (updated 2020):

From http://ericsink.com/entries/sqlite_android_n.html: in case someone uses android.database.sqlite or any other SQLite implementation from another plugin or from application-specific Java code to access the same database as this plugin there is potential for database corruption ref:

This potential issue is partially due to this plugin using its own non-standard build of SQLite on Android.

Note that the first part about "SQLite and Android N" is NOT a problem with this plugin since it uses its own build of SQLite.

In case anyone encounters this issue the workaround is to open the database with the androidDatabaseImplementation: 2 and possibly androidLockWorkaround: 1 settings as documented.

on other platforms (added March 2020):

from README.md:

This plugin version also uses a fixed version of sqlite3 on iOS, macOS, and Windows. In case the application accesses the SAME database using multiple plugins there is a risk of data corruption as described in https://www.sqlite.org/howtocorrupt.html (similar to the multiple sqlite problem for Android as described in http://ericsink.com/entries/multiple_sqlite_problem.html).

brodycj pushed a commit to brodycj/Cordova-sqlite-storage-common-dev that referenced this issue Nov 2, 2017
brodycj pushed a commit to brodycj/Cordova-sqlite-storage-common-dev that referenced this issue Nov 2, 2017
brodycj pushed a commit to brodycj/Cordova-sqlite-storage-common-dev that referenced this issue Nov 3, 2017
@brodycj brodycj changed the title Possible "Multiple SQLite problem" on Android Possible "Multiple SQLite problem" on multiple platforms Mar 12, 2020
@brodycj brodycj changed the title Possible "Multiple SQLite problem" on multiple platforms Possible "Multiple SQLite problem" (corruption problem) on multiple platforms Mar 12, 2020
@brodycj
Copy link
Contributor Author

brodycj commented Mar 12, 2020

This can be an issue on multiple platforms, updating title and description.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant