+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Free text search on encrypted data (/showthread.php?tid=32858)
Free text search on encrypted data - El Forum - 08-07-2010
[eluser]happyeddie[/eluser]
Hi everyone,
I'm going to be storing data in a database that has been encrypted using the encryption class. However I was just thinking how can you do a free text search on the database if all the data is encrypted? Or is this not possible?
Thanks
Free text search on encrypted data - El Forum - 08-07-2010
[eluser]mi6crazyheart[/eluser]
Simple way: Retrieve data from table > Decrypt it > Run u'r search algorithm over decrypt data
Free text search on encrypted data - El Forum - 08-07-2010
[eluser]Yash[/eluser]
Create View in MySQl of decrypted data and use like ordinary table.
Free text search on encrypted data - El Forum - 08-07-2010
[eluser]happyeddie[/eluser]
Great, thanks for the suggestions
Free text search on encrypted data - El Forum - 08-09-2010
[eluser]gyo[/eluser]
Just keep in mind that if your table has a -huge- number of records you might have memory problems.
Free text search on encrypted data - El Forum - 08-09-2010
[eluser]jsfmills[/eluser]
Public Key encryption uses a different style of algorithm.Encryption is deterministic.Searching encrypted data is troublesome,since you have to decrypt it to search it.I use a password keeper program that has a notes field, so this is another way to store encrypted notes that many people may already have but maybe didn't think about storing notes there.
Free text search on encrypted data - El Forum - 11-26-2010
[eluser]deloneblack[/eluser]
I will be storing data in a database that has been encrypted with the kind of cryptography. However, I thought you can make a free text search in the database if all data is encrypted.
Free text search on encrypted data - El Forum - 11-26-2010
[eluser]deloneblack[/eluser]
You have probably heard a lot about object oriented programming. And if the Java programming language is your first experience with an object-oriented languages you are probably wondering what all the talk about.