A very small standalone full-text search HTTP/SCGI server.
- Tcl 8.6
- tclsqlite3 with FTS5
The above and
- Tcllib
- kill(1), make(1), sqlite3(1)
- tDOM and file(1) to run
tools/dir2json
On recent Debian and Ubuntu install the dependencies with
sudo apt install libsqlite3-tcl make sqlite3 tcl tcllib tdom
On FreeBSD with sudo install the dependencies with
sudo pkg install sqlite3 tcl-sqlite3 tcl86 tcllib tdom
cd /usr/local/bin
sudo ln -s tclsh8.6 tclsh
Usage:
tinyfts --db-file path [option ...] [wapp-arg ...]
Options:
--css-file ''
--credits <HTML>
--header <HTML>
--footer <HTML>
--title tinyfts
--subtitle <HTML>
--table tinyfts
--rate-limit 60
--result-limit 100
--log 'access bad-request error rate'
--behind-reverse-proxy false
--snippet-size 20
--title-weight 1000.0
--query-min-length 2
--query-syntax web
The basic usage is
tools/import json example.jsonl example.sqlite3
# Local server
./tinyfts --db-file example.sqlite3 --local 8080
# Server available over the network
./tinyfts --db-file example.sqlite3 --server 8080
The default full-text search query syntax in tinyfts resembles that of a Web search engine. It can handle the following types of expressions.
foo
— search for the word foo."foo bar"
— search for the phrase foo bar.foo AND bar
,foo OR bar
,NOT foo
— search for both foo and bar, at least one of foo and bar, documents without foo respectively. foo AND bar is identical to foo bar. The operators AND, OR, and NOT must be in all caps.-foo
,-"foo bar"
— the same asNOT foo
,NOT "foo bar"
.
You can allow your users to write full
FTS5 queries
with the command line option --query-syntax fts5
. FTS5 queries are more
powerful but expose the technical details of the underlying database. (For
example, the column names.) Users who are unfamiliar with the FTS5 syntax
will find it surprising and run into errors because they did not quote a word
that has a special meaning.
Tinyfts searches the contents of an SQLite database table with a particular
schema. The bundled import tool tools/import
can import serialized data
(text files with one JSON object or Tcl dictionary per line) and wiki pages
from a Wikit/Nikit database into
a tinyfts database.
This example shows how to set up search for a backup copy of the Tcler's Wiki. The instructions should work on most Linux distributions and FreeBSD with the dependencies and Git installed.
1. Go to https://sourceforge.net/project/showfiles.php?group_id=211498.
Download and extract the last Wikit database snapshot of the Tcler's Wiki.
Currently that is wikit-20141112.zip
. Let's assume you have extracted the
database file to ~/Downloads/wikit.tkd
.
2. Download, build, and test tinyfts. In this example we use Git to get the latest development version.
git clone https://github.com/dbohdan/tinyfts
cd tinyfts
make
3. Create a tinyfts search database from the Tcler's Wiki database. The repository includes an import tool that supports Wikit databases. Depending on your hardware, this may take up to several minutes with an input database size in the hundreds of megabytes.
./tools/import wikit ~/Downloads/wikit.tkd /tmp/fts.sqlite3
4. Start tinyfts on https://localhost:8080. The server URL should open automatically in your browser. Try searching.
./tinyfts --db-file /tmp/fts.sqlite3 --title 'tinyfts demo' --local 8080
- If you put tinyfts behind a reverse proxy, remember to start it with the
command line option
--behind-reverse-proxy true
. It is necessary for correct client IP address detection, which rate limiting depends on. Do not enable--behind-reverse-proxy
if tinyfts is not behind a reverse proxy. It will let clients spoof their IP with the headerX-Real-IP
orX-Forwarded-For
and evade rate limiting themselves and rate limit others.
MIT. Wapp is copyright (c) 2017-2022 D. Richard Hipp and is distributed under the Simplified BSD License. Tacit is copyright (c) 2015-2020 Yegor Bugayenko and is distributed under the MIT license.