TextCritical.net

See http://stackoverflow.com/questions/2248743/django-mysql-full-text-search for how to do a fulltext search. See http://answers.oreilly.com/topic/1955-how-to-use-full-text-search-in-sqlite/ for how to create the index. Based on http://www.sqlite.org/fts3.html#section_1_2, it sounds like I ought to use FTS4 since disk IO is lacking on my web-server.

Might also want to consider using a search engine: http://stackoverflow.com/questions/2461322/how-to-implement-full-text-search-in-django

The SQLite that is on my local host isn't compiled with FTS 3 and 4, I doubt the SQLite libs on the web-server have it either.