On External Storage!

[bhaambhu]

Hi Sir and thanks for making this incredible sql encryption product available to people. I have an app which first downloads a database stored on a server onto the sdcard (because it is of big size) and the app fetches data from the database and shows it to the user. I don't want people to just use simple sql browsing tools on windows or android to open the database personally as it has some really precious data which cost me money. What I have is-

1.) My app doesn't use SQLiteOpenHelper, my app uses
SQLiteDatabase database = SQLiteDatabase.openDatabase(path, null, 0); and other methods like get readable database (......openreadonly) etc.

I tried by simply replacing android.database.sqlite with net.sqlcipher.database. it didn't work. Can you advice something on going on with the situation I have?

[developernotes]

Hi thabhambhu,

You need to use one of the provided methods to access the database that accept a password. There are two overloaded methods on SQLiteDatabase.openDatabase(...) that accept a password. Also, if your application is downloading an existing database, you will need to make sure it has been encrypted prior to, or perform a migration of the database using sqlcipher_export. We have an article here for integrating SQLCipher for Android into an application. We have a test suite here if you would like to see examples of various usage scenarios.

[bhaambhu]

THANKS!!!

[bhaambhu]

Hey sir its me again, I have imported 'tests' project on eclipse and ran it on phone and I am going to try to encrypt the db with it(I think the ImportUnencryptedDatabaseTest but could be wrong). But
Can the encrypted db run on other phones like I upload it on server and all phones running my app download it.
And
Is there a way to do encryption on PC(other than emulator).
Thanks for helping 😸
Regards :D

[developernotes]

Hi thabhambhu,

You wouldn't need to use the actual test code, it was suggested as a reference. SQLCipher can open a database file, provided you have the passphrase used to encrypt the database. SQLCipher is available for many platforms including the PC, more information is available here. If you have additional questions, I would recommend checking out our mailing list here, which is an excellent searchable resource on SQLCipher.

[bhaambhu]

ONE LAST THING I PROMISEEE!!! 😸
I was wondering If I have used SQLCipher decryption in my android app, what should I display as credits in the app. Like Should It show in the about section that "It used SQLCipher" or some other thing. Or Should there be a separate section for it like in some apps theres this "Open Source Licenses" section or "licenses" section. like copy paste your whole Apache 2.0 (https://github.com/guardianproject/android-database-sqlcipher/blob/master/LICENSE) or this (http://sqlcipher.net/license/) or something else.
👍

[developernotes]

Hi thabhambhu,

We don't place specific requirements on where within your application you display the SQLCipher license, but the license does require it to be displayed.

[bhaambhu]

Sir
This license (http://sqlcipher.net/license/)
Or this (https://github.com/sqlcipher/android-database-sqlcipher/blob/master/LICENSE)
Regards

[developernotes]

Hi thabhambhu,

The SQLCipher license is here.

[bhaambhu]

Sir
And ICU License too?
Regards

[developernotes]

Hi thabhambhu,

Yes, SQLCipher for Android uses the ICU project, their license can be found here.

[bhaambhu]

Okay I will display
This license (http://sqlcipher.net/license/)
and this(https://github.com/sqlcipher/android-database-sqlcipher/blob/master/LICENSE)
and this https://github.com/sqlcipher/android-database-sqlcipher/blob/master/ICU_LICENSE
Is this correct sir?
oooo I bothered you too much 😦 sorry for that 😦

[developernotes]

Hi thabhambhu,

That looks good - thanks!