Re: MySQL lite password

2015-02-23 Thread Bob Sneidar
Now would be a good time for me to point out that I created a Login stack that is modular. You pass either an array of database connection settings, or else an sqlYoga database object name. It will take care of the rest. If a login table does not exist in your current database it will create one

Re: MySQL lite password

2015-02-21 Thread Andrew Kluthe
That's interesting, Pete. Good catch. On Fri, Feb 20, 2015 at 5:02 PM, Peter Haworth wrote: > 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.

Re: MySQL lite password

2015-02-20 Thread Peter Haworth
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.o

Re: MySQL lite password

2015-02-20 Thread JB
Maybe both but right now I was just going to encrypt the database. Is there a problem with that? The database will only be used with my program therefore compatibility is of no concern to me. John Balgenorth On Feb 20, 2015, at 2:18 PM, Skip Kimpel wrote: > Encrypt the entire database? Or en

Re: MySQL lite password

2015-02-20 Thread Skip Kimpel
Encrypt the entire database? Or encrypt the data inside of the database? > On Feb 20, 2015, at 5:05 PM, JB wrote: > > THANKS FOR THE INFO! > > I can encrypt the DB and use > a password from there. Your > info saves me a lot of time. > > thanks again, > John Balgenorth > > >> On Feb 20, 2015

Re: MySQL lite password

2015-02-20 Thread JB
THANKS FOR THE INFO! I can encrypt the DB and use a password from there. Your info saves me a lot of time. thanks again, John Balgenorth On Feb 20, 2015, at 1:39 PM, Andrew Kluthe wrote: > Unfortunately, for a SQLite file there isn't really any built in > authentication/permissions features.

Re: MySQL lite password

2015-02-20 Thread Andrew Kluthe
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, 2