Upgrade the version sqlite3 used by xcode?

Question

I wish to use the foreign keys facility, and thus upgraded my version of sqlite to the latest stable version 3.7.2.

I've verified the version in terminal by entering in:

> whereis sqlite3
= /usr/bin/sqlite3

> sqlite3 --version
= 3.7.2

Now, when I come to create a new database using FireFox's SQL Manager plugin it reports it is using:

3.6.22

Worse still, when I go into Xcode and run a basic SQLite Select query and get a log of the version used it says:

3.6.22

How do I upgrade the sqlite3 version used by both Firefox and Xcode, also; should I be even trying to code for the latest sqlite when a user's phone might not have it?

Thanks for your help.

Answer 1

Ad-hoc plug ins and managers will have an included sqlite3 version. What you are seeing is the dll's version, not the database's. Try swapping them with the latest sqlite3.dll file.

Answer 2

After some research, I think I am just going to ignore the FOREIGN KEY feature; there's no guarantee old ipods/iphone's would have the latest sqlite, so I'm going to re-inforce the database structure manually through code.