Select id by md5??

Select id by md5??

El Forum
Unregistered

03-30-2009, 01:21 PM

[eluser]Aea[/eluser]
Hashing the ID gives you a very basic protection against knowledge of how big your database is and makes "fishing" for IDs more difficult. Of course it being MD5 the protection is basically none, if you want to do this write your own key generator that's non-deterministic (i.e. don't base it off your ID unless you've got a good grasp of cryptology).

If you have to do it by ID make an column for the MD5, the call is VERY expensive, although on small applications you'll feel no difference.

Messages In This Thread

Select id by md5?? - by El Forum - 03-30-2009, 05:08 AM

Select id by md5?? - by El Forum - 03-30-2009, 05:16 AM

Select id by md5?? - by El Forum - 03-30-2009, 05:38 AM

Select id by md5?? - by El Forum - 03-30-2009, 05:44 AM

Select id by md5?? - by El Forum - 03-30-2009, 05:56 AM

Select id by md5?? - by El Forum - 03-30-2009, 06:40 AM

Select id by md5?? - by El Forum - 03-30-2009, 12:51 PM

Select id by md5?? - by El Forum - 03-30-2009, 01:21 PM

Select id by md5?? - by El Forum - 03-30-2009, 01:21 PM

Select id by md5?? - by El Forum - 03-30-2009, 01:30 PM

Select id by md5?? - by El Forum - 03-30-2009, 01:34 PM

Select id by md5?? - by El Forum - 03-30-2009, 01:39 PM

Select id by md5?? - by El Forum - 03-30-2009, 02:57 PM

Select id by md5?? - by El Forum - 03-30-2009, 03:06 PM

Select id by md5?? - by El Forum - 03-30-2009, 03:11 PM

Select id by md5?? - by El Forum - 03-30-2009, 03:13 PM