Wish:protect DataBase with password

tianya · Sep 16, 2011

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 · Sep 18, 2011

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 · Sep 18, 2011

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 · Sep 20, 2011

Erel said:
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

Wish:protect DataBase with password

tianya

Member

Erel

B4X founder

Erel

B4X founder

Widget

Well-Known Member

Similar Threads

Wish:protect DataBase with password

tianya

Member

Erel

B4X founder

Erel

B4X founder

Widget

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency