Wish:protect DataBase with password

[tianya]

Hi,

i have write a software with B4PPC for WM, the generated files are saved as DB with SQLite. I don't want to open the secret of the table Structure.

I'd like to write a Android version of this software, unfortunatly, the SQL 1.02 can not create and read a DB with password.

Tianya

 

[Erel]

Android SQLite implementation doesn't support encryption.
You can encrypt some of the fields manually and store the data as BLOBs. This solution is only useful when the fields are only used to store information as you will not be able to run queries against these fields.

 

[Erel]

You may want to test the updated RandomAccessFile library. It has simple support for encryption of complex object: http://www.b4x.com/forum/basic4andr...ing-information-randomaccessfile-library.html

It will not be possible to encrypt SQLite databases until Android adds support for it.

 

[Widget]

Android SQLite implementation doesn't support encryption.
You can encrypt some of the fields manually and store the data as BLOBs. This solution is only useful when the fields are only used to store information as you will not be able to run queries against these fields.

There is also SqlCipher which is Sqlite with encryption. Apparently someone has it working for Android. I haven't used it but more info can be found at Blog - SQLCipher - Open Source Full Database Encryption for SQLite

Widget