MySQL lite password

Peter Haworth pete at lcsql.com
Fri Feb 20 18:02:58 EST 2015


Hi Andrew,
Turns out SQLite added a user authentication extension in 10/2014 that
requires a password to access an SQLite database but it's not part of the
SQLite library provided with Livecode.  It has to be compiled into the
source and a compile time flag set to enable it

See http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt

I recently added a QCC request to update the SQLite library which is now
about 8 months and several releases old, including the addition of this
feature.

On Fri Feb 20 2015 at 1:39:32 PM Andrew Kluthe <andrew at ctech.me> wrote:

> Unfortunately, for a SQLite file there isn't really any built in
> authentication/permissions features.
>
> With using only live code your only real option is to encrypt the entire
> file either using built in encrypt/decrypt commands or shell out to
> something that can.
>
> Kind regards,
>
> Andrew
> On Feb 20, 2015 1:53 PM, "JB" <sundown at pacifier.com> wrote:
>
> > What is the proper way to add a password to
> > a MySQL lite database?
> >
> > John Balgenorth
> >
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the Use-livecode mailing list