How to encrypt and decrypt a particular filed in a Database

Asked Feb 28 '17 at 17:12

Active Mar 01 '17 at 09:55

Viewed 36 times

I have a simple question for you and I would like to know if there are some best practices. I have a mysql table that has a field that points to a filesystem (a link to an image). I would like to encrypt this item and, when it will be the time, I would decrypt it. I give you an example to better understand: A list al students who each has a list of homework stored in a file system. The table Homework has a foreign key to a particular Student. The Homework table has a link in which the pdf homework is stored in file system. I would stored in the db the homework's link ciphered. When I want to get all the homeworks belonging to a student I have to encrypt the link.

How can I manage this?

Thank you a lot.

edited Mar 01 '17 at 09:55

asked Feb 28 '17 at 17:12

Paride Letizia

I think you mean encrypt and decrypt!?! – Strawberry Feb 28 '17 at 17:20
yes man, sorry. I mean exactly that – Paride Letizia Feb 28 '17 at 17:23
Well, while I'm a great fan of MySQL, other RDBMSs may be able to handle this kind of thing better. – Strawberry Feb 28 '17 at 17:37
@Strawberry thank you for your answer, but what do you mean? What kind of RDBMS could manage better this? – Paride Letizia Feb 28 '17 at 18:02
Any suggestion? – Paride Letizia Mar 01 '17 at 09:46
Look into concepts such as 'data-at-rest encryption'. Depending on how important this stuff is to you, you may want to look at using the Enterprise edition of MySQL, or MariaDB (or Oracle, Postgres etc.) – Strawberry Mar 01 '17 at 10:55

How to encrypt and decrypt a particular filed in a Database

0 Answers0