DB Queries over Encrypted strings ? or how ?

[liveme]

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.

[FourthWorld]

SSL should be sufficient. And you can't post an app to the app stores these days that doesn't use SSL.

[liveme]

hmm, interesting....
So, as for transfering : SSL is already crypting transfered data ..enough you think ?
no need for an extra LC encryption method on top of it then....

[FourthWorld]

SSL is good enough for banking and medical insurance, it should be okay for most common needs.

If it enough? Is anything enough?

[liveme]

hmm..
...enough of Covid crisis now !

[FourthWorld]

hmm..
...enough of Covid crisis now !

Amen to that, friend.