esgici wrote:rathinagiri wrote:I use SQLCipher for AES encrypted database.
SQLCipher is for SQLite ( only ? ), right ?
Is this means you are using SQLite for non-large systems ?
If so, this include local and remote networks ?
rathinagiri wrote:I use MySQL for larger systems, where in database as such is not encrypted, but entry is restricted to the server except via encrypted password.
In your opinion
encrypted password is sufficient for all security needs ?
Sorry for too many questions, I have decide for a DBMS for future use and I don't know almost anything about DBMSs other than native DBF-NTX/CDX systems
TIA
Yes. SQLCipher is for SQLite only.
I am using SQLCipher for both large and non-large single user systems. SQLite is ok for local networks but not good for simultaneous operations.
Regarding MySQL, yes, encrypted password is sufficient. The username and password for the SQL connection are kept secret. However, if a person can access to the server admin/root level, he can see and manipulate the whole data.
(For example, even though you have the access to our forum's database, since you don't know about the username and password of the SQL connection which the php configuration script knows, you can't access the database beyond your limit.)