[Kmymoney-devel] Review Request 116819: SQLCipher as database driver for encrypted SQLite databeses

[Alvaro Soliverez]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://git.reviewboard.kde.org/r/116819/#review57078
-----------------------------------------------------------

Ship it!


Ship It!

- Alvaro Soliverez


On March 15, 2014, 6:46 p.m., Christian David wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://git.reviewboard.kde.org/r/116819/
> -----------------------------------------------------------
> 
> (Updated March 15, 2014, 6:46 p.m.)
> 
> 
> Review request for KMymoney.
> 
> 
> Repository: kmymoney
> 
> 
> Description
> -------
> 
> Added support for SQLCipher database driver in KMyMoney
> 
> Database backend supports SQLCipher driver. Added a new method to
> KMyMoney's SQL driver which stores information if a password is
> supported.
> 
> Also a new QSQLDriver for SQLCipher was introduced.
> 
> This is still work in progress as some features are missing (e.g. encrypt not encrypted database and vice versa, change password). But install is hard so only sophisticated users and engaged package maintainer can do that. I do not think this will be useful in near future. However I wanted to shared my code.
> 
> How to install/use this patch:
> 
> 1) You need SQLCipher, http://sqlcipher.net , build and install it (to my knowledge it is not packed in any major distribution).
> 2) Get the qt source code (or just the one for QSQLiteDriver) and build it (needed as this will create the necessary folder hierarchy).
> 
> 3) If you do not install to default location, enable CMake to find these folders (SQLCipher install folders, Qt source folder, Qt build folder).
> 
> 4) Create KMyMoney with ENABLE_SQLCIPHER=ON (default is off)
> 
> 
> Forgot: I have no clue how secure SQLCipher is! Just wanted to see if I can get it running.
> 
> 
> Diffs
> -----
> 
>   kmymoney/plugins/sqlcipher/tests/sqlcipherdrivertest.cpp PRE-CREATION 
>   kmymoney/plugins/sqlcipher/tests/sqlcipherdrivertest.h PRE-CREATION 
>   CMakeLists.txt 83a699b960b568f44e04b5801511da91dbda188e 
>   kmymoney/dialogs/kgeneratesqldlg.cpp 856b457f3bc862ccd376a0f6bb43f02d92128fc8 
>   kmymoney/dialogs/kselectdatabasedlg.cpp a43dfc7c2494d025a4c48082cfd30b6394585dd4 
>   kmymoney/mymoney/storage/mymoneydbdriver.h 8c8f84b5dcaca124fd3a59a59ac1e2e9637c6eba 
>   kmymoney/mymoney/storage/mymoneydbdriver.cpp c2219ef4c239ba350e3e7767c607afc9d7b41254 
>   kmymoney/plugins/CMakeLists.txt 4e5e0740d54c8ba8db7587accb2a3c2fe565dc89 
>   kmymoney/plugins/sqlcipher/CMakeLists.txt PRE-CREATION 
>   kmymoney/plugins/sqlcipher/cmake/modules/FindQSQLiteSource.cmake PRE-CREATION 
>   kmymoney/plugins/sqlcipher/cmake/modules/FindSQLCipher.cmake PRE-CREATION 
>   kmymoney/plugins/sqlcipher/qsqlcipherdriverplugin.h PRE-CREATION 
>   kmymoney/plugins/sqlcipher/qsqlcipherdriverplugin.cpp PRE-CREATION 
>   kmymoney/plugins/sqlcipher/sqlcipherdriver.h PRE-CREATION 
>   kmymoney/plugins/sqlcipher/sqlcipherdriver.cpp PRE-CREATION 
>   kmymoney/plugins/sqlcipher/tests/CMakeLists.txt PRE-CREATION 
>   kmymoney/plugins/sqlcipher/tests/sqlcipherdriverinstalltest.h PRE-CREATION 
>   kmymoney/plugins/sqlcipher/tests/sqlcipherdriverinstalltest.cpp PRE-CREATION 
> 
> Diff: https://git.reviewboard.kde.org/r/116819/diff/
> 
> 
> Testing
> -------
> 
> Opened, changed, closed and reopend a (manualy created) encrypted database file.
> 
> Performance to be tested...
> 
> 
> Thanks,
> 
> Christian David
> 
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20140501/fd663361/attachment.html>