user9106726
user9106726

Reputation:

How to encrypt and decrypt a sqlite3 database in Java?

First of all I need to encrypt my sqlite3 database, because there are very sensitive data. Then I would only need to decrypt my database when I need it. How could I do? I am using the sqlite3-jdbc-3.30.1 and DB Browser for Sqlite. My databases contains lots of strings. My data is like:

ID , lemma , definition

1 , Hello , an expression of greeting

Connection conn = null;
    try {
        conn = DriverManager.getConnection("jdbc:sqlite:C:\\sqlite databases\\library.db"); 
     
    }
    catch(SQLException exc) {}

Upvotes: 1

Views: 1918

Answers (2)

try this one

http://sqlite-crypt.com/

it will encrypt database data

Upvotes: 1

Wowo Ot
Wowo Ot

Reputation: 1529

I would recommend that you use SqlCipher this is the Link:

https://www.zetetic.net/sqlcipher/

Upvotes: 1

Related Questions