Skip to content
This repository


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

The example rank extension provided at

branch: weighted-row

This branch is 0 commits ahead and 1 commit behind master

Fetching latest commit…


Cannot retrieve the latest commit at this time

Octocat-spinner-32 .gitignore
Octocat-spinner-32 Makefile
Octocat-spinner-32 fts4-rank.c
Octocat-spinner-32 test-fts4.sql
Octocat-spinner-32 test-matchinfo.sql rank function tested to function as expected July 21, 2012

Loadable Extensions in SQLite

There is a wonderful example of a rank extension provided in the sqlite3 documentation for full-text search. However, the example requires building an extension which is not explicitly detailed in the example. This repository is for the sole purpose of building the un-adulterated* example from the docs.

git clone
cd sqlite3-fts4-rank
make linux # or darwin (OSX) or win32 (Visual Studio)

sqlite3 --init test-fts4.sql ':memory:'

Note: *There were a few typos / errors in the example function. They have been corrected to behave as documented.

See Also

Something went wrong with that request. Please try again.