This is the SQLite search code example I started with for re-implementing search in PhrontPage.

Full-text search with SQLite and Rails