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
5
votes
2 answers

SQL Cursor throws out of memory while calling getString

Attachment Reference to my earlier question :- Out of memory I would try to be as precise as possible. I am getting a response from my web-service call a long base64 string. I decode the string and get a huge string which contains my data. I…
Android
  • 3,828
  • 9
  • 46
  • 79
5
votes
2 answers

JDBC for SQLCipher

Is there any JDBC driver exist for SQLCipher? I want to write program with javaSE and encrypted SQLite. I searched on the Internet and found nothing much on SQLCipher JDBC. Or any other free solution on encrypted SQLite beside using SQLCipher? I'm…
Betaver
  • 51
  • 1
  • 3
5
votes
1 answer

sqlcipher version migration for ios project

I was using older version of sqlcipher and open ssl for application. Now I migrated to newer version for Xcode 5 and iOS 7 compatibility, but it is not decrypting the older version of database. Please help me out. I searched on google and found…
Dhara
  • 4,093
  • 2
  • 36
  • 69
5
votes
2 answers

sqlcipher command line not working

I have a encrypted sqlite db and its key. (Which is generated by an android program). However, when I open the db in command line I can not read the db. The command line tool is installed by: brew install sqlcipher I open the database by: sqlcipher…
Min Lin
  • 3,177
  • 2
  • 19
  • 32
5
votes
5 answers

How to decrypt SQLCipher encrypted file in android?

I have developed application using SQLCipher in android. It is secure way to protect your Database file into application. It is working fine for encryption, but i want decrypt the encrypted DB file and want to look into SQLite Browser. Actually I…
Developer
  • 1,009
  • 8
  • 25
  • 56
5
votes
1 answer

Android SQLCipher and DB from assets folder

At the moment, my sqlite db file is NOT encrypted and it's copied from the assets folder to the application data/data/mypackage/databases folder. Now I want to add the SQLCipher libraries to my project and start using them. Can I encrypt the db file…
Luis Neves
  • 1,067
  • 2
  • 10
  • 21
5
votes
2 answers

Setting password in SQLCipher

I want to create a new encrypted database with SQLCipher, I didn't really undestand how to set a key due to the following link: http://sqlcipher.net/sqlcipher-api/#key As the documentation explains, I have to set a key with PRAGMA, but from where…
idish
  • 3,190
  • 12
  • 53
  • 85
5
votes
2 answers

Android using SQLCipher - how can you decrypt?

I think this question has been asked, however I have tried several of the examples to no avail. My issue is this ... I have an Android app setup to use the SQLCipher DB encryption, which works fine, on the device. In testing on an emulator, if I…
Hunter23
  • 195
  • 4
  • 11
5
votes
1 answer

Does SQLite leak memory with the SQLCipher extension?

I'm using SQLCipher to store an encrypted SQLite database. However, when I use sqlite3_key to encrypt the database, I start getting a memory leak. Observe the following sample: #include int main() { sqlite3 * connection; …
Elliot Cameron
  • 5,235
  • 2
  • 27
  • 34
4
votes
4 answers

SQLite3 database encryption -- determining encryption library?

I am considering supporting encrypted sqlite databases for a PHP application. I am using SQLite3 extension of PHP and it seems, that they already support an encryption method, at least SQLite3::__construct allows for an encryption-key to pass. What…
aurora
  • 9,607
  • 7
  • 36
  • 54
4
votes
2 answers

Adding .so files to Android project

I am trying to add SQLCipher to my project. I am able to link the jar files to the project but there is problem linking the .so files provided. Due to that I am getting UnSatisfiedLinkError when i try to open the DB. Can anyone please let me know…
Rahul Kalidindi
  • 4,666
  • 14
  • 56
  • 92
4
votes
1 answer

IS Encrypting the whole database more secure than encrypting the data only?

I have an SQLite3 database that I need to secure. I'm confused between using sqlcipher to encrypt the whole database that I use in my Electron app or simply encrypt the data using crypto dependency. Any clarification or explanation would be welcome.
4
votes
0 answers

Sqlite Database suddenly closed on devices using MDM in Native Android app

Our android application is used by thousands of user and has been live for the past four years. The app stores hundreds of thousands of rows where on a daily basis thousands are inserted, updated and removed in a number different tables. We are…
Vivek
  • 4,170
  • 6
  • 36
  • 50
4
votes
0 answers

Xamarin, SQLite and encryption (SQLCipher)

I should have my SQLite database protected by password. I found SqlCipher but I don't understand how I can use it. I defined my database public class MyDatabase { /// /// The database /// SQLiteConnection…
Enrico
  • 3,592
  • 6
  • 45
  • 102
4
votes
2 answers

Compile SQLite with SQLCipher on Windows

I am following this tutorial for compiling SQLite with SQLCipher on Windows. I am confused about pre-requisites for compilation. I found that I need to install following to compile it: OpenSSL MinGW ActiveState Perl TclTk / tclsh MSYS Visual…
Let me Ask
  • 1,029
  • 1
  • 8
  • 33