sqlcipher

Hi everyone, Recently, I installed my application for so many years has been working on Android 14 below and some Android 15 (selected only) but on some Android 15 such as Samsung S25 FE (Android 16), Samsung S25 Ultra (Android 15), Oppo Reno 14 pro (Android 15), Realme GT 7T (Android 15) and...

Hello as for B4A the initialize statement includes the possibility to create an empty database if the named database file is not found. sql.initializeSQLite(file.dirApp,Filename,true) I did not find the same in the statement to be used for B4J...

Hi all. As I mentioned in my previous post https://www.b4x.com/android/forum/threads/applying-sqlcipher-android-4-10-0-aar-that-fixes-16kb-issues-with-sqlcipher.168471/post-1033728 I must to admit that I was wrong. I tested it on my test computer. It was Ok during the compilation but I just...

Hi all. Thanks to @GeoffT660 , @Shelby and @DonManfred we now can download a replacement for SQLCipher aar that will allow us to continue using it with 16KB requirements. I did some tests on my test computer - here is a result. I just in case first archived my AdditionalLib folder in case if...

🔐 TOOL released: SqlCipherConverter v1.0 – Simplifying SQLite to SQLCipher Migration! A common challenge when moving an existing SQLite database to SQLCipher is that encryption can only be applied to a new database. This makes migrating existing data challenging without specialized tools. To...

Hello Experts, I like to change the Database Password by B4J Code. Can anyone help me with a snipped. Thank you in advance.

Name: TD_recordset Type: Custom B4A Class (b4xlib) Version: 1.0 State: Testphase Licence: free for personell use, free for commercial use after donation. Download here TD_Recordset is a custom class that allows you to store and manage selected data from an SQLite or SQLCipher database...

Status: UPDATE Name: TD_DBNavBar Code: B4A Type: b4xlib Version: 2.6 License: Royalty free for personal and commercial use External License: Usage of BR_Button (C) Lucas Siqueira Author: TechDoc G. Becker Attached: Download Link Update...

Using the latest version of SQLCipher, recently uploaded by Erel: 1.7. SQLite version is 3.41.2 Before changing to the latest SQLCipher version I used to be able to change this pragma setting while running the app by just running: pragma cipher_memory_security = OFF or pragma...

Have a large SQLite DB, file size is 4.9 Gb, this is according to B4A File.Size (In Windows it shows at about 4.5 Gb). The file is in File.DirInternal. I copied the file to external storage (after closing the DB connection) and then copied the file to my Windows PC. I then did a vacuum in DB...

SQLCipher has this pragma that can speed up SQL quite a bit if memory security is turned off. Been using this for a few years now in a large database and never seen a problem with it. It can be useful when running multiple SQL's or running a single slow SQL. Attached a simple demo project that...

Library: TDDBUtils.b4xlib Language: B4A Version 1.8 Manual: Version 1.5.2 (did some checks and improvements, added SQLCipher tutorial) Status: Work in Process (C) This library is free for non commercial use other use see manual. New to 1.8: optimized code fixed some errors Added grouping and...

I've no reason to doubt the reliability of SQLCipher. I haven't used it, but I plan to. Can anyone comment on whether an SQLCipher database is more likely to experience problems (data corruption etc) than a non-encrypted SQLite database. Thanks

Erel, is there any chance B4i will have a SQLCipher library or something like that to secure a database content? Thanks.

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. But I don't see a way to use that in B4A as Sql.Initialize fails when opening an SQLCipher...

Colleagues, I'm pretty worried, I should do this migration from SQLCiper V1.50 to V1.60, as we all know from the 64BIT binary. The problem is generated because the database created in V1.50 will not be compatible with V1.60, so as I do to pass that data to the new database when updating the app...

Hi, I have this issue: I create database with SQLcipher 1.6 lib by this instructions: SQL1.Initialize(File.DirRootExternal, "1.db", True, DB_PASSWORD, "") https://www.b4x.com/android/forum/threads/android-database-encryption-with-sqlcipher-library.14965/ and it works fine. But the problem...

Hola. Estoy empezando a indagar SQLCipher y me surge una duda. Hasta ahora de empezar con el cifrado, las BD las creo en el PC (SQLite Studio) y las incrusto sin ningún registro en la app a través de la carpeta Files. Al iniciar la APP, lo primero que hago es descargar los registros desde un...

Trying to copy a table from the main SQLite database (main) to an attached database. I am using SQLCipher. The table I am copying has this DDL: CREATE TABLE [ADDRESSES]([EMIS_NUMBER] INTEGER PRIMARY KEY, [HOUSE] TEXT, [STREET] TEXT, [LOCALITY] TEXT, [TOWN] TEXT, [POSTCODE] TEXT, [HOME_PHONE]...

The current SQLCipher (version 3.20.1, compile date 24/08/2017) is compiled without SQLITE_ENABLE_EXPLAIN_COMMENTS, so although there is a comment output column, the Explain command doesn't produce any comments. This is a pity as it looks using Explain could be an easy way to see all the select...