Feb 13, 2012 Replies: 163 Edit: this library isn't compatible with the 16KB page size requirement. Don't use it. SQLCipher is an open source project that extends SQLite and adds full database encryption. License: https://www.zetetic.net/sqlcipher/open-source/ B4A SQLCipher is a special subtype of SQL object. There is almost no need to change any code in order to switch from regular SQL to SQLCipher. The only difference between SQL API and SQLCipher API is the Initialize method. SQLCipher.Initialize expects two additional values: Password and a second parameter that is not used (it was used in the past). Password is the database password. You can pass an empty string if there is no password. Note that it is not possible to change the password (or set a new password) to an existing database. Code changes required to convert from SQL to SQLCipher - Declare the SQL object as SQLCipher. - Change the initialize code to: Code: SQL1.Initialize(File.DirRootExternal, "1.db", True, DB_PASSWORD, "") V1.70 Based on SQLCipher v4.5.4: https://www.zetetic.net/blog/2023/04/27/sqlcipher-4.5.4-release/ V1.60 Based on SQLCipher v4.00: https://www.zetetic.net/blog/2018/11/30/sqlcipher-400-release/ Includes 64 bit binaries and emulator binaries. Requires B4A v8+. Library is attached. Not compatible by default with databases created with older versions. See this link: https://www.zetetic.net/blog/2018/11/30/sqlcipher-400-release/#compatibility V1.50 Based on SQLCipher v3.59 Supports targetSdkVersion 26. The icu.zip file is no longer required. You can delete it from the Files folder. It is no longer required to disable the debugger virtual assets feature. Remove this line: #DebuggerForceStandardAssets: True Old version: www.b4x.com/android/files/SQLCipher150.zip Depends on: https://repo1.maven.org/maven2/net/...er/4.5.4/android-database-sqlcipher-4.5.4.aar You should download and copy it to the additional libraries folder. Attachments SQLCipher.zip SQLCipher.zip 37.2 KB · Views: 1,282 Last edited: Jul 20, 2025 Click to expand...
Edit: this library isn't compatible with the 16KB page size requirement. Don't use it. SQLCipher is an open source project that extends SQLite and adds full database encryption. License: https://www.zetetic.net/sqlcipher/open-source/ B4A SQLCipher is a special subtype of SQL object. There is almost no need to change any code in order to switch from regular SQL to SQLCipher. The only difference between SQL API and SQLCipher API is the Initialize method. SQLCipher.Initialize expects two additional values: Password and a second parameter that is not used (it was used in the past). Password is the database password. You can pass an empty string if there is no password. Note that it is not possible to change the password (or set a new password) to an existing database. Code changes required to convert from SQL to SQLCipher - Declare the SQL object as SQLCipher. - Change the initialize code to: Code: SQL1.Initialize(File.DirRootExternal, "1.db", True, DB_PASSWORD, "") V1.70 Based on SQLCipher v4.5.4: https://www.zetetic.net/blog/2023/04/27/sqlcipher-4.5.4-release/ V1.60 Based on SQLCipher v4.00: https://www.zetetic.net/blog/2018/11/30/sqlcipher-400-release/ Includes 64 bit binaries and emulator binaries. Requires B4A v8+. Library is attached. Not compatible by default with databases created with older versions. See this link: https://www.zetetic.net/blog/2018/11/30/sqlcipher-400-release/#compatibility V1.50 Based on SQLCipher v3.59 Supports targetSdkVersion 26. The icu.zip file is no longer required. You can delete it from the Files folder. It is no longer required to disable the debugger virtual assets feature. Remove this line: #DebuggerForceStandardAssets: True Old version: www.b4x.com/android/files/SQLCipher150.zip Depends on: https://repo1.maven.org/maven2/net/...er/4.5.4/android-database-sqlcipher-4.5.4.aar You should download and copy it to the additional libraries folder.
Erel B4X founder Staff member Licensed User Longtime User Aug 12, 2015 #121 @Rusty based on the error message it cannot find sqlcipher_native.zip. Try to uninstall the existing app and install it again. Make sure that you set the following attribute: #DebuggerForceStandardAssets: true The timeout exception looks like this issue: https://github.com/sqlcipher/android-database-sqlcipher/issues/114 Are you using SQLCipher v3? Last edited: Aug 12, 2015
@Rusty based on the error message it cannot find sqlcipher_native.zip. Try to uninstall the existing app and install it again. Make sure that you set the following attribute: #DebuggerForceStandardAssets: true The timeout exception looks like this issue: https://github.com/sqlcipher/android-database-sqlcipher/issues/114 Are you using SQLCipher v3?
A Andy S. Member Licensed User Longtime User Aug 14, 2015 #122 I am using SQLCIpher v3. Everything worked fine using SQL. It seems when I do successive updates fired from EditExt.TextChanged events inside a transaction it crashes. Andy
I am using SQLCIpher v3. Everything worked fine using SQL. It seems when I do successive updates fired from EditExt.TextChanged events inside a transaction it crashes. Andy
Erel B4X founder Staff member Licensed User Longtime User Aug 14, 2015 #123 Please start a new thread for this and upload the project if possible (or a small project that demonstrates the issue).
Please start a new thread for this and upload the project if possible (or a small project that demonstrates the issue).
wonder Expert Licensed User Longtime User Aug 30, 2015 #124 So, if I understood correctly, to add encryption to my SQLite B4A project (currently using DBUtils), all I need to do is change the initialization method into this: Code: ProgressDialogShow("Initializing database...") SQL1.Initialize(File.DirRootExternal, "1.db", True, DB_PASSWORD, "") ProgressDialogHide ...and follow the remaining instructions. Right? Do I still need to include the standard SQL lib?
So, if I understood correctly, to add encryption to my SQLite B4A project (currently using DBUtils), all I need to do is change the initialization method into this: Code: ProgressDialogShow("Initializing database...") SQL1.Initialize(File.DirRootExternal, "1.db", True, DB_PASSWORD, "") ProgressDialogHide ...and follow the remaining instructions. Right? Do I still need to include the standard SQL lib?
Erel B4X founder Staff member Licensed User Longtime User Aug 31, 2015 #125 wonder said: Right? Do I still need to include the standard SQL lib? Click to expand... Yes and yes.
Erel B4X founder Staff member Licensed User Longtime User Oct 18, 2015 #126 V1.30 is released - It is based on SQLCipher v3.3.1. Previous versions are not compatible with Android 6.
V1.30 is released - It is based on SQLCipher v3.3.1. Previous versions are not compatible with Android 6.
tucano2000 Active Member Licensed User Longtime User Oct 30, 2015 #127 Erel said: V1.30 is released - It is based on SQLCipher v3.3.1. Previous versions are not compatible with Android 6. Click to expand... Finally after much research and work I managed to solve this problem of incompatibility of the libraries of the V3 version V2 version That's right, I'm saying it's possible to have any Android version, including 6.0, it can make the libraries of the new version V3 read and write older database of V2 version. It's simple. Once you initialize the database add the following line of code: Code: SQLX.Initialize (File.DirInternal, "filename.xxx" False, databasepassword, "") CursorX = SQLX.ExecQuery ("PRAGMA cipher_migrate") '<==== only enter this line 'continue here your code To avoid delays, it is recommended to avoid open and close the database frequently. Erel, if you can put that information in the first post of this topic. I hope you enjoyed the information, and if possible a like me, it gave a lot of work and avoided me having to convert all my original database. Last edited: Oct 31, 2015
Erel said: V1.30 is released - It is based on SQLCipher v3.3.1. Previous versions are not compatible with Android 6. Click to expand... Finally after much research and work I managed to solve this problem of incompatibility of the libraries of the V3 version V2 version That's right, I'm saying it's possible to have any Android version, including 6.0, it can make the libraries of the new version V3 read and write older database of V2 version. It's simple. Once you initialize the database add the following line of code: Code: SQLX.Initialize (File.DirInternal, "filename.xxx" False, databasepassword, "") CursorX = SQLX.ExecQuery ("PRAGMA cipher_migrate") '<==== only enter this line 'continue here your code To avoid delays, it is recommended to avoid open and close the database frequently. Erel, if you can put that information in the first post of this topic. I hope you enjoyed the information, and if possible a like me, it gave a lot of work and avoided me having to convert all my original database.
JTmartins Active Member Licensed User Longtime User Apr 4, 2016 #128 I'm having a problem with this lib when in use with another lib I've created using the Native Library Generator Tool.. If I remove the lib that I've built with the tool, than SQL cypher runs OK...However, the c++ library I've mad, is actualy the one that generates the password for the SQLcypher Database as I do not trust to make it in B4A or JAVA as they can be decompiled much more easily that C++. Any Ideas so that I can solve this situation ? Many Thanks. I get the following error when I use both libs. I noticed that I get SQL.Initialize(File.DirRootExternal & "/Gesdriv in the error log...wich is not the complete path. Not sure if it has something to do with that. ** Activity (main) Create, isFirst = true ** main_activity_create (B4A line: 136) SQL.Initialize(File.DirRootExternal & "/Gesdriv java.lang.UnsatisfiedLinkError: dalvik.system.PathClassLoader[DexPathList[[zip file "/data/app/GesdriverGPS.Gescola.pt-2/base.apk"],nativeLibraryDirectories=[/data/app/GesdriverGPS.Gescola.pt-2/lib/arm, /vendor/lib, /system/lib]]] couldn't find "libstlport_shared.so" at java.lang.Runtime.loadLibrary(Runtime.java:366) at java.lang.System.loadLibrary(System.java:988) at net.sqlcipher.database.SQLiteDatabase.loadLibs(SQLiteDatabase.java:173) at net.sqlcipher.database.SQLiteDatabase.loadLibs(SQLiteDatabase.java:169) at anyhwheresoftware.b4a.objects.sqlcipher.SQLCipher.Initialize(SQLCipher.java:50) at GesdriverGPS.Gescola.pt.main._activity_create(main.java:528) at java.lang.reflect.Method.invoke(Native Method) at java.lang.reflect.Method.invoke(Method.java:372) at anywheresoftware.b4a.BA.raiseEvent2(BA.java:169) at GesdriverGPS.Gescola.pt.main.afterFirstLayout(main.java:102) at GesdriverGPS.Gescola.pt.main.access$000(main.java:17) at GesdriverGPS.Gescola.pt.main$WaitForLayout.run(main.java:80) at android.os.Handler.handleCallback(Handler.java:815) at android.os.Handler.dispatchMessage(Handler.java:104) at android.os.Looper.loop(Looper.java:194) at android.app.ActivityThread.main(ActivityThread.java:5637) at java.lang.reflect.Method.invoke(Native Method) at java.lang.reflect.Method.invoke(Method.java:372) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:960) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:755)
I'm having a problem with this lib when in use with another lib I've created using the Native Library Generator Tool.. If I remove the lib that I've built with the tool, than SQL cypher runs OK...However, the c++ library I've mad, is actualy the one that generates the password for the SQLcypher Database as I do not trust to make it in B4A or JAVA as they can be decompiled much more easily that C++. Any Ideas so that I can solve this situation ? Many Thanks. I get the following error when I use both libs. I noticed that I get SQL.Initialize(File.DirRootExternal & "/Gesdriv in the error log...wich is not the complete path. Not sure if it has something to do with that. ** Activity (main) Create, isFirst = true ** main_activity_create (B4A line: 136) SQL.Initialize(File.DirRootExternal & "/Gesdriv java.lang.UnsatisfiedLinkError: dalvik.system.PathClassLoader[DexPathList[[zip file "/data/app/GesdriverGPS.Gescola.pt-2/base.apk"],nativeLibraryDirectories=[/data/app/GesdriverGPS.Gescola.pt-2/lib/arm, /vendor/lib, /system/lib]]] couldn't find "libstlport_shared.so" at java.lang.Runtime.loadLibrary(Runtime.java:366) at java.lang.System.loadLibrary(System.java:988) at net.sqlcipher.database.SQLiteDatabase.loadLibs(SQLiteDatabase.java:173) at net.sqlcipher.database.SQLiteDatabase.loadLibs(SQLiteDatabase.java:169) at anyhwheresoftware.b4a.objects.sqlcipher.SQLCipher.Initialize(SQLCipher.java:50) at GesdriverGPS.Gescola.pt.main._activity_create(main.java:528) at java.lang.reflect.Method.invoke(Native Method) at java.lang.reflect.Method.invoke(Method.java:372) at anywheresoftware.b4a.BA.raiseEvent2(BA.java:169) at GesdriverGPS.Gescola.pt.main.afterFirstLayout(main.java:102) at GesdriverGPS.Gescola.pt.main.access$000(main.java:17) at GesdriverGPS.Gescola.pt.main$WaitForLayout.run(main.java:80) at android.os.Handler.handleCallback(Handler.java:815) at android.os.Handler.dispatchMessage(Handler.java:104) at android.os.Looper.loop(Looper.java:194) at android.app.ActivityThread.main(ActivityThread.java:5637) at java.lang.reflect.Method.invoke(Native Method) at java.lang.reflect.Method.invoke(Method.java:372) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:960) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:755)
Erel B4X founder Staff member Licensed User Longtime User Apr 5, 2016 #129 Unzip the APK and see whether it includes SQLCipher so files and your so file.
JTmartins Active Member Licensed User Longtime User Apr 7, 2016 #130 Well Erel, When I unzip : 1 - With my Lib and SQLCipher I have the following folder structure under lib arm64-v8a armeabi armeabi-v7a mips mips64 x86 x86-64 under armeabi I have the following files libcryPT.so - my lib libdatabase_sqlcipher.so libsqlcipher_android.so libstlport_shared.so in all the other folders there is only the libcryPT.so 2 - Only with SQLCipher on the project I have the following folder structure under lib armeabi under armeabi I have the following files libdatabase_sqlcipher.so libsqlcipher_android.so libstlport_shared.so So I presume this is where the problem resides. Should I keep the armeabi folder and delete all the others in option 1 ? many thanks
Well Erel, When I unzip : 1 - With my Lib and SQLCipher I have the following folder structure under lib arm64-v8a armeabi armeabi-v7a mips mips64 x86 x86-64 under armeabi I have the following files libcryPT.so - my lib libdatabase_sqlcipher.so libsqlcipher_android.so libstlport_shared.so in all the other folders there is only the libcryPT.so 2 - Only with SQLCipher on the project I have the following folder structure under lib armeabi under armeabi I have the following files libdatabase_sqlcipher.so libsqlcipher_android.so libstlport_shared.so So I presume this is where the problem resides. Should I keep the armeabi folder and delete all the others in option 1 ? many thanks
Erel B4X founder Staff member Licensed User Longtime User Apr 7, 2016 #131 JTmartins said: Should I keep the armeabi folder and delete all the others in option 1 ? Click to expand... Worth a try.
JTmartins said: Should I keep the armeabi folder and delete all the others in option 1 ? Click to expand... Worth a try.
JTmartins Active Member Licensed User Longtime User Apr 10, 2016 #132 Instead of deleting inside the APK, I've actually deleted all folders inside the jar produced by the NLG except the armeabi, recompiled and it seems to be working fine now. Many thanks.
Instead of deleting inside the APK, I've actually deleted all folders inside the jar produced by the NLG except the armeabi, recompiled and it seems to be working fine now. Many thanks.
jatko Member Licensed User Longtime User Jun 23, 2016 #133 There is SqlCipher library v 3.3.0. Is there any newer? I have a problem with this library on Android 5.1.1. Lower version is fine (Android version).
There is SqlCipher library v 3.3.0. Is there any newer? I have a problem with this library on Android 5.1.1. Lower version is fine (Android version).
Erel B4X founder Staff member Licensed User Longtime User Jun 23, 2016 #134 The latest version is based on v3.3.1. It should work on all devices.
jatko Member Licensed User Longtime User Jun 23, 2016 #135 Erel said: The latest version is based on v3.3.1. It should work on all devices. Click to expand... How can I find it? In my opinion www.b4x.com/android/files/SQLCipher330.zip is 3.3.0 version. Any link?
Erel said: The latest version is based on v3.3.1. It should work on all devices. Click to expand... How can I find it? In my opinion www.b4x.com/android/files/SQLCipher330.zip is 3.3.0 version. Any link?
Erel B4X founder Staff member Licensed User Longtime User Jun 23, 2016 #136 This is the latest version. Which error did you get?
jatko Member Licensed User Longtime User Jun 24, 2016 #137 Erel said: This is the latest version. Which error did you get? Click to expand... It's very hard to describe it, because there is no special information during debuging. There is only : Ignoring event as service was destroyed: udp_packetarrived I decided to use SQLcipher in my program. I changed: before - Dim SQL As SQL now - Dim SQL As SQLCipher before - SQL.Initialize(File.DirInternal, "ph.sqlite", True) now - SQL.Initialize(File.DirInternal, "ph_sh.sqlite", True, "password", "") It works on 200 devices (Lenovo TAB 2 A7-30H - android 5.0.1; Samsung Galaxy TAB 2 - Android 4.1.2) and the only one Samsung Galaxy TAB 4 - Android 5.1.1 it daesn't work. Program stop in the very beginning. Last edited: Jun 24, 2016
Erel said: This is the latest version. Which error did you get? Click to expand... It's very hard to describe it, because there is no special information during debuging. There is only : Ignoring event as service was destroyed: udp_packetarrived I decided to use SQLcipher in my program. I changed: before - Dim SQL As SQL now - Dim SQL As SQLCipher before - SQL.Initialize(File.DirInternal, "ph.sqlite", True) now - SQL.Initialize(File.DirInternal, "ph_sh.sqlite", True, "password", "") It works on 200 devices (Lenovo TAB 2 A7-30H - android 5.0.1; Samsung Galaxy TAB 2 - Android 4.1.2) and the only one Samsung Galaxy TAB 4 - Android 5.1.1 it daesn't work. Program stop in the very beginning.
Erel B4X founder Staff member Licensed User Longtime User Jun 26, 2016 #138 jatko said: Ignoring event as service was destroyed: udp_packetarrived Click to expand... This is not related. jatko said: Samsung Galaxy TAB 4 - Android 5.1.1 it daesn't work. Program stop in the very beginning. Click to expand... Maybe it is not an ARM device. There should be an error message in the logs. You might need to switch to USB debug mode to see it.
jatko said: Ignoring event as service was destroyed: udp_packetarrived Click to expand... This is not related. jatko said: Samsung Galaxy TAB 4 - Android 5.1.1 it daesn't work. Program stop in the very beginning. Click to expand... Maybe it is not an ARM device. There should be an error message in the logs. You might need to switch to USB debug mode to see it.
jatko Member Licensed User Longtime User Jun 27, 2016 #139 That was the device problem. After "Factory data reset" it works. Thank You Erel.
marcoperoni New Member Licensed User Longtime User Feb 15, 2017 #140 Sanxion said: SQLite db created outside of the application? This is great news, however I do have a question: How would I encrypt/set a password for a SQLite database that has been created/populated outside of a B4A application which is then to be used in the application? Click to expand... Good news: with the latest version of the open source DB Browser for SQLite ( http://sqlitebrowser.org/ ) you can Encrypt an existent SQLite DB with SQLCipher . I Crypted with sqlitebrowser and then opened with SQLCypher library without problems.
Sanxion said: SQLite db created outside of the application? This is great news, however I do have a question: How would I encrypt/set a password for a SQLite database that has been created/populated outside of a B4A application which is then to be used in the application? Click to expand... Good news: with the latest version of the open source DB Browser for SQLite ( http://sqlitebrowser.org/ ) you can Encrypt an existent SQLite DB with SQLCipher . I Crypted with sqlitebrowser and then opened with SQLCypher library without problems.
