AES-256 encrypted SQLite databases with SQLCipher

Hi,

the «Neverending Story» about encrypted SQLite databases ends now! With SQLCipher you can add transparent, full database, AES-256 encryption with minimal performance impact to your databases. For how you can build the needed sql driver, I have wrote some wiki pages which guide you through the installation and compiling process.
They are not fully polished yet, but they will in future... A build instruction for Mac OSX follows within the next days.

[WIKI]Building QSQLITE driver with AES-256 encryption support[/WIKI]


Best,

Lykurg

Thanks for this. I was planning to do exactly this but hadn't reached the stage of necessity yet. I still might have to merge it with Spatialite which no doubt will provide hours of fun.

Good job. I think the security of such solution is limited as you still need to have the encryption key somewhere but good job nevertheless.

this work for mobile app too? ( symbian ^3, Maemo / meego, Symbian s60 )

It should. Haven't tried so far, and the next weeks I have no time to do so. But in December I am planing to compile it for my new N8:D

Quote:

---

Originally Posted by Lykurg

But in December I am planing to compile it for my new N8:D

---

...that you won during DevDays. Yeay!

did you compile for the N8? it works? because i'm looking for something like this for my app

Can one encrypt a database after creating it with another tool? i.e. I already have nameDB.db, QSQLITE will not encrypt it since it is already created.

Google is your friend... http://sqlcipher.net/documentation/api#attach

I made a simple app to act as a template for creating encrypted databases with SQLCipher. The app requires that you have a working SQLCipher driver and in no way try to build one. You can find it on:
https://bitbucket.org/sjemens/dbkeystore

If you use mercurial try
hg clone https://bitbucket.org/sjemens/dbkeystore

Any comments and suggestions are welcomed.

If applying this change to QT, can I still use QT with LGPL license?