Skip to main content

A Python binding for tokenizers of SQLite Full Text Search

Project description

codeship build status appveyor build status


sqlitefts-python provides binding for tokenizer of SQLite Full-Text search(FTS3/4). It allows you to write tokenizers in Python.

SQLite has Full-Text search feature FTS3/FTS4 along with some predefined tokenizers. It is easy to use and has enough functionality. Python has a built-in SQLite module, so that it is easy to use and deploy. You don’t need anything else to full-text search.

But… the predefined tokenizers are not enough for some languages including Japanese. Also it is not easy to write own tokenizers. This module provides ability to write your own tokenizers using Python without C compiler by CFFI.

It also has ranking functions based on peewee.

NOTE: all connections using this modules should be explicitly closed. due to GC behavior, it can be crashed if a connection is left open when a program terminated.


  • Python 2.7, Python 3.3+, and PyPy2.7, PyPy3.2+

  • CFFI

  • FTS3/4 enabled SQLite3 or APSW (for Windows, you may need to download and replace sqlite3.dll) * SQLite 3.11.x have to be compiled with -DSQLITE_ENABLE_FTS3_TOKENIZER to enable 2-arg fts3_tokenizer * SQLite 3.10.2 and older versions do not have extra requirements. 2-arg fts3_tokenizer is always avaiable. * SQLite 3.12.0 and later vesrions do not have extra requirements. 2-arg fts3_tokenizer can be enabled dynamically.


This software is released under the MIT License, see LICENSE.


Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlitefts-0.4.9.tar.gz (15.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

sqlitefts-0.4.9-py2.py3-none-any.whl (8.0 kB view details)

Uploaded Python 2Python 3

File details

Details for the file sqlitefts-0.4.9.tar.gz.

File metadata

  • Download URL: sqlitefts-0.4.9.tar.gz
  • Upload date:
  • Size: 15.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for sqlitefts-0.4.9.tar.gz
Algorithm Hash digest
SHA256 e24df21ac5b9678ee918e26162c3ac1c67a0e1fcdc95790d4cba412c1dd1c375
MD5 7a36f4848c7964f695a35914d813fde6
BLAKE2b-256 a4193e578176941b48dfa90d6a16f597f49bdd1c6aa26f4875bfd04410c4c428

See more details on using hashes here.

File details

Details for the file sqlitefts-0.4.9-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for sqlitefts-0.4.9-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 53cac208509ac2012d20cbd585db1146c2c2bb26659634e4441dea96b5fc986a
MD5 26a25c38bb3988328bd6b9b0bd4afec4
BLAKE2b-256 e51d7bc517cfc1427e7c41ff4ae0a9d328bdd2e9e20b2b69d33327d11f250efc

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page