Setting Password for Android Sqlite Database

Question

I am designing one Custom library, in that library to store the confidential data. For storing the data i have 2 options.

1) shared preferences.

2) Sqlite3 database.

If , i use SharedPreferences with MODE_PRIVATE . It can be accessed by the application developers those who are use my library.

Second option is Sqlite3 Database, Here i can store but still data can be used by the application developers by adding my library.

SO, i been looking for the answers that, Do we have option for setting password for the Database in Android.If yes please guide..

Thank you in advance for the answers.

score 3 · Accepted Answer · answered Apr 08 '13 at 14:13

Hey the same Problem with me too....

I got an Solution....

The Solution is Dual Passwords :D

Here all we can do is encrypt all the data that is confidential...

Step 1 : Ask user for two Passwords ( Password1 & Password2 ) rather than a username & pass...

Step 2 : You can encrypt all the data using a Password that may be 1 or 2...

Step 3 : to decrypt that data again the same password must be used..

THE PROBLEM SOLVED: The problem is how Can we store the Passwords in the database..

ALL WE DO is encrypt the first password with the other.... ENCRYPTION AND DECRYPTION refer this link

JUST USE THAT it works like charm

SO FINALLY HOW THE PROCESS GOES IS

@SagarNayak you can use the following https://github.com/scottyab/AESCrypt-Android — ivar ajet, May 23 '17 at 06:53

score 2 · Answer 2 · answered Mar 28 '13 at 11:10

2

The company behind SQLite provides a commercial solution which you can use.

However, SQLCipher is a free (and open source) alternative that allows you to encrypt your SQLite databases.

answered Mar 28 '13 at 11:10

Raghav Sood

I am creating library,(if i am developing application, i can use the SQLcipher - because SqlCipher creates library to load). I don't want add the library with in a library, that will be weird right?? – Naveen Mar 28 '13 at 12:16
@Naveen ActionBarSherlock uses the supporr library even though it is a library. It is definitely possible. – Raghav Sood Mar 28 '13 at 13:28
@Naveen you could always encrypt the data itself using AES or something before you write it to the database, and decrypt it after you read it if you want something dynamic. – Raghav Sood Mar 28 '13 at 14:04
Thank you very much, i been looking for what you say now. Please share the tutorial regarding the same. – Naveen Mar 28 '13 at 14:06
@Naveen There's an SO question on it here: http://stackoverflow.com/q/6788018/1069068. Many more are there too, which Google can help you with – Raghav Sood Mar 28 '13 at 14:08

2 Answers2