Forums

FTS not available in Sqlite3 - Python 2.7

I am developing a Python app that uses Full Text Search (FTS) for matching data in Sqlite3. On a Windows system I would simply download newest Sqlite.dll from the official Sqlite.org website and replace the existing sqlite.dll in Python/dlls/ folder.

Hence, in PythonAnywhere, the OS is Linux, and access to root is disabled.

How can I use FTS4 or FTS5 in my Python app running in PythonAnywhere ?

Thanks!

We only support FTS3, and that's probably not going to change for some time. We can have a look at installing FTS4, but that will be some time coming.

I have tried using FTS3, hence unsuccessfully. I always get this error:

OperationalError: unable to use function MATCH in the requested context

I can't see anything in the docs that indicates that matches behaves differently in fts3 vs fts4, so my guess is that you'd get that error in fts4, too.

Is fts5 is available now?

No, we still only support FTS3.

We now have support for FTS4 and FTS5 -- if you upgrade to our new Glastonbury system image (see here for details) you'll get them.