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

**URL:** <https://discuss.zetetic.net/t/after-encrypting-the-db-using-the-sqlcipher-every-time-password-is-required-to-open-the-database/2698>\
**Category:** SQLCipher\
**Created:** [March 7, 2018, 4:45am UTC](https://discuss.zetetic.net/t/after-encrypting-the-db-using-the-sqlcipher-every-time-password-is-required-to-open-the-database/2698 "2018-03-07T04:45:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Malyadri](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@Malyadri](https://discuss.zetetic.net/u/Malyadri)\
**Post date:** [March 7, 2018, 4:45am UTC](https://discuss.zetetic.net/t/after-encrypting-the-db-using-the-sqlcipher-every-time-password-is-required-to-open-the-database/2698/1 "2018-03-07T04:45:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [March 7, 2018, 2:02pm UTC](https://discuss.zetetic.net/t/after-encrypting-the-db-using-the-sqlcipher-every-time-password-is-required-to-open-the-database/2698/2 "2018-03-07T14:02:06Z")

</div>

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](https://discuss.zetetic.net/t/sqlcipher-performance/14) guidance.

---

<div class="post-metadata">

**Author:** ![Malyadri](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@Malyadri](https://discuss.zetetic.net/u/Malyadri)\
**Post date:** [March 7, 2018, 4:54pm UTC](https://discuss.zetetic.net/t/after-encrypting-the-db-using-the-sqlcipher-every-time-password-is-required-to-open-the-database/2698/3 "2018-03-07T16:54:57Z")

</div>

Thank you,

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

---

<div class="post-metadata">

**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\
**Post date:** [March 7, 2018, 8:18pm UTC](https://discuss.zetetic.net/t/after-encrypting-the-db-using-the-sqlcipher-every-time-password-is-required-to-open-the-database/2698/4 "2018-03-07T20:18:32Z")

</div>

Hello @Malyadri

This question was recently answered here:

> [@Where can see the encrypted data in db after encrypting db using the SQLCipher?](https://discuss.zetetic.net/t/where-can-see-the-encrypted-data-in-db-after-encrypting-db-using-the-sqlcipher/2696/8):
>
> 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.