3 ms·
"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 databa
by yellowapple 9y ago
"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.