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: 350
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
