Encrypt/Decrypt SQLite-database and use it "on the fly"

Posted by Berschi on Stack Overflow See other posts from Stack Overflow or by Berschi
Published on 2010-04-03T15:11:19Z Indexed on 2010/04/03 15:13 UTC
Read the original article Hit count: 331

Filed under:
|
|
|
|

Here's the thing: In my Qt4.6-Project, I use a SQLite-Database. This database shouldn't be unencrypted on my harddrive. So I want, that on every start of my program, the user gets asked to enter a password to decrypt the database. Of course the database never should appear "in clear" (not encrypted) on my harddrive.
So is there any possibility to decrypt a SQLite-database "on the fly" and read and write data? What algorithm is here the best (maybe AES)?
When it's not possible (or very slow), maybe it's better to encrypt every string in the database and decrypt the string when the password was right (so that a user could open the database, but has no clue what all the entrys could mean)?

© Stack Overflow or respective owner

Related posts about c++

Related posts about qt