Hello everyone,
Good day.
I want to try if Livecode can encrypt a certain/set a password on a database on SQLite i saw this code below from other programming language (C#) but i don't know if this will work on livecode.
Password Protect a SQLite DB. Is this possible in livecode?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Password Protect a SQLite DB. Is this possible in livecode?
Thank you & God Bless Everyone
Regards,
lemodizon
Regards,
lemodizon
Re: Password Protect a SQLite DB. Is this possible in livecode?
There are other ways to do this, I'm sure.
If you're on ios (don't know about android) I don't think you are going to need to do anything if you have restricted access to the db as it will be encrypted on disk and no other apps will be allowed to touch it, anyway.
To the original question,
The method that comes to mind immediately is to keep the db file encrypted, then on preOpenStack decrypt it, but store it in memory so that it is not decrypted on disk then on app exit, or at particular times, or after particular operations, encrypt the db in memory and re-save it to disk.
If you're on ios (don't know about android) I don't think you are going to need to do anything if you have restricted access to the db as it will be encrypted on disk and no other apps will be allowed to touch it, anyway.
To the original question,
The method that comes to mind immediately is to keep the db file encrypted, then on preOpenStack decrypt it, but store it in memory so that it is not decrypted on disk then on app exit, or at particular times, or after particular operations, encrypt the db in memory and re-save it to disk.
Re: Password Protect a SQLite DB. Is this possible in livecode?
Hi Mikey,
Thanks for the information. how about on desktop/laptop is this applicable to set a password just like other database like msaccess i think you can set a password so that no one can access the database.
Thanks for the information. how about on desktop/laptop is this applicable to set a password just like other database like msaccess i think you can set a password so that no one can access the database.
Thank you & God Bless Everyone
Regards,
lemodizon
Regards,
lemodizon