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

Question

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?

Expressionism

I found this on google and your suggestion to replace sqlite.dll in the python/dll folder worked in my case. I'm adding an answer for that in case someone else finds this problem. – Rivarivage

Answer 1

1. Download the latest sql dll.

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

Rivarivage

@styfle, if this answer works for FTS4 as well, can you edit the question to reflect this? It'll be helpful for future people. Thanks. – Rivarivage

@MrValdez: Should I edit it or the person who asked the question? And should I just edit the title or what? – Behling

@styfle, the question title and the question, please. The idea is to make the question helpful to more people and also to make it easier to find via search. The person who asked wouldn't see your comment (since you posted it here). – Rivarivage

Answer 2

never mind.
installing pysqlite from source was easy and sufficient.

python setup.py build_static install 

fts3 is enabled by default when installing from source.

Expressionism

Answer 3

What Naveen said but =>

For Windows installations:

While running setup.py for for package installations... Python 2.7 searches for an installed Visual Studio 2008. You can trick Python to use Visual Studio by setting

SET VS90COMNTOOLS=%VS100COMNTOOLS%

before calling setup.py.

Arachnid

Answer 4

My answer is not related to Python 2.7. But hope it becomes helpful for users using Python 3.5. I was using sqlite Fulltext search facility. However when I was trying to Insert into a FTS3 Virtual table

def insertdata(conn, parmvlu):

    sql = ''' INSERT INTO slangs(slang,polarity)
              VALUES(?,?) '''
    cur = conn.cursor()
    cur.execute(sql, parmvlu)
    return cur.lastrowid

I was getting an error -

sqlite3.OperationalError: no such module: fts3

Similarly error was coming for FTS4 Virtual tables. Taking cue from the site , I downloaded and copied the sqlite precompiled Binaries for Windows from here into my Python DLL directory (I backed up the original sqlite.dll). My Python application started working fine.

Keelboat