Using SQLite's FTS3/4 with Python 3

Question

I have been working on peewee's example blog application using python's Flask framework. (See https://github.com/coleifer/peewee, inside examples>blog).

I have installed all the requirements but when I try to run the application I keep getting

no such module : FTS4

error.

Why do you think I get this error? Does this mean the standard Python3 sqlite3 module doesn't have FTS modules?

If so is there a way to enable (install) FTS3/FTS4 modules for Python 3.4?

coleifer · Accepted Answer · 2015-05-05 21:22:13Z

3

You can open a sqlite shell and run pragma compile_options to see what your SQLite has. AFAIK this has nothing to do with Python3.

Here are mine:

sqlite> pragma compile_options;
ENABLE_COLUMN_METADATA
ENABLE_FTS3
ENABLE_RTREE
ENABLE_UNLOCK_NOTIFY
SECURE_DELETE
SYSTEM_MALLOC
THREADSAFE=1

You may need to recompile SQLite if you find you do not have the FTS extension. Also check out the docs:

http://sqlite.org/fts3.html

answered May 5, 2015 at 21:22

coleifer

26.4k7 gold badges67 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mehmet Ragıp Altuncu Over a year ago

Thanks for your answer. I downloaded sqlite3 shell.exe and checked the options. I have FTS3 Enabled. I just don't understand what the problem is.

Sam Bayer Over a year ago

The sqlite you run in the shell is not the same as the sqlite you find in Python; Python contains its own DLL, which, by default, doesn't include fts3 or fts4 on Windows, at least as of Python 2.7.11.

coleifer Over a year ago

I don't think you're correct. Python dynamically-links against the SQLite library you have installed.

Collectives™ on Stack Overflow

Using SQLite's FTS3/4 with Python 3

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related