Page 1 of 1

Encrypt database field

Posted: August 10th, 2017, 7:43 pm
by diaznhugo
Hello community

exist any way to encrypt database data nativa en Cspro??

Re: Encrypt database field

Posted: August 10th, 2017, 8:28 pm
by htuser
Hi Diaz,
You can do that now and in more advanced way in the future :
1.- Now, you can design an user defined encryption/decryption function using Cspro programming language.This function must encrypt in postproc and decrypt in preproc of each item. The problem with this approach is, an enumerator can't easily review his data since only encrypted data will be visible.

2.- Since csdb is a sqlite format family, when cspro developer allow full sql compatibility in cspro logic, you'll be able use sqlite user defined function having encryption/decryption. Please see more explanations:
https://stackoverflow.com/questions/845 ... sql-sqlite
http://sqlite.1065341.n5.nabble.com/Enc ... 56369.html
https://stackoverflow.com/questions/566 ... protection

In the future, when cspro support password for Csdb, we'll have native automatic encryption for csdb file.
Maybe, developers: Josh, Greg and more can share better explanations with us.
Best regards,