Project

General

Profile

Actions

Feature #7602

open

Add support for Dbo backend SQLite encryption using SQLCipher

Added by Stefan Bn almost 4 years ago. Updated over 3 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
06/14/2020
Due date:
% Done:

0%

Estimated time:

Description

Data security and safety is more important than ever while maintaining the simplicity of the SQLite backend.

Please consider adding support for encrypted SQLite databases to the Dbo backends using the well established and de facto standard 'SQLCipher'.

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

https://github.com/sqlcipher/sqlcipher

Thanks!

Stefan

Actions #1

Updated by Roel Standaert over 3 years ago

Maybe we can consider this as a sponsored feature, but I think it's a bit too niche for us to consider sinking our time into.

Regards,

Roel

Actions #2

Updated by Stefan Bn over 3 years ago

I would not consider enryption and data security as "niche". Also SQLcipher is mature and e.g. used by the German Government and the companies SAP and Telekom for the German Covid19-tracing app :-) However, I can understand that you have to prioritize your task items.

From what I understand, the efforts should be moderate:

https://redmine.webtoolkit.eu/boards/1/topics/1345

Actions #3

Updated by Roel Standaert over 3 years ago

According to that forum post, it should be possible to do it without modifying Wt? If it is as Koen says you can just link Wt against SQLCipher and use executeSql()?

Actions #4

Updated by Stefan Bn over 3 years ago

Yes, the forum post is correct and I was able to link Wt against SQLCipher without any problems. I've updated that forum post.

Actions

Also available in: Atom PDF