News for hackers. Stuff that matters.
Re:Ask HN: How do you handle security for your website(s)? by yellowapple on Wednesday August 09, 2017 @01:20PM (#14971434)
"if you use encryption can you search it in real time like wildcard and ajax?"

Depends on how it's implemented and what exactly is encrypted. Encrypted database fields have to be decrypted first; some databases (or extensions thereof) offer transparent encryption/decryption of fields, but others will require your search process to decrypt each record.

Generally, though, information that needs to be encrypted (read: anything personally-identifiable or otherwise confidential) really shouldn't rely on wildcard searching (I guess it depends on the use case, but this seems like it'd very easily result in information leaks). If a user has private information, it'd be more practical to just associate the encrypted data with the user's unique ID number and look it up that way.

There are no comments on this comment yet.