This flag SQLITE_OPEN_FILEPROTECTION_NONE which is available in iOS SDK, is not available with SQLite and SQLCipher.
Does it mean that when using SQLCipher we might suffer of issues when trying to open/read/write to database when app is in background and iPhone is locked?
Hi @julien.roger – That’s correct, the file protection flags are specific to the Apple variant of SQLite. When creating files, unless otherwise specified, the default of NSFileProtectionCompleteUntilFirstUserAuthentication is generally appropriate. Once the user authenticates to the device after boot, the app can maintain access to databases, even when backgrounded or when the device is locked.