Page 1 of 1

Password Protect a SQLite DB. Is this possible in livecode?

Posted: Mon May 17, 2021 11:01 am
by lemodizon
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.

Re: Password Protect a SQLite DB. Is this possible in livecode?

Posted: Mon May 17, 2021 2:43 pm
by Mikey
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.

Re: Password Protect a SQLite DB. Is this possible in livecode?

Posted: Mon May 17, 2021 3:42 pm
by lemodizon
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.