Does SQlLite supports Encryption and Decryption

Oct 17, 2013 at 9:56 AM
Hi all,
Does SQlLite supports Encryption and Decryption of the db as done by SQLChiper
Oct 17, 2013 at 10:08 AM

The SQLite engine for Windows Phone and Windows 8.x does not have encryption built in, like SQLCipher.

You can use standard encryption classes to encrypt sensitive data before storing in the database, saving the encrypted data stream as a byte array in a BLOB column, or as a base64 encoded string.

Jan 10, 2014 at 5:07 PM
The problem is, if that sensitive data is queryable, how can we use the encrypted data in "where" clause?

Let say, I want to do something like this, "SELECT amount FROM account WHERE acc_number = :accNumber ", where the acc_number column is encrypted sensitive data. Encrypting value we want to throw at it also not viable since encryption of the same value tend to give different result and if we use this value, the query will returning zero result.

I guess until we can find a way to encrypt the whole database, we won't port our apps to WinRT just yet. And of course, Windows Phone also postponed to wait an encrypted database solution that supported on both platform since using SQL Compact would double our work on maintain Windows Phone and WinRT version in the future.