Upgrading to sqlcipher 4 and split databases

[sjlombardo]

Hello @hwbest - There isn’t an API available to query the library version that created the database. As you noted, PRAGMA cipher_version returns the current version of the library, not the database version.

One technique that we’ve used to manage migrations is discussed here, and presents a fairly well optimized technique for determining whether a database needs to be migrated:

Upgrading to SQLCipher 4

Hello @zpapp - one fairly standard way to do this follows: Attempt to open the database using standard settings (i.e. whatever the defaults are for the current version of SQLCipher for the app (in this case SQLCipher 4). If the database can’t be opened using the key and the default settings, try to open it and run PRAGMA cipher_migrate on it (e.g. with postKey in the case of android). This would then attempt to upgrade the database. If the migration succeeds, you can continue to use that …

Would something like that work for you?