Episode 17 - Transparent SQLite Encryption With SQLCipher
In this interview, Stephen Lombardo and Billy Grey of Zetetic talk about SQLCipher, their transparent OSS encryption add-on to SQLite. SQLCipher encrypts/decrypts just above the write-from/read-to disk level which keeps the SQLite programming model unchanged. You do queries as you normally would, and all of the functionality is retained: your selects, inserts, updates, indexes, etc. all work as with an unencrypted database. Stephen and Billy also talk about getting an app with crypto into the store, including their experiences with the US Department of Commerce and the NSA’s technical review.