SURVEY: Has anyone encountered iOS locking issues?

[brody4hire]

I have seen a couple of reports of iOS database locking:

• PR added support to enabling database when ios is locked #264 - added support to enabling database when ios is locked
• .sql can't open when the iphone locked sqlcipher/sqlcipher#156 - .sql can't open when the iphone locked (possible interaction with FMDB)

I have not seen this issue myself. I would be interested if anyone else has seen this issue.

[brody4hire]

I discovered the following: http://codeblow.com/questions/sqlite-error-database-is-locked/

I do not think this is an issue with this plugin since the sql access is protected by a @synchronized(self) block.

[asnyderabode]

This is an issue if you are using Data Protection.

[brody4hire]

Thanks @asnyderabode. Anyone else?

Any suggestions how to enable the "Data Protection"?

From discussion in sqlcipher/sqlcipher#156 and ccgus/fmdb#262 I think the ideal would be to use the SQLITE_OPEN_FILEPROTECTION_NONE flag. It may need some Apple or iOS specific code. I kinda remember there being an Apple or iOS specific SQLite branch. For further investigation.

I am also marking this as a bug for now.

[brody4hire]

Closing this discussion in favor of issue reported in #786