brodycj / ask-me-anything

ASK ME ANYTHING such as support, ideas, or personal questions
Creative Commons Attribution 4.0 International
4 stars 1 forks source link

Starting new Cordova SQLCipher+Android plugin support #23

Open brodycj opened 4 years ago

brodycj commented 4 years ago

updated:

An organization has ordered a build of the new Cordova SQLite plugin design (#3) with SQLCipher on Android. An early preview of the progress is available here:

It is actually using JNI/JDK source code from here:

adding reference to https://github.com/sqlcipher/sqlcipher/issues/125 - simpler version for Android

brodycj commented 4 years ago

A general observation of the SQLCipher C library is that if an application opens a database and then uses sqlite3_key() to use a password, SQLCipher will do nothing with the password until the application attempts to read or write data. This can make it a little tricky to test password error handling.

I think a stranger observation is that if an application opens a new database and then uses sqlite3_key() to set the password, the database would have zero size until the application starts writing data. I think this makes the password error testing even more tricky to get right.

P.S. I raised the following discussion: https://discuss.zetetic.net/t/when-password-from-sqlite3-key-is-applied/4339