Search code examples
pythonsqlitefull-text-searchfts3fts4

How to setup FTS3/FTS4 with python2.7 on Windows

FTS3/FTS4 doesn't work in python by default (up to 2.7). I get the error: 

sqlite3.OperationalError: no such module: fts3
or

sqlite3.OperationalError: no such module: fts4

How can this be resolved?

Solution

    1. Download the latest sql dll.

    2. Replace sqlite.dll in your python/dll folder.