Questions tagged [sqlcipher]

SQLCipher is an open source extension to SQLite that provides transparent 256-bit AES encryption of database files.

SQLCipher is an open source extension to SQLite that provides transparent 256-bit AES encryption of database files. SQLCipher has a small footprint and great performance so it’s ideal for protecting embedded application databases and is well suited for mobile development.

  • Blazing fast performance with as little as 5-15% overhead for encryption
  • 100% of data in the database file is encrypted
  • Uses good security practices (CBC mode, key derivation)
  • Zero-configuration and application level cryptography
  • Broad platform support: works with C/C++, Obj-C, QT, Win32/.NET, Java, Python, Ruby, Linux, iPhone/iOS and Android
  • Algorithms provided by the peer reviewed OpenSSL crypto library.

Useful Links

591 questions
9
votes
1 answer

GreenDAO with Sqlcipher Integration Example

I have setup a new project using GreenDAO, was able to generate with ExampleDAO using DaoGenerator. Everything works fine. I also have a prepopulated sqlite database shipped in android assets folder, on app run, it is being copied to android…
Faisal Basra
  • 1,624
  • 4
  • 25
  • 40
9
votes
4 answers

I'm using SQLCIPHER to read or write database getting error

Hiee, i'm using sqlcipher to read the database but before reading the data it is giving the following error.Below is my logcat please have a look. E/AndroidRuntime(21826): FATAL EXCEPTION: main 02-27 11:33:10.608: E/AndroidRuntime(21826):…
Yushi
  • 416
  • 6
  • 24
9
votes
2 answers

ARC error with FMDB class after changes to building settings to compile SQLCipher

I followed the tutorial for compiling SQLCipher on iOS devices using a binary located here: http://sqlcipher.net/sqlcipher-binaries-ios-and-osx/ I've made several changes to build settings, adding header search path and C flags. Then after testing a…
Liban Abdulle
  • 177
  • 3
  • 12
8
votes
1 answer

SQLCipher - Opening an encrypted database on desktop

I'm experimenting with SQLCipher on Android. I wrote a small app that created a database with one table and a few records on the emulator. Then, I pulled the database from the emulator onto my desktop. I've looked at the SQLCipher documentation,…
Blue Dusk
  • 142
  • 1
  • 7
8
votes
3 answers

Issue in installing pysqlcipher3

So even though pip install pysqlcipher3 worked returned Successfully installed pysqlcipher3, it did not. From my research, it seems that its a common issue for Windows user trying to install Sqlcipher. Attempt #1 First, I try to download the…
Programer Beginner
  • 1,377
  • 6
  • 21
  • 47
8
votes
3 answers

Encrypt Existing Database with SQLCipher in Android

I have a database file in my assets that I copy in the app database folder. After the copy (it works), I want to encrypt the copied database with SQLCipher. For some reason, I get this error: Database: sqlite returned: error code = 26, msg =…
Mr.Sparkle
  • 173
  • 1
  • 9
8
votes
1 answer

How to build the Qt-SQL-driver-plugin 'QSQLCIPHER' for SQLite-DB with SQLCipher-extension using the Windows/MinGW-platform?

This is not typically a question where to find a step-by-step guide, but rather the guide itself. My intention with this post is to give others a hint, who have the same problems in compiling the driver-plugin as I just had recently. How to build…
Woodpecker
  • 117
  • 1
  • 5
8
votes
3 answers

Is there a correct way to test whether a user-provided SQLCipher password is valid on Android?

I'm using SQLCipher for Android and am trying to determine the correct way to test whether a user-provided password is valid. My first inclination was to just try and open the database with the given password, using the SQLCipher implementation of…
mWillis
  • 973
  • 5
  • 18
7
votes
3 answers

Unsatisfied Link error while using SQLCipher library

I am using the SQLCipher Library for Android to Encrypt/Decrypt the DB file. I am following the exact steps that were discussed in the API to add the library. But I am getting a Unsatisfied link error when i run the project... Here's the…
Rahul Kalidindi
  • 4,666
  • 14
  • 56
  • 92
7
votes
1 answer

How to encrypt/decrypt my CoreData(sqlite)? Can I use SQLCipher for it?

What I can do if I want to protect my app's database? What do I need to know for using SQLCipher?
Dimitri L.
  • 366
  • 4
  • 11
7
votes
1 answer

Using DBFlow, how to encrypt an already existing database?

I'm using DBFlow to handle databases in my project and I want to make the existing database encrypted. I know that I probably will have to drop the existing unencrypted database and create another encrypted. And I also know that I can use SQLCipher…
Natan
  • 1,867
  • 13
  • 24
7
votes
1 answer

Using pysqlcipher with SqlAlchemy?

I'm trying to add some code to my program to encrypt the sqlite database I use. I'm trying to prompt the user for password, and use that password to create a new encrypted database if it doesn't exist, or decrypt and load an existing DB. There just…
Ross Wardrup
  • 311
  • 1
  • 9
  • 26
6
votes
1 answer

SQLite Browser without SQLCipher support in Ubuntu

SQLite Browser package for ubuntu does not come with SQLCipher by default. sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser sudo apt-get update sudo apt-get install sqlitebrowser The Question How could it be enabled in order to be able to…
Camilo Silva
  • 8,283
  • 4
  • 41
  • 61
6
votes
2 answers

Android App crashes with UnsatisfiedLinkError when using SQLCipher and Crashlytics for x86_64 and arm84_v8a

I created a very minimal application, just showing "Hello World". The main activity makes a call to load the SQLCipher libraries. package companydomain.myapplication; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import…
gerhard
  • 479
  • 1
  • 6
  • 15
6
votes
4 answers

Fatal error in building SQLCipher ('openssl/rand.h' file not found)

I am trying to build SQLCipher on my mac and getting fatal error after running make. System : OS X El Capitan I installed openssl after following this instruction. Before running make I statically linked libcrypto.a with command ./configure…
mkso
  • 3,178
  • 4
  • 27
  • 35
1
2
3
39 40