Join Us!

Encrypted SQLite da...
 
Notifications
Clear all

Encrypted SQLite databases  

  RSS
PaulSanderson
(@paulsanderson)
Senior Member

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

Quote
Posted : 17/04/2018 6:26 pm
mcman
(@mcman)
Active 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

ReplyQuote
Posted : 17/04/2018 6:46 pm
PaulSanderson
(@paulsanderson)
Senior Member

Thanks Jamie

I have looked at Wickr and it confirms my thoughts.

Cheers

ReplyQuote
Posted : 18/04/2018 4:11 pm
mcman
(@mcman)
Active 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

ReplyQuote
Posted : 18/04/2018 7:01 pm
Share: