simonw/datasette

Mechanism for ranking results from SQLite full-text search

Open

#268 opened on May 16, 2018

View on GitHub
 (12 comments) (0 reactions) (0 assignees)Python (8,637 stars) (625 forks)batch import
featurehelp wantedmediumsearch

Description

This isn't particularly straight-forward - all the more reason for Datasette to implement it for you. This article is helpful: http://charlesleifer.com/blog/using-sqlite-full-text-search-with-python/

Contributor guide

Tech stack
pythonsqlite
Domain
backendsearch
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
needs investigation
Prerequisites
PythonSQL basicsSQLite FTS fundamentals
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
45
Research direction
Investigate how SQLite FTS ranking functions like bm25 or rank work. Review the linked article (http://charlesleifer.com/blog/using sqlite full text search with python/) for potential implementation patterns. Examine Datasette's current FTS integration in the codebase, particularly how queries are built and results displayed, to determine the minimal changes needed to add ranking.