I've been playing with some stuff in Django recently and having updated a model I wanted to add a column to the sqlite database. Unfortunately ALTER TABLE ADD COLUMN statements don't work in sqlite3.1.3 which is the version installed in Tiger and all you'll get is a SQL error message.
sqlite> ALTER TABLE snippets_snippet ADD COLUMN 'code' text; SQL error: near "ADD": syntax error
So how to fix this? Good news
fink install sqlite3 will get you version 3.2.8 and you'll find it in