On 3 Apr 2012, at 5:38pm, Dan Kennedy <danielk1...@gmail.com> wrote:

> On 04/03/2012 11:18 PM, Pete wrote:
>> I am running OS X 10.6.8 and sqlite3 comes with the OS.  Does anyone know
>> where I can get a version of sqlite3 for OS X that does support foreign
>> keys?  It would have to be a compiled binary since I don't access to
>> compilers (or the skills to use them).
> 
> From here:
> 
>  http://www.sqlite.org/download.html
> 
> First artifact listed under "Precompiled Binaries For Mac OS X (x86)".

Do /not/ replace any version of sqlite3 that comes with the OS.  You're 
probably using /usr/bin/sqlite3.  But just drop this one into one of your own 
folders and use it from there.  So if you're used to doing

prompt$ sqlite3 myDatabase.s3

then put the executable in the same folder and do

prompt$ ./sqlite3 myDatabase.s3

instead.

I don't know of specific problems that would be caused by updating Apple's own 
version, but it's generally considered to be a risky thing to do because 
Apple's software might depend on behaviour of its current version.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to