Trying to search for answers like Database encryption or filesystem encryption? but did not found what I need.
My database contains confidential information.
What is better? To store encrypted information or to use a partition encryption?
If we store encrypted information then SQL injection or other attack will return encrypted data.
The issue that establishing of storing encrypted information can cost development time.
On the other side, establishing of an encrypted partition is not big issue. But in case of SQL injection or other attack an attacker can get plain data.
What is better way to store confidential information?