Encrypted SQLite da...
 
Notifications
Clear all

Encrypted SQLite databases

4 Posts
2 Users
0 Likes
1,162 Views
PaulSanderson
(@paulsanderson)
Posts: 651
Honorable Member
Topic starter
 

I am doing some research into SQLite encryption and I am looking for examples of SQLite databases or rather applications that are encrypted at an SQLite level, i.e. the SQLite.dll/library provides the encryption at a page level, rather than something like WhatsApp which encrypt the DB at a file level.

If anyone has any examples of these then please let me know.

Thanks

 
Posted : 17/04/2018 5:26 pm
(@mcman)
Posts: 189
Estimable Member
 

Let me dig something up Paul, I wrote a few slides on it a year back or so. Some apps would encrypt the entire db, others would just encrypt specific columns within the db. It would also vary between OSs (Android version of the same app would be different than the iOS version).

I wanna say Wickr, Signal, BBM, Tango (encoded, not encyrpted), KakaoTalk, etc. were a few but I can't recall off the top of my head which version did what. I'll see what I can find.

Jamie

 
Posted : 17/04/2018 5:46 pm
PaulSanderson
(@paulsanderson)
Posts: 651
Honorable Member
Topic starter
 

Thanks Jamie

I have looked at Wickr and it confirms my thoughts.

Cheers

 
Posted : 18/04/2018 3:11 pm
(@mcman)
Posts: 189
Estimable Member
 

Yeah I want to say the Android version of Wickr is a fully encrypted db and uses SQLCipher but the iOS version is an unencrypted db with encrypted BLOB data inside…again been a while so I haven't looked at the newer versions of the apps myself.

Let me know if you need anything else.

Jamie

 
Posted : 18/04/2018 6:01 pm
Share: