E2EE

[McPizza0]

Encryption is a big topic
easier to apply in local single user systems
harder for shared multi user orgs

Ideally we would want specific data in the DB to be stored encrypted
This would require a per-org encryption key to ensure users in the same org can access all data

A challenge comes up when we look at search-ability of encrypted data.
Common methods are to download all data to client, decrypt and run a search on it
but I havent found a true search while encrypted method

Opening this for discussion

requirements:
Specific column data within the DB to be encrypted using a per-org key
storage and management of the Org Keys
Full Plain Text search on data within the encrypted columns