Feature #7602
openAdd support for Dbo backend SQLite encryption using SQLCipher
0%
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
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
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
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()
?
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.