Project

General

Profile

Feature #7602

Add support for Dbo backend SQLite encryption using SQLCipher

Added by Stefan Bn about 2 years ago. Updated over 1 year 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

#1

Updated by Roel Standaert about 2 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

#2

Updated by Stefan Bn almost 2 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

#3

Updated by Roel Standaert almost 2 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()?

#4

Updated by Stefan Bn over 1 year 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.

Also available in: Atom PDF