3 ms·
How would you combine that with indexing? Seems like data needs to be unencrypted to be indexed. And if you're not doing any indexing, isn't it as simple as co
by eurleif 13y ago
How would you combine that with indexing? Seems like data needs to be unencrypted to be indexed. And if you're not doing any indexing, isn't it as simple as converting the user's data to JSON, and encrypting the JSON?
- buss 13y agoAye, 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).