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

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 AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page