Encrypt database field

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
diaznhugo
Posts: 18
Joined: December 1st, 2016, 7:24 am

Encrypt database field

Post by diaznhugo »

Hello community

exist any way to encrypt database data nativa en Cspro??
Hugo Diaz Nuñez
Dominican Republic
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: Encrypt database field

Post 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,
G.VOLNY, a CSProuser from Haiti, since 2004
Post Reply