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