I'm developing a application that needs storing secrets in a database.
I need a portable database (like Firebird, Sqlite, etc) where the data will be stored encrypted or password protected or both...
Let's take as example that I want create a password manager. I will need store that passwords in a database. I'm accustomed to use Embed Firebird, but not for secret data.
Another solution is to use the database naturally and encrypt the database file when I'm not connected to file, but I'm not sure of the security or performance implications.
What the best method that you recommend?
There is a project called sqlite-crypt. Which should be your best bet. sqlite db with all data on disk encrypted.