Android Question SQLCipher 1.6 - PRAGMA cipher_migrate

gravel · Feb 3, 2019

I'm using SQLCipher 1.5 in an existing app. From Aug 2019 app updates will require 64-bit so I'll have to move to SQLCipher 1.6 which provides 64-bit support and upgrades from SQLCipher 3 to SQLCipher 4.

The SQLCipher 4 release notes https://www.zetetic.net/blog/2018/11/30/sqlcipher-400-release/ say to migrate existing databases in place with "PRAGMA cipher_migrate", and there is some discussion here https://discuss.zetetic.net/t/upgrading-to-sqlcipher-4/3283/6 as well.

But I don't see a way to use that in B4A as Sql.Initialize fails with a "not a database" error when opening an SQLCipher 3 database.

Is there a way to use cipher_migrate in B4A?

Erel · Feb 4, 2019

SQL.Initialize just calls the native method to open the database. Seems like the Android library doesn't support it.

You should decrypt the database, save the data, update the app and encrypt it again.

RB Smissaert · Feb 4, 2019

Erel said:
SQL.Initialize just calls the native method to open the database. Seems like the Android library doesn't support it.

You should decrypt the database, save the data, update the app and encrypt it again.

Is there any Windows application that can encrypt and decrypt SQLite databases with this latest SQLCipher version?
I am still using the old version as I can encrypt/decrypt on Windows with DB Browser for SQLite and can use the encrypted DB
in my Android app.

RBS

gravel · Feb 4, 2019

Thanks Erel. Even though 'my' DB data is sort of user generated, I can probably get around it as I have contact with users, but could be a bit a problem for others.

gravel · Feb 4, 2019

RB Smissaert said:
Is there any Windows application that can encrypt and decrypt SQLite databases with this latest SQLCipher version?
I am still using the old version as I can encrypt/decrypt on Windows with DB Browser for SQLite and can use the encrypted DB
in my Android app.

RBS

It looks as if the new beta version of DB Browser works with SQLCipher 4 https://github.com/sqlitebrowser/sqlitebrowser/issues/1656

RB Smissaert · Feb 4, 2019

gravel said:
It looks as if the new beta version of DB Browser works with SQLCipher 4 https://github.com/sqlitebrowser/sqlitebrowser/issues/1656

Thanks, will have a look at that and maybe move to the new version.

RBS

Android Question SQLCipher 1.6 - PRAGMA cipher_migrate

gravel

Member

Erel

B4X founder

RB Smissaert

Well-Known Member

gravel

Member

gravel

Member

RB Smissaert

Well-Known Member

Similar Threads

Android Question SQLCipher 1.6 - PRAGMA cipher_migrate

gravel

Member

Erel

B4X founder

RB Smissaert

Well-Known Member

gravel

Member

gravel

Member

RB Smissaert

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency