# SQLCipher FAQ **URL:** https://discuss.zetetic.net/c/sqlcipher/sqlcipher-faq/7.md [Latest](https://discuss.zetetic.net/latest.md) · [Categories](https://discuss.zetetic.net/categories.md) --- ## [About the SQLCipher FAQ category](https://discuss.zetetic.net/t/about-the-sqlcipher-faq-category/15)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 0
Frequently Asked Questions and Tips for SQLCipher --- ## [SQLCipher for Android and UnsatisfiedLinkError](https://discuss.zetetic.net/t/sqlcipher-for-android-and-unsatisfiedlinkerror/7072)
**Author:** [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Replies:** 0\ **Last updated:** [September 11, 2025, 12:01pm UTC](https://discuss.zetetic.net/t/sqlcipher-for-android-and-unsatisfiedlinkerror/7072 "2025-09-11T12:01:36Z")
Some customers have experienced the java.lang.UnsatisfiedLinkError when attempting to load the native library associated with SQLCipher for Android. Based on reports, this tends to occur more often during an application … --- ## [\[Android\] How to protect licence code](https://discuss.zetetic.net/t/android-how-to-protect-licence-code/6798)
**Author:** [@chts\_cyber\_system](https://discuss.zetetic.net/u/chts_cyber_system)\ **Replies:** 1\ **Last updated:** [January 20, 2025, 2:06pm UTC](https://discuss.zetetic.net/t/android-how-to-protect-licence-code/6798 "2025-01-20T14:06:42Z")
I have added sqlcipher-android to my project. According to the tutorial and the \[Q&A\](https://PRAGMA cipher\_license = ‘OmNpZDowMDFHMDA…’;), executing: PRAGMA cipher\_license = 'OmNpZDowMDFHMDA...'; is necessary to ensur… --- ## [Upgrading to SQLCipher 4](https://discuss.zetetic.net/t/upgrading-to-sqlcipher-4/3283)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 38\ **Last updated:** [July 25, 2024, 1:00pm UTC](https://discuss.zetetic.net/t/upgrading-to-sqlcipher-4/3283 "2024-07-25T13:00:32Z")
The recent release of SQLCipher 4 introduces many new performance and security enhancements for applications that use SQLCipher for secure local data storage. However, the introduction of new default algorithms, increase… --- ## [How to encrypt a plaintext SQLite database to use SQLCipher (and avoid “file is encrypted or is not a database” errors)](https://discuss.zetetic.net/t/how-to-encrypt-a-plaintext-sqlite-database-to-use-sqlcipher-and-avoid-file-is-encrypted-or-is-not-a-database-errors/868)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 8\ **Last updated:** [October 6, 2022, 2:26am UTC](https://discuss.zetetic.net/t/how-to-encrypt-a-plaintext-sqlite-database-to-use-sqlcipher-and-avoid-file-is-encrypted-or-is-not-a-database-errors/868 "2022-10-06T02:26:33Z")
The latest guidance has been moved to the Encrypting Plaintext Databases documentation. This topic has been archived to preserve discussion. --- ## [SQLCipher: How to protect the Key?](https://discuss.zetetic.net/t/sqlcipher-how-to-protect-the-key/522)
**Author:** [@nocker](https://discuss.zetetic.net/u/nocker)\ **Replies:** 7\ **Last updated:** [November 5, 2024, 3:36pm UTC](https://discuss.zetetic.net/t/sqlcipher-how-to-protect-the-key/522 "2024-11-05T15:36:44Z")
I understand SQLCipher has good encryption. However, if your Android App passes the SQLCipher key on SQLiteDatabase.openOrCreateDatabase call, then the attacker can see the Java code and get the key. Then he would use SQ… --- ## [Json support with SQLCipher for android](https://discuss.zetetic.net/t/json-support-with-sqlcipher-for-android/6548)
**Author:** [@usergoodvery](https://discuss.zetetic.net/u/usergoodvery)\ **Replies:** 2\ **Last updated:** [July 23, 2024, 10:47pm UTC](https://discuss.zetetic.net/t/json-support-with-sqlcipher-for-android/6548 "2024-07-23T22:47:49Z")
Hi, I was wondering if there is a configuration item (ie no rebuild) to enable json with andorid? I am currently using 4.5.1. Error i am getting with json\_encode: net.zetetic.database.sqlcipher.SQLiteException: no suc… --- ## [SQLITE\_AUTH (23) Error when using SQLCipher](https://discuss.zetetic.net/t/sqlite-auth-23-error-when-using-sqlcipher/6097)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 0\ **Last updated:** [September 19, 2023, 12:55am UTC](https://discuss.zetetic.net/t/sqlite-auth-23-error-when-using-sqlcipher/6097 "2023-09-19T00:55:49Z")
When using Commercial or Enterprise packages you must call PRAGMA cipher\_license with a valid license code prior to executing cryptographic operations on an encrypted database. Failure to provide a license code, or use … --- ## [How to Include the Community Edition License in an application?](https://discuss.zetetic.net/t/how-to-include-the-community-edition-license-in-an-application/5819)
**Author:** [@shehan\_guruge](https://discuss.zetetic.net/u/shehan_guruge)\ **Replies:** 1\ **Last updated:** [March 9, 2023, 3:52pm UTC](https://discuss.zetetic.net/t/how-to-include-the-community-edition-license-in-an-application/5819 "2023-03-09T15:52:03Z")
Hi, I have used the android-database-sql-cipher in my android application and have included the license file which is mentioned in the github repo and had made sure that the license file exists in the generated apk. But… --- ## [Export Requirements for Applications Using SQLCipher](https://discuss.zetetic.net/t/export-requirements-for-applications-using-sqlcipher/47)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 7\ **Last updated:** [May 13, 2022, 9:15pm UTC](https://discuss.zetetic.net/t/export-requirements-for-applications-using-sqlcipher/47 "2022-05-13T21:15:14Z")
The latest guidance has been moved to the SQLCipher Export Requirements documentation. This topic has been archived to preserve discussion. --- ## [SQLCipher Performance Optimization](https://discuss.zetetic.net/t/sqlcipher-performance-optimization/14)
**Author:** [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Replies:** 16\ **Last updated:** [March 14, 2021, 2:01am UTC](https://discuss.zetetic.net/t/sqlcipher-performance-optimization/14 "2021-03-14T02:01:36Z")
Optimization Guidelines The latest guidance has been moved to the SQLCipher Performance Optimization documentation. This topic has been archived to preserve discussion. --- ## [Using AppCenter with SQLCipher for .NET](https://discuss.zetetic.net/t/using-appcenter-with-sqlcipher-for-net/4677)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 1\ **Last updated:** [January 5, 2021, 11:59am UTC](https://discuss.zetetic.net/t/using-appcenter-with-sqlcipher-for-net/4677 "2021-01-05T11:59:11Z")
Microsoft AppCenter provides a popular set of tools that enable crash reporting, application analytics, and other features for integrating applications. Due to the design of AppCenter, it brings in several transitive NuG… --- ## [dotConnection Support](https://discuss.zetetic.net/t/dotconnection-support/73)
**Author:** [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Replies:** 3\ **Last updated:** [June 16, 2020, 9:04am UTC](https://discuss.zetetic.net/t/dotconnection-support/73 "2020-06-16T09:04:13Z")
For those who use the dotConnect for SQLite client, support for using SQLCipher on the back end was included with their 5.2.171.0 release. Instructions for integrating dotConnect with SQLCipher can be found here. --- ## [How to check my sqlcipher version](https://discuss.zetetic.net/t/how-to-check-my-sqlcipher-version/4424)
**Author:** [@1111](https://discuss.zetetic.net/u/1111)\ **Replies:** 1\ **Last updated:** [May 26, 2020, 5:54pm UTC](https://discuss.zetetic.net/t/how-to-check-my-sqlcipher-version/4424 "2020-05-26T17:54:10Z")
Hi developer. I’m using sqlcipher database. But I have Detected problem with app native libraries. I searching google, and I found solution, sqlcipher version 3.5 up it’s ok. But I don’t know that I using what versio… --- ## [File is not a database when opening a newly created and encrypted database](https://discuss.zetetic.net/t/file-is-not-a-database-when-opening-a-newly-created-and-encrypted-database/3875)
**Author:** [@princeteekoy](https://discuss.zetetic.net/u/princeteekoy)\ **Replies:** 3\ **Last updated:** [September 10, 2019, 1:08pm UTC](https://discuss.zetetic.net/t/file-is-not-a-database-when-opening-a-newly-created-and-encrypted-database/3875 "2019-09-10T13:08:06Z")
I created a database with DbBrowser for Sqlite. Then i set Encryption from Tools menu. When i Open the database in the same application (with encryption available) the database opens. But when i open the encrypted db … --- ## [How does SQLCipher compare to other SQLite encryption extensions?](https://discuss.zetetic.net/t/how-does-sqlcipher-compare-to-other-sqlite-encryption-extensions/2864)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 5\ **Last updated:** [February 22, 2020, 2:46am UTC](https://discuss.zetetic.net/t/how-does-sqlcipher-compare-to-other-sqlite-encryption-extensions/2864 "2020-02-22T02:46:44Z")
We are sometimes asked by prospective users how SQLCipher compares to other available SQLite encryption tools from a performance and security perspective. Please read the following article to help compare SQLCipher to ot… --- ## [What is the purpose of PRAGMA cipher\_memory\_security?](https://discuss.zetetic.net/t/what-is-the-purpose-of-pragma-cipher-memory-security/3953)
**Author:** [@aliaksandr.tabunou](https://discuss.zetetic.net/u/aliaksandr.tabunou)\ **Replies:** 4\ **Last updated:** [October 2, 2019, 3:15pm UTC](https://discuss.zetetic.net/t/what-is-the-purpose-of-pragma-cipher-memory-security/3953 "2019-10-02T15:15:19Z")
--- ## [Can SQLite and SQLCipher be used simultaneously?](https://discuss.zetetic.net/t/can-sqlite-and-sqlcipher-be-used-simultaneously/3609)
**Author:** [@srikanth1003](https://discuss.zetetic.net/u/srikanth1003)\ **Replies:** 3\ **Last updated:** [April 23, 2019, 9:05pm UTC](https://discuss.zetetic.net/t/can-sqlite-and-sqlcipher-be-used-simultaneously/3609 "2019-04-23T21:05:54Z")
Hi, I have an android app which uses a library which in turn uses SQLite to store the data. Now I want to use SQLCipher to store some confidential info. As per documentation https://www.zetetic.net/sqlcipher/design/ u… --- ## [Management Interfaces for SQLCipher Databases](https://discuss.zetetic.net/t/management-interfaces-for-sqlcipher-databases/121)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 2\ **Last updated:** [April 22, 2019, 1:22pm UTC](https://discuss.zetetic.net/t/management-interfaces-for-sqlcipher-databases/121 "2019-04-22T13:22:50Z")
Users often need to interact with SQLCipher encrypted databases outside of application code for testing, database development, and troubleshooting. There are a few options for managing SQLCipher databases outside of your… --- ## [Does SQLCipher support JDBC?](https://discuss.zetetic.net/t/does-sqlcipher-support-jdbc/3398)
**Author:** [@Jackxwb](https://discuss.zetetic.net/u/Jackxwb)\ **Replies:** 1\ **Last updated:** [January 31, 2019, 2:30pm UTC](https://discuss.zetetic.net/t/does-sqlcipher-support-jdbc/3398 "2019-01-31T14:30:48Z")
My project is based on SpringBoot framework + Mybatis,how do I add SQLCipher to my project --- ## [Important Advisory: Magellan and SQLCipher](https://discuss.zetetic.net/t/important-advisory-magellan-and-sqlcipher/3299)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 0\ **Last updated:** [December 18, 2018, 9:57pm UTC](https://discuss.zetetic.net/t/important-advisory-magellan-and-sqlcipher/3299 "2018-12-18T21:57:14Z")
Magellan is a SQLite remote code execution vulnerability. Discovered by Tencent Blade Team, this problem can potentially affect applications that use SQLite versions prior to 3.26.0. By extension, because SQLCipher is ba… --- ## [Upgrading to SQLCipher 4 for .NET applications using the SQlite-net API](https://discuss.zetetic.net/t/upgrading-to-sqlcipher-4-for-net-applications-using-the-sqlite-net-api/3284)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 0\ **Last updated:** [December 10, 2018, 9:59pm UTC](https://discuss.zetetic.net/t/upgrading-to-sqlcipher-4-for-net-applications-using-the-sqlite-net-api/3284 "2018-12-10T21:59:43Z")
Starting with version 4, SQLCipher Commercial and Enterprise packages for Microsoft .NET feature a completely revamped client API. This new integration approach adds features and new supported interfaces, however, it doe… --- ## [Notifications about security bugs in SQLCipher](https://discuss.zetetic.net/t/notifications-about-security-bugs-in-sqlcipher/3167)
**Author:** [@soeren](https://discuss.zetetic.net/u/soeren)\ **Replies:** 2\ **Last updated:** [October 18, 2018, 8:30am UTC](https://discuss.zetetic.net/t/notifications-about-security-bugs-in-sqlcipher/3167 "2018-10-18T08:30:26Z")
Hello, we’d like to use the community version of SQLCipher in our project but are worried about missing security fixes you might release in future. Are you reporting such bugs as CVE ? (there is no CVE so far) What re… --- ## [How to find version and edition of my sqlcipher android library](https://discuss.zetetic.net/t/how-to-find-version-and-edition-of-my-sqlcipher-android-library/3022)
**Author:** [@Manjeet\_Sudhanshu](https://discuss.zetetic.net/u/Manjeet_Sudhanshu)\ **Replies:** 1\ **Last updated:** [August 21, 2018, 1:18pm UTC](https://discuss.zetetic.net/t/how-to-find-version-and-edition-of-my-sqlcipher-android-library/3022 "2018-08-21T13:18:53Z")
My android application is using Sqlcipher library. It includes 3 .so file (libdatabase\_sqlcipher.so , libgnustl\_shared.so, libsqlcipher\_android.so) and .jar files (sqlcipher.jar, guava-r09.jar, commons\_codec.so). How … --- ## [Android Studio Integration](https://discuss.zetetic.net/t/android-studio-integration/65)
**Author:** [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Replies:** 10\ **Last updated:** [July 28, 2016, 2:03pm UTC](https://discuss.zetetic.net/t/android-studio-integration/65 "2016-07-28T14:03:27Z")
Android Studio uses the Gradle-based build system, so project integration is slightly different than our standard integration guide within an Android project. In this case, the location of the native libraries and the a… --- ## [Important Advisory: SQLCipher with Xcode 9 and new SDKs](https://discuss.zetetic.net/t/important-advisory-sqlcipher-with-xcode-9-and-new-sdks/2371)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 6\ **Last updated:** [December 24, 2017, 4:17pm UTC](https://discuss.zetetic.net/t/important-advisory-sqlcipher-with-xcode-9-and-new-sdks/2371 "2017-12-24T16:17:56Z")
Apple has recently released Xcode 9, along with new SDKs (e.g. iOS 11, watchOS 4, etc), with new features and enhancements. Most projects that include recent versions of SQLCipher shouldn’t have any problems upgrading. H… --- ## [Important Advisory: SQLCipher with Xcode 8 and new SDKs](https://discuss.zetetic.net/t/important-advisory-sqlcipher-with-xcode-8-and-new-sdks/1688)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 0\ **Last updated:** [September 14, 2016, 8:56pm UTC](https://discuss.zetetic.net/t/important-advisory-sqlcipher-with-xcode-8-and-new-sdks/1688 "2016-09-14T20:56:29Z")
Note: Updated to clarify that this guidance applies to all projects built with Xcode 8, including for non-iOS targets). Apple has recently released XCode 8, along with new SDKs (e.g. iOS 10, watchOS 3, mac OS, tvOS), wi… --- ## [Android: how to check if a database is already encrypted?](https://discuss.zetetic.net/t/android-how-to-check-if-a-database-is-already-encrypted/1481)
**Author:** [@ddobrev](https://discuss.zetetic.net/u/ddobrev)\ **Replies:** 2\ **Last updated:** [June 28, 2016, 1:28pm UTC](https://discuss.zetetic.net/t/android-how-to-check-if-a-database-is-already-encrypted/1481 "2016-06-28T13:28:05Z")
I have an Android application which works with a database need to check for being encrypted, and encrypt it if not. I don't want to save the encrypted database to a new file. I know I can try opening it with an empty pas… --- ## [SQLCipher Database Key Material and Selection](https://discuss.zetetic.net/t/sqlcipher-database-key-material-and-selection/25)
**Author:** [@sjlombardo](https://discuss.zetetic.net/u/sjlombardo)\ **Replies:** 0\ **Last updated:** [July 23, 2014, 4:50pm UTC](https://discuss.zetetic.net/t/sqlcipher-database-key-material-and-selection/25 "2014-07-23T16:50:51Z")
The latest guidance has been moved to the SQLCipher Database Key Material and Selection documentation. This topic has been archived to preserve discussion. --- ## [CoreData vs. SQLite](https://discuss.zetetic.net/t/coredata-vs-sqlite/487)
**Author:** [@mcheline](https://discuss.zetetic.net/u/mcheline)\ **Replies:** 1\ **Last updated:** [March 25, 2015, 2:24pm UTC](https://discuss.zetetic.net/t/coredata-vs-sqlite/487 "2015-03-25T14:24:46Z")
We are new to iOS development and are planning to move our mobile application from Windows to iPad. Our data must be encrypted and FIPS 140 compliant. We are evaluating the use of SQLite and CoreData for the underlying d… [Next page](https://discuss.zetetic.net/c/sqlcipher/sqlcipher-faq/7.md?page=1)