Skip to main content

A sqlite3 cursor with extra methods to support FTS3/4/5

Project description

FTSCursor

A sqlite3 cursor with extra methods to support FTS3/4/5.

This package contains a subclass of the sqlite3.Cursor class that makes it easy to perform (simple) full-text-search operations using the sqlite3 module.

See the included example script for an application of the FTSCursor class. Once ftscursor is installed, the example script can be run from the command line by calling ftscursor-example. For usage information, see ftscursor-example -h:

usage: ftscursor-example [-h]
                         <path/to/database.db> <table_name> <column_name>
                         [<column_name> ...] <query>

Create a sqlite3 FTS table in memory and perform a query

positional arguments:
  <path/to/database.db>
                        a sqlite database
  <table_name>          the table which will be indexed
  <column_name>         a column which will be indexed
  <query>               a FTS query

optional arguments:
  -h, --help            show this help message and exit

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

ftscursor-0.5.8.tar.gz (5.5 kB view details)

Uploaded Source

Built Distribution

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

ftscursor-0.5.8-py3-none-any.whl (6.8 kB view details)

Uploaded Python 3

File details

Details for the file ftscursor-0.5.8.tar.gz.

File metadata

  • Download URL: ftscursor-0.5.8.tar.gz
  • Upload date:
  • Size: 5.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.9.10

File hashes

Hashes for ftscursor-0.5.8.tar.gz
Algorithm Hash digest
SHA256 7494c62af36b89f9c7f95ba0672de1ada573b2adbf1018eeff381100899d6887
MD5 d63721897db9758bfe27b89ad48af5b1
BLAKE2b-256 c1c411fc985f9436b2e3fed2b0b91973bae58752a0bf1b066e8644173f31a230

See more details on using hashes here.

File details

Details for the file ftscursor-0.5.8-py3-none-any.whl.

File metadata

  • Download URL: ftscursor-0.5.8-py3-none-any.whl
  • Upload date:
  • Size: 6.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.9.10

File hashes

Hashes for ftscursor-0.5.8-py3-none-any.whl
Algorithm Hash digest
SHA256 bde84b1a5125f6285701345fdde2ae392a7159c5e8b85122b1833d2adb5ad064
MD5 6d626acf09aac34e8e74b127e3145e7d
BLAKE2b-256 ad296c048d944b6476da739278fa7cf1cc334ed2106359b88e1a494875e42a80

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