How to upgrade/update the sqlite3 version on your Mac

First check to see which version of sqlite3 you want to upgrade to and figure out what the URL for the tar ball is. In this example, I want to upgrade to version 3.6.18
Visit SQLite3 Download Page
Here is one way to do it:

mkdir ~/src
cd ~/src
curl http://www.sqlite.org/sqlite-3.6.18.tar.gz | tar xvfz
cd sqlite-3.6.18
autoconf
./configure –prefix=/usr/local
make
sudo make install

# check what version of SQLite is installed
sqlite3 –version
# 3.6.18

which sqlite3
# /usr/local/bin/sqlite3