Open rafiss opened 2 years ago
Note: Ebean ORM supports use of pgp_sym_encrypt
and pgp_sym_decrypt
for transparent runtime encryption/decryption of specific columns. That is, Ebean makes the fact some columns are encrypted is transparent to application code. This feature is typically used in apps that need HIPPA / PIM personally identifying data (name, date of birth etc) to be only decrypted on access at runtime. A workaround for apps porting to Cockroach would be to use client side encryption/decryption noting that has limitations (e.g. can't use the encrypted columns in a query WHERE
clause).
Hello!
Let me clarify if those functions have already been supported by CockroachDB or not. #21001 has been closed as completed, but hasn't the pgcrypto
module been actually supported by CockroachDB yet?
NB: let's first evaluate how valuable this would be, since this seems like a larger project.
From https://www.postgresql.org/docs/14/pgcrypto.html
Jira issue: CRDB-11792