Setting a password in SQLCipher

Question

I want to create a new encrypted database with SQLCipher, I really did not understand how to install the key due to the following link: http://sqlcipher.net/sqlcipher-api/#key

As explained in the documentation, I have to install the key using PRAGMA, but where can I use this command?

Answer 1

For Android, you just need to call openOrCreateDatabase to provide the encryption key. The second parameter is the passphrase to be used.

SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(databaseFile, "test123", null); 

The PRAGMA key interface provides the same function when using the SQLCipher command line.

Answer 2

you should read: sqlcipher.net/introduction Assembly instructions should provide you with a utility that will be a command-line shell (based on sqlLite) for SQLCipher.