Encrypting only specific tables / fields of an SQLite database

Question

Is it possible?

I read about SQLCipher, but it seems to encrypt the whole database.

Is there a way to configure it to encrypt only specific parts of it?

A table or a field will do just fine.

Android is quite secure regarding SQLite. From what do you want to keep data encrypted? — shkschneider, Aug 31 '12 at 15:52
Why not encrypt the whole database? I've used SQLCipher it's pretty quick. The only downside is it adds 4MB to .apk size — scottyab, Aug 31 '12 at 15:54
I just want to store the app client's ID and secret provided by Facebook securely. — user940016, Aug 31 '12 at 16:30

score 1 · Accepted Answer · answered Nov 02 '12 at 15:13

1

In the end I didn't need to use SQLite or any other techniques for encryption, because I found out I don't have to store the app client's secret at all, just the ID which is public.

answered Nov 02 '12 at 15:13

user940016

2,878
7
35
56

score 0 · Answer 2 · edited May 23 '17 at 12:12

0

You could use expand the DBHelper and run certain queries through a simple encryption util like the one noted in this answer.

Or rip out the CrypoHelper from android-passwordsafe written by Steven Osborn.

edited May 23 '17 at 12:12

Community

1
1

answered Aug 31 '12 at 16:05

scottyab

23,621
16
94
105

Encrypting only specific tables / fields of an SQLite database

2 Answers2