[web2py] Re: Encrypt table and search in fields

2013-07-31 Thread Massimo Di Pierro
This is not a web2py issue. This is a general design issue. Unless you encrypt each record with a different key that is only known to the owner of each individual records (his password for example), than the web app has access to all records because has the ability decrypt them all. In this cas

[web2py] Re: Encrypt table and search in fields

2013-07-31 Thread Ivan Gazzola
I need to encrypt data (medical data!) in db because if I encode the fs when mounted this remains visible and for a web app the fs is always mounted. I would like to protect the data in case of access to the fs. Any tips? thx Ivan Il giorno mercoledì 31 luglio 2013 10:33:00 UTC+2, Massimo Di

[web2py] Re: Encrypt table and search in fields

2013-07-31 Thread Massimo Di Pierro
You cannot search inside an encrypted field. If you could it would not be encrypted. the best you can do is encrypt your search string too and check that the encrypted value is equal to the encrypted search string. Anyway, even if you succeed in doing this is means that all records are encrypte