When using laravels encryption cast, what method can be used to still search those records without reducing security?
#Strategies for searching encrypted fields
neon ivy
raven flicker
A blind index would probably be the way to go
potent wave
Sorry for kicking (although it's been only a few days).
We've looked into a blind index, but we're expecting a huge dataset (100k+ records easily) and thus are afraid of the potential performance issues.
We're managing personal information and want to encrypt address info (among other stuff), but need to be able to still search through the data via Nova.
I don't think we can create a database index on these columns, at least, not one that would benefit performance. Or am I wrong?
raven flicker
Thing is, if you're encrypting data you can't search it, what would otherwise be the point of encrypting data? So yeah, it'll likely have a performance penalty, but that's probably minimal, I don't see why that would cause an issue tbh. You'll inherently loose a bit of UX if you encrypt all the data, things can't be safe and at the same time plain text