Stack Overflow
Stack Overflow

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
0
votes
1 answer

How to fix the error i am getting while running SQL Cipher project?

I followed the tutorial SQLCipher tutorial from beginning to end. Still i am getting 3 issues when i try to build the project. Please check the image below Note: The libraries libcrypto.a and libsqlcipher.a are red in color. Does this an…
surendher
  • 1,374
  • 3
  • 26
  • 52
0
votes
1 answer

SQLCipher vs Encrypting the data before storing in sqliteDB

Is there is any difference in (encrypting the data before storing in sqliteDB) , (using SQLCipher along with sqliteDB).? Because in both the case a hacker can able to get my passphrase(He might get from reverse engineering my code) and read my db,…
Nasrudeen
  • 425
  • 5
  • 18
0
votes
1 answer

Decrypt sqlite3 database file from Android on another system

I make encrypted file on Android system. I have the key for the database. I tried to decrypt the Android database on my Mac system using sqlcipher. However, it cannot open the file. Is there a way to open encrypted database file from other system?
user3182376
  • 1
  • 1
0
votes
2 answers

SQLCipher "sqlite3_key" encrypted database can't be opened using SqliteManger tool

here is my code to create a new encrypted database sqlite3 *db; if (sqlite3_open([databasePath UTF8String], &db) == SQLITE_OK) { const char* key = "sssri"; //the key to encrypt the database sqlite3_key(db, key, strlen(key)); //using…
chenakira
  • 131
  • 1
  • 10
0
votes
1 answer

SQLCipher Android and hexkey encryption

I've created an encrypted database using C#-SQLite after reading that it was compatible with SQLCipher. I'm using the following command to encrypt: PRAGMA hexkey="0x0102030405060708090A0B0C0D0E0F01"; I'm attempting to open the file using SQLCipher…
JWood
  • 2,804
  • 2
  • 39
  • 64
0
votes
1 answer

Database encrypted by SQLCipher in an iOS app is becoming permanently inaccessible

I recently modified my iOS app to enable serialized mode for both a database encrypted using SQLCipher and a non-encrypted database (also SQLite). I also maintain a static sqlite3 connection for each database, and each is only opened once (by simply…
Jayko
  • 3
  • 2
0
votes
2 answers

sqlite3_exec returns 26 in linux

i am writing an application which encrypt the SQLITE3 database. for encryption i have used SQLCIPHER.i am able to perform encryption and decryption of Database from command line.i am writing the client app using c++. here is my code to test the key…
user2094814
  • 27
  • 1
  • 1
  • 7
0
votes
2 answers

Android Sqlchipher: net.sqlcipher.database.SQLiteException: file is encrypted or is not a database

I have using Sqlcipher for my database encryption. I am using SQLiteDatabase.openDatabase for creating, editing and read the sqlchiphered database. I could open ,read and edit properly but suddenly i got the follwing error and after that i couldnt…
Sudarshan
  • 1,291
  • 3
  • 26
  • 35
0
votes
2 answers

Android: SqliteDatabase's lastModified() is giving wrong value

I am using sqlcipher database. I am tracking the lastModified time of my database. According to my understanding long value returned by lastModified() function will change only if we update or add a value to the database we refer. I am using a query…
Sudarshan
  • 1,291
  • 3
  • 26
  • 35
0
votes
0 answers

Encrypting a SQLite database

I'm with a doubt about SQLite in Android. In the SQLite documentation, they say that I can encrypt my database using the following command before anything: PRAGMA key=text-key; PRAGMA hexkey=hexadecimal-key; But when I use this in Android the…
Elvis Oliveira
  • 941
  • 2
  • 15
  • 29
0
votes
3 answers

StringIndexOutOfBoundsException in SQLiteDatabase rawQuery()

I cannot get around this Exception. Am i missing something obvious? Stack Trace 12-05 20:07:43.129: E/AndroidRuntime(4154): FATAL EXCEPTION: Thread-1470 12-05 20:07:43.129: E/AndroidRuntime(4154): java.lang.StringIndexOutOfBoundsException: length=0;…
Vinay W
  • 9,912
  • 8
  • 41
  • 47
0
votes
1 answer

SQLCipher with asymmetric encryption

Is it possible to encrypt data with SQLCipher using a private key? The intention is to store some sensitive data encrypted on the device that can be decrypted for debugging purposes. Unfortunately the SQLCipher documentation just mentions…
Quxflux
  • 3,133
  • 2
  • 26
  • 46
0
votes
0 answers

How to use SQLCipher with a ContentProvider in Android

im trying to change my exiting code of an app that uses a ContentProvider to store data to use a cipher database with SQLCipher. This is my ContentProvider code: import net.sqlcipher.database.SQLiteDatabase; import…
tonibaca
  • 1
0
votes
1 answer

Android SQLCipher BLOB Performance

I want to store blobs in a sql database thats encrypted by sql cipher. My blobs are images with an average size of 40kb. Has anyone of you experience with sql cipher and blobs? I would like to know if i can expect an acceptable performance.
Ostkontentitan
  • 6,930
  • 5
  • 53
  • 71
0
votes
2 answers

Nullpointer exception while Creating records and inserting values in database- also using SQL-cipher

Cipher for my database , i am trying to insert the record values but i am getting nullpointer exception while creating the record and inserting the values, below is my Databasehelper code public class DatabaseHelper extends SQLiteOpenHelper { …
teekib
  • 2,821
  • 10
  • 39
  • 75
1 2 3
…
39 40