QUIRKS & CORRUPTION WARNINGS

[brodycj]

updated: I am pinning this issue to keep attention to reported quirks and corruption warnings.

Corruption warning:

"Multiple SQLite" corruption problem is discussed in #626 - this can happen if multiple SQLite implementations access the same database due to any custom native plugins, extra SQLite plugin versions, or any other cause. This is especially a concern on Android and Windows where multiple SQLite implementations could be embedded through multiple dynamically linked libraries.

Some quirks reported by the user community:

• Browser support dropped? #918 - browser platform is not supported (was never supported)
• Uninstall app database still persist #612 - database continues to persist after uninstalling app
• Disable WAL-mode File Format in sqlite for Android 9 #887 - (disabling) WAL format on Android 9
• androidLockWorkaround: 1 setting was needed to workaround issue Android not saving the inserts [workaround needed] #193 back in 2015; I just opened Is androidLockWorkaround option still needed? #925 to see if we still need it or not
• a few users had encountered random database corruption, and some compile-time settings were added to be extra robust against this kind of an issue in the future; this is now discussed in Dealing with possible database corruption cordova-sqlite-storage-help#34
• .db location #912: Android database directory is generally hidden, someone gave workaround how to find the database path on Ionic (looks like it uses file plugin)
• indexeddb lost when updating app from cordova-android 9 to cordova-android 11 #1008 - IndexedDB data info lost after an upgrade

Discussion of these quirks should continue in the individual issues. I would be happy to add more device-related quirk issues as needed.

[brodycj]

This issue was renamed and updated to bring extra attention to both quirks and "Multiple SQLite" corruption warning. This kind of update is done as a workaround since the GitHub UI only supports 3 pinned issues in the project.