Can I mix both cordova-sqlite-ext and cordova-sqlcipher-adapter to load pre-populated encrypted db file?

[JeongJun-Lee]

I installed both cordova-sqlite-ext and cordova-sqlcipher-adapter normally.

And I tried to open the encrypted db with key option by below code,

private options = { name: 'pos.db', key: 'test', location: 'default', createFromLocation: 1 };
this.sqlite.create(this.options).then((db: SQLiteObject) => {...}

Like attachment, the db file is opened well, but the table in the db cannot be found.

[brodycj]

This combination is not supported and not expected to work. I will document this as a pitfall when I get a chance. Closing as a duplicate of storesafe/cordova-sqlite-storage#719, brodycj/cordova-sqlite-ext#67, and now brodycj/cordova-sqlite-ext#69.

[brodycj]

I just raised apache/cordova-discuss#81 to safeguard against such a combination in the Cordova framework.

[brodycj]

From storesafe/cordova-sqlite-storage#719 (comment) (@brodybits):

In case of multiple sqlite plugins installed the behavior should be considered UNDEFINED. It may lead to compile error, runtime error, data loss due to multiple sqlite problem discussed in #626 (litehelpers/Cordova-sqlite-storage#626), other forms of data loss, etc. etc. Will be documented.

Will also be documented in this plugin version.