gravel Member Licensed User Longtime User Feb 3, 2019 #1 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?
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 B4X founder Staff member Licensed User Longtime User Feb 4, 2019 #2 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. Upvote 0
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.
R RB Smissaert Well-Known Member Licensed User Longtime User Feb 4, 2019 #3 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. Click to expand... 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 Upvote 0
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. Click to expand... 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 Member Licensed User Longtime User Feb 4, 2019 #4 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. Upvote 0
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 Member Licensed User Longtime User Feb 4, 2019 #5 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 Click to expand... It looks as if the new beta version of DB Browser works with SQLCipher 4 https://github.com/sqlitebrowser/sqlitebrowser/issues/1656 Upvote 0
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 Click to expand... It looks as if the new beta version of DB Browser works with SQLCipher 4 https://github.com/sqlitebrowser/sqlitebrowser/issues/1656
R RB Smissaert Well-Known Member Licensed User Longtime User Feb 4, 2019 #6 gravel said: It looks as if the new beta version of DB Browser works with SQLCipher 4 https://github.com/sqlitebrowser/sqlitebrowser/issues/1656 Click to expand... Thanks, will have a look at that and maybe move to the new version. RBS Upvote 0
gravel said: It looks as if the new beta version of DB Browser works with SQLCipher 4 https://github.com/sqlitebrowser/sqlitebrowser/issues/1656 Click to expand... Thanks, will have a look at that and maybe move to the new version. RBS
