Database encryption/decryption functions

Postgres pgp_sym_encrypt, pgp_sym_decrypt
MySQL aes_encrypt, aes_decrypt

From my experience these functions have been mostly used in applications built for the Health industry to encrypt specific columns that contain personally identifiable information (hipaa).  This data at rest is encrypted (without the need to encrypt at rest the whole database which is another approach).

1 comment

Please sign in to leave a comment.