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

Offline and security in iOS App

I am designing offline features for an app which caches data in offline mode and provides them to users. The app also needs to support the login feature in the offline mode. I am seeing Sqlicipher as a better option than Core data security with…
RK-
  • 12,099
  • 23
  • 89
  • 155
3
votes
1 answer

SQLCipher + POCO C++

I'm trying to replace POCO's sqlite with sqlcipher on my Mac Lion. There's not a lot of info around in regards to the build process and replacement, however I figured I should give it a try. I've got the sqlcipher amalgamation, then I've replaced…
deadringer
  • 303
  • 2
  • 11
3
votes
1 answer

static link openssl to sqlcipher

I have build sqlcipher for Linux but it depends on openssl. I want to configure sqlcipher to work without external openssl library by linking it statically. I configure sqlcipher with this command ./configure…
dream2work
  • 1,377
  • 2
  • 10
  • 18
2
votes
2 answers

my application crashes when using sql cipher

i am using sql cipher(sql cipher for android) in my app and it work well with android tablets and also with version above android 2.3 .But it crashes in android 2.2 version .can any one know about this problem and if yes please give me a solution.I…
Sujiz
  • 1,720
  • 1
  • 20
  • 30
2
votes
4 answers

How do I secure my Database sqlite in the Assets Folder (by Ciphering)?

I have had experiences of Reverse engineering and people taking access of your Database quiet fluently in android. I would like to know is there any way i can cipher my Database only(not obfuscating the whole apk) at the time of Creation and then…
Some one Some where
  • 777
  • 1
  • 8
  • 26
2
votes
1 answer

Using SQLCipher with MonoTouch

I've compiled a static library and linked both SQLCipher and OpenSSL. The full project, makefile, and compiled library can be found here: https://github.com/anujb/SQLCipherNet When I link the resulting library in a normal Objective-C Xcode project,…
Anuj
  • 3,134
  • 13
  • 17
2
votes
1 answer

sqlcipher attach database

I am following the example at the sqlcipher Api docs : http://sqlcipher.net/sqlcipher-api#attach ATTACH DATABASE 'encrypted.db' AS encrypted KEY 'secret'; -- create a new encrypted database CREATE TABLE encrypted.t1(a,b); -- recreate the schema in…
Gandalf
  • 1
  • 29
  • 94
  • 165
2
votes
1 answer

How to use Command Line to access an encrypted SQLite db file instead of DB Browser interface

Currently I can use DB Browser for SQLite to open an encrypted DB file with password on Mac. The options as per image: Raw key (start with 0x...) SQLCipher 3 defaults I would like to open this file using command line instead of DB Browser. Tried…
Joe
  • 311
  • 1
  • 2
  • 14
2
votes
1 answer

How to store hardcoded encryption master key in android?

I'm building an app that uses Room and I want to encrypt the db using SQLCipher which needs a master key to encrypt/decrypt the db. I don't want to get the master key from the user, I want to use 1 master key and store it on the device but as far as…
Moxx4
  • 21
  • 1
2
votes
0 answers

Unable to open sqlcipher db file with knex electron

my approach to creating and using an sqlite3 encrypted database. 1_ create an encrypted db file using the ubuntu package sudo apt-get install sqlcipher. 2_ setting PRAGMA key = 'secret'. 3_ in electron : const myDBConfig = { client:…
Aimen Kaa
  • 59
  • 8
2
votes
2 answers

How to open a database encrypted with SQLCipher?

I created and encrypted a database with the package.(react-native-sqlcipher) I want to open this database with "DB Browser for SQLite" or "SQLite Studio". However, it doesn't open even though I enter the correct key. Is salt being added while…
ertandrn
  • 71
  • 1
  • 4
2
votes
0 answers

SQLCipher 4.2 is 300% solwer even if encryption is not active, Android

We are seeing a drastic performance loss after using SQLCipher 4.2 in our android app. Even in case we don't provide an encryption key and just use SQLCipher without encryption our app performances about 300 percent slower as if we use the…
Michael Bründel
  • 21
  • 3
2
votes
1 answer

how to encrypt an database using sql cipher

I want to encrypt an database using sqlcipher. I have done with the integration os openssl and sqlcipher integration and the build works perfect. But my issue is I am not able to encrypt my database. I don't know how to perform that activity or…
V.V
  • 3,082
  • 7
  • 49
  • 83
2
votes
2 answers

Which database for android ensures security and small database file size?

I am building an offline dictionary application. With database file 150,000 rows. I have used Sqlite but I need to secure my database so I use SqlCipher library to encrypt. The problem I encountered after encryption was the speed of reading data and…
Huy Nguyen
  • 23
  • 4
2
votes
1 answer

sqlcipher: failed to access DB providing hex key

I'm trying to create DB using sqlcipher and then access it by using hex value of password key. According to description from github (https://github.com/sjlombardo/sqlcipher) key is hashed by sha256 algorithm and then used to cipher DB. There is a…
user478681
  • 8,330
  • 4
  • 26
  • 34
1 2 3
…
39 40