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

[Malyadri]

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

[developernotes]

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.

[Malyadri]

Thank you,

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

[developernotes]

Hello @Malyadri

This question was recently answered here:

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

Hi @Usharani The temporary files will be generated within the same directory the database file exists within. As the are temporary, you will not always see them, however inserting data into the database within a transaction will create a temporary journal file until the transaction is completed.