After encrypting the Db using the SQLCipher, every time password is required to open the database?


#1

Is Password/passphrase needed every time to open the DB connection ?
What is the best database pagesize


#2

Hi @Malyadri

Is Password/passphrase needed every time to open the DB connection ?

Yes, the password is required every time you open a connection to the database.

What is the best database pagesize

We generally recommend the default page size, but you are welcome to experiment with alternative sizes for your application. Keep in mind that if you use a non-standard cipher page size that migrating from major version file formats will be more cumbersome.

You may benefit from reviewing our general SQLCipher Performance guidance.


Where can see the encrypted data in db after encrypting db using the SQLCipher?
#3

Thank you,

Are there any temporary files being created after the encryption ? If yes, where we can see those file?


#4

Hello @Malyadri

This question was recently answered here: