Hello community
exist any way to encrypt database data nativa en Cspro??
Encrypt database field
Encrypt database field
Hugo Diaz Nuñez
Dominican Republic
Dominican Republic
Re: Encrypt database field
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,
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,
G.VOLNY, a CSProuser from Haiti, since 2004