How can I default to sqlcipher4 with sequelize?

[rohit5ram]

const Sequelize = require("sequelize");
const db = new Sequelize({
    dialect: 'sqlite',
    storage: path.join(process.cwd(), "sample.db"),
    dialectModulePath: '@journeyapps/sqlcipher',
    logging: false,
    define: {
        freezeTableName: true
    }
});
db.query("PRAGMA key = 'password'");

I am not able to open the sample.db file with sqlitebrowser SQLCIPHER 4.

The only way its works is by adding the below line and then use SQLICIPHER 3 in sqlitebrowser db.query('PRAGMA cipher_compatibility = 3');

[rkistner]

Which version of this package are you using?

The SQLCipher 4 defaults should be used by default, so I'm not sure why this isn't working.

You can try to set the individual parameters explicitly to match sqlitebrowser:

PRAGMA cipher_page_size = 4096;
PRAGMA kdf_iter = 256000;
PRAGMA cipher_hmac_algorithm = HMAC_SHA512;
PRAGMA cipher_kdf_algorithm = PBKDF2_HMAC_SHA512;

[rohit5ram]

@rkistner I use @journeyapps/sqlcipher": "^4.1.0

[rkistner]

I've tested with @journeyapps/sqlcipher versions 4.1.0 and 5.0.0, and couldn't reproduce in either version.

Tested with sqlitebrowser 3.12.99 / sqlcipher 4.3.0.

If you still run into the issue, I recommend:

1. Test with the sqlcipher CLI instead of sqlitebrowser.
2. Test using this library directly, without sequelize.

Also check whether adding PRAGMA cipher_compatibility = 4 (before setting the key) makes a difference.