DB Queries over Encrypted strings ? or how ?
Posted: Fri Feb 26, 2021 11:44 pm
Hi DB designers,
I'm thinking of applying url dec/encode + Encryption to data Strings users would send from their Mobile/desktop App to a server...
- I likely would URLdecode any Strings once on the server just before storing in the DB. (usefull ??)
but my main wondering is :
- What is the way to run some "Text search" or "content queries" once data is stored if it remains encrypted ?
- Can one run a query over an encrypted stored string in the DB ?does the search criteria requires the same encryption process to match the content ?
- or does one HAVE to decrypt all content columns that is likely to be searched after by general users ?
So that would mean, encryption is only possible during data transfer...but then can not really be used on any stored data.
(encryption here would be used in case the whole DB is hacked or leaks out somehow...)
So is it protection vs Searchable content ?
Thanks for sharing your way to deal with this.
I'm thinking of applying url dec/encode + Encryption to data Strings users would send from their Mobile/desktop App to a server...
- I likely would URLdecode any Strings once on the server just before storing in the DB. (usefull ??)
but my main wondering is :
- What is the way to run some "Text search" or "content queries" once data is stored if it remains encrypted ?
- Can one run a query over an encrypted stored string in the DB ?does the search criteria requires the same encryption process to match the content ?
- or does one HAVE to decrypt all content columns that is likely to be searched after by general users ?
So that would mean, encryption is only possible during data transfer...but then can not really be used on any stored data.
(encryption here would be used in case the whole DB is hacked or leaks out somehow...)
So is it protection vs Searchable content ?
Thanks for sharing your way to deal with this.