How does SQLCipher compare to other SQLite encryption extensions?

SQLCipher SQLCipher FAQ
1

We are sometimes asked by prospective users how SQLCipher compares to other available SQLite encryption tools from a performance and security perspective. Please read the following article to help compare SQLCipher to other SQLite Encryption extensions:

1 Like
2

I am wondering the encryption process? Does it encrypt or decrypt the database file page by page in a whole ?

3

@yep_zhang - SQLCipher encrypts and decrypts the database on a per page basis, but only as needed. If only a few pages are needed to execute a statement, only those pages are in scope. You can see more details on the design page.

4

So when we type "pragam key = 'aaa‘ " in the command line, it doesn’t encrypt or decrypt the whole database file actually?

5

Hi @yep_zhang,

Not initially, that only provides the password to be used within PBKDF2 to derive your encryption key (unless you provide a raw key format). Encryption/decryption is deferred until the execution of a SQL command.

6

I truly appreciate your timely help. :100: