DEV Community

Discussion on: How to encrypt database fields transparently for your app using Acra and DigitalOcean managed PostgreSQL

Collapse
 
pvleap profile image
pvleap

Hi Artem,
Thanks for the detailed article. I am trying to integrate a python restful service app with a postgres db and are trying to transparently encrypt 2 fields in a postgres table that are of text datatype. We are using only acrakeymaker to generate the writer keys and acra server and no other acra components. The acra server set up by us transparently encrypts data inserted/updated by us and decrypts it when we retrieve it using SELECT statements but we find that the decrypted data is in HEX encoded format, while the python app expects the data in clear text format. Please let me know if there are any options by which we can make acra server to return the clear text data without us having to make any changes to our pythin app and without writing any wrapper classes? Also does acra server have the option of configuring custom converters that can be plugged into it which will do the decoding of the HEX encoded text? Thanks.

Collapse
 
vixentael profile image
vixentael

Hi pvleap!
We've seen your similar question on Github, and replied there.
github.com/cossacklabs/acra/issues...

Collapse
 
pvleap profile image
pvleap

Yes saw it.. Thanks for the prompt response. cheers.