Android Question Use security database

[devmobile]

Hello
I have a word document that contain 20000 words and i want to add it to sqlite database
This database is security and user haven't to get it with extract apk
How keep it out of rich of user?

 

[Star-Dust]

see this:
https://www.b4x.com/android/forum/t...ryption-with-sqlcipher-library.14965/#content

 

[devmobile]

see this:
https://www.b4x.com/android/forum/t...ryption-with-sqlcipher-library.14965/#content

I know but it is slow for large file

 

[tigrot]

I'd encrypt single columns and store them. Avoid to crypt key fields.

 

[devmobile]

I'd encrypt single columns and store them. Avoid to crypt key fields.

Single column?
But i have many record(top 100000) and how do i encrypt each record?

 

[tigrot]

You do while loading db. You decrypt while reading. I wrote "columns"... Using crypt has something to pay in performance...

 

[devmobile]

You do while loading db. You decrypt while reading. I wrote "columns"... Using crypt has something to pay in performance...

Oh yes it is good solution.
But how do i encrypt columns when i add it in database?

 

[tigrot]

Create a field in which you encode db field content. Repeat for each field on record. Then use the result in insert sql. Access time doesn't change. You can use whatever encryption scheme you can find on this site.

 

[tigrot]

You must be sure that the strings obtained don"t contain special chars or you must esc them