Obviously I'd like the data to be secured via a password/username pair given by the user. Basically as they login their DB is decrypted and SELECT should work as expected
Encrypting the MySql tables themselves isn't really an option but is likely the fastest way to encrypt a users data. Otherwise I figure I would have encrypt fields individually as their added or edited and likewise decrypted...
I'm already taking all PHP level security as well as Apache into consideration.
Is there a DB which has native encryption support so I can easily accomplish this? I imagine something like what banks use would be ideal
PostGREL table or perhaps a MySQL table type???
Cheers