I wrote a fairly detailed post about sqlite full text search with python (1). I also put together some notes of you want to build the new FTS5 extension and give it a whirl (2).
http://charlesleifer.com/blog/using-sqlite-full-text-search-... http://charlesleifer.com/blog/building-the-sqlite-fts5-searc...