Change sqlite database path to external storage

#1

Dear all
i am developing app that has its sqltite database on external storeage, so i use SQLCipher to protect my database with password. it works fine and the app work and the db is protected, but when i get the db file to open it with Sqlite Studio it doens’t work although i enter the correct password.

#2

Hi @Ultimate_Egypt

With the the release of SQLCipher 4 [1], changes including the new page size of 4096, 256,000 KDF iterations, use of PBKDF2-HMAC-SHA512 and HMAC-SHA512 all modify important database settings. Thus, SQLCipher 4 will not open older databases by default. Sqlite Studio may not contain support for interfacing with SQLCipher 4 database files.

The DB Browser for SQLite nightly builds contain support for opening the new SQLCipher 4 database file formats. You can access those builds for both macOS and Windows here [2]. Would you give that a try and let us know your results?

[1] https://www.zetetic.net/blog/2018/11/30/sqlcipher-400-release/
[2] https://nightlies.sqlitebrowser.org/latest/