Encrypted SQLite databases
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.
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.
I have looked at Wickr and it confirms my thoughts.
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.