Document 64-bit compatibility

[brody4hire]

There has been some confusion about getting this project to work with 64-bit systems, for example:

• https://discuss.zetetic.net/t/crashing-when-running-sql-cipher-on-nexus-9/639
• https://discuss.zetetic.net/t/sqlcipher-on-android-5-0-x64-emulator-crash/286

The answer is to make sure you do not have any 64-bit .so libraries in your Android app, as described:

• this answer: https://discuss.zetetic.net/t/crashing-when-running-sql-cipher-on-nexus-9/639/15
• http://ph0b.com/android-abis-and-so-files/

Assuming that #151 is not merged anytime soon (apparently because the OpenSSL project does not support 64-bit Android builds), this answer needs to be documented very clearly.

[developernotes]

Hi @brodybits

I think an addendum to the compatibility section of the README would be sufficient. Do you think it should be noted elsewhere?

[brody4hire]

That would be good. But what about those who just reference your web page at https://www.zetetic.net/sqlcipher/sqlcipher-for-android/ and get the binaries (by following the link to https://www.zetetic.net/sqlcipher/open-source/) without even looking at this github project?

[developernotes]

A disclaimer can be added to the tutorial, however I would like to avoid duplicating compatibility information in multiple locations.

[brody4hire]

Yes a disclaimer would be good, if it is very clear what the issue is and how it can bite someone:)

Someone encountered a similar problem in storesafe/cordova-sqlite-storage#284 when combining my sqlite plugin with https://github.com/jbavari/cordova-plugin-video-editor.

[brody4hire]

Something else. The changes in #151 to support 64-bit targets would cause another minor diversion of the source code from the Android sqlite database source. It would be better to update the source code to match the changes from Android 5.0, if someone wants to make the effort.

[brody4hire]

Closing in favor of #251

[amorenew]

sql-cipher require openssl which doesn't support 64bit yet

[developernotes]

Hi @amorenew

SQLCipher core supports multiple crypto providers, OpenSSL being one of them. While SQLCipher for Android has not included 64-bit native libraries, we plan to investigate using OpenSSL 1.1.0 in the next release with the hopes of expanding target architecture support. Previous versions of OpenSSL did not build 64-bit support for Android without build chain modification. In the interim, SQLCipher for Android will run on 64-bit CPU's using the 32-bit native libraries, please see this note.

[amorenew]

@developernotes OpenSSL 1.1.0 not supported 64bit
https://www.openssl.org/news/openssl-1.1.0-notes.htmlyou
i faced the issue of UnsatisfiedLinkError
with https://github.com/Raizlabs/DBFlow
thanks for your effort
well done

[developernotes]

Hi @amorenew

OpenSSL 1.1.0 not supported 64bit
https://www.openssl.org/news/openssl-1.1.0-notes.html

That link does not state reference 64-bit or Android. Did you read that somewhere else?

[amorenew]

No @developernotes

[amorenew]

in this link OpenSSL member said it's in 1.1.0 openssl/openssl#333 (comment)

[developernotes]

Hi @amorenew

Right, @mattcaswell mentioned they have included 64-bit Android support in 1.1.0. We intend to investigate that further with our next release of SQLCipher.