I develop an app that uses the version of SQLite that ships with iOS. I believe the system version of SQLite includes the commercial SEE (SQLite Encryption Extension) and I have been using this with a 'PRAGMA key=***' statement to successfully read/write encrypted databases for some time on iOS 14.5 and below. I have also had success on an iOS 15.0 simulator.
However, on iOS 15.2 I am unable to read/write encrypted databases using this method. The PRAGMA key statement should return the string 'ok' in most circumstances but on iOS 15.2 it returns null (as do other PRAGMA's like textkey and hexkey). This makes me think that SEE is not included on iOS 15.2 and only the public domain SQLite is available.
Does anybody know if this is actually the case?
Executing 'select sqlite_version()' on iOS 15.2 reports the version as 3.36.0.