3 ms·
Aye, there's the rub. Lots of nice features disappear when you're only storing encrypted data. I suspect that it's not possible to create an index of the data (
by buss 13y ago
Aye, there's the rub. Lots of nice features disappear when you're only storing encrypted data. I suspect that it's not possible to create an index of the data (before encrypting it) that doesn't leak information and thus ruin the encryption (but IANACryptologist).
It would really only be useful for data you're not joining on or searching over, and then you've got more of a dumb data store than a database.
- eurleif 13y agoIt might be useful if a database could enable encryption on specific columns (which would make those columns unindexable).