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
3
votes
0 answers

Encrypt sqlite table of a Python Tkinter App - pysqlcipher? How is it secure?

I have made a tkinter desktop application and I have a table named auth with a single row which contains sensitive API credentials. My thought is to encrypt this table using pysqlcipher (link) or equivalent. According to the documentation, you have…
Jarad
  • 17,409
  • 19
  • 95
  • 154
3
votes
1 answer

App crash on adding Realm along with SQLCipher on Samsung Galaxy S6 edge

My app crashed while adding Realm to my project with existing SQLCipher on Samsung Galaxy S6 edge but runs fine on Samsung Note 3. Crashlogs:- java.lang.UnsatisfiedLinkError: dalvik.system.PathClassLoader[DexPathList[[zip file…
Omkar Amberkar
  • 1,952
  • 4
  • 16
  • 21
3
votes
1 answer

iOS: SQLCipher & SQLite performance?

I want to use SQLCipher to encrypt the database but i'm not sure about the performance. How many percent of performance have to be sacrificed if i switch to use SQLCipher instead of using SQLite? My database have around 4 tables , 10.000 records per…
TomSawyer
  • 3,711
  • 6
  • 44
  • 79
3
votes
2 answers

SQLCipher causing crash on Android in Signed Release APK

I am using SQLCipher in an android project. All works well in testing, but whenever I built a signed release APK and installed it I am receiving the following error and crash whenever I call SQLCipher.loadLibs(context); Here is the crash 03-09…
nserror
  • 727
  • 8
  • 19
3
votes
0 answers

android SQLCipher error

Hi I am developing android application in which I am using SQLCipher along with Activeandroid.I tried to implement it in following way: In my Lib folder I have included : commons-codec.jar, guava-r09.jar, sqlcipher.jar. And in armeabi folder…
nilkash
  • 7,408
  • 32
  • 99
  • 176
3
votes
1 answer

Unable to open pysqlcipher-encrypted dictionary in command-line sqlcipher tool

I am able to create an encrypted database using pysqlcipher, and open it with pysqlcipher, but somehow I cannot open the same database using the sqlcipher command0line tool installed on Mac OS X when installing sqlcipher from source. For…
Herman Schaaf
  • 46,821
  • 21
  • 100
  • 139
3
votes
2 answers

How can i encrypt particular column data in Android SQLite Data base.Using SQLCipher utility

I have a SQLite DB in android, and I want to encrypt only few columns in that DB. I founded that its available with whole DB to encrypt, but I need to encrypt only few columns data only.
Hari Enaganti
  • 359
  • 1
  • 4
  • 12
3
votes
1 answer

Ormlite after updated table I can't use query for all method

I'm developing an application which is using ormlite and sqlcipher. I need to rename column without user loosing all it's data. But after I update the column - I can't use ormlite's queryForAll method. I tried searching for the problem, but there…
Gediminas Bublys
  • 403
  • 1
  • 4
  • 10
3
votes
0 answers

Can I encrypt a purely in-memory database using SQLCipher?

The official SQLite Encryption Extension does not support encrypting in-memory databases per their documentation: https://www.sqlite.org/see/doc/trunk/www/readme.wiki Limitations TEMP tables are not encrypted. In-memory (":memory:") databases are…
Mike C.
  • 621
  • 8
  • 13
3
votes
1 answer

pysqlcipher installation - SyntaxError: Missing parentheses in call to 'print'

I have Python 3.4.2, and I try to install pysqlcipher on my PC with windows 8. After having entered the code below in my command prompt: git clone https://github.com/leapcode/pysqlcipher/ cd pysqlcipher python setup.py build_sqlcipher I’m getting…
FrancNovation
  • 349
  • 6
  • 20
3
votes
1 answer

How to use encryption in SQLite database

I have developed an application for which I am using sqlite database .Now I want to encrypt the database using SQLcipher .Can I encrypt my existing database using SQLcipher?
3
votes
1 answer

Finalizing a Cursor that has not been deactivated or closed - ormlite android sqlcipher

I'm having a problem using the ormlite-android-sqlcipher-4:48 library and SQLCipher.for.Android.v3.1.0 to perform the encryption of SQLite file. I believe that the error happens because I'm using ForeignCollectionField with the property 'eager =…
3
votes
2 answers

Executing an external program in Java returns "Access denied" or stops execution

Update 3 Progress! I wrote a CMD script which takes three parameters: the absolute path to sqlite3cipher.exe the absolute path to testdb the absolute path to statements.sql All the script does is execute the command path\to\sqlite3cipher.exe…
Christian
  • 707
  • 1
  • 7
  • 15
3
votes
2 answers

file is encrypted or is not a database (Exception net.sqlcipher.database.SQLiteException)

I'm trying to use sqlcipher lib to encrypt my database from already existing database but while accessing the old database(i.e opening the db) gives this exception: 02-27 13:12:21.231: E/AndroidRuntime(14687): FATAL EXCEPTION: main 02-27…
Maveňツ
  • 1
  • 12
  • 50
  • 89
3
votes
1 answer

Encrypt/Decrypt existing database using SQLCipher in Android

I'm using the below piece of code to encrypt and decrypt the database i'm able to encrypt but when i'm trying to decrypt i'm getting the below exception.I referred this documentation and TestCases too still facing the same problem. …
Srikanth Roopa
  • 1,782
  • 2
  • 13
  • 19