incuna / django-pgcrypto-fields

Transparent field level encryption for Django using the pgcrypto postgresql extension.
BSD 2-Clause "Simplified" License
229 stars 49 forks source link

Indexing alternatives on these fields #612

Open dizzydes opened 5 months ago

dizzydes commented 5 months ago

Broad question, was just wondering if there's any best practice people use when performantly searching over these encrypted fields in a large dataset (eg in a Django admin search_field)? Indexes can't be added to byte type right. I was thinking having an unencrypted subset of a PII field perhaps - maybe there's a better way.