simonw/datasette

Mechanism for ranking results from SQLite full-text search

Open

#268 创建于 2018年5月16日

在 GitHub 查看
 (12 评论) (0 反应) (0 负责人)Python (8,637 star) (625 fork)batch import
featurehelp wantedmediumsearch

描述

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/

贡献者指南

技术栈
pythonsqlite
领域
backendsearch
议题类型
feature
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
half day
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
stale
清晰度议题是否清楚说明期望改动、验收标准和下一步。
needs investigation
前置要求
PythonSQL basicsSQLite FTS fundamentals
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
45
研究方向
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.