Add column weights to FTS order by Rank · stephencelis/SQLite.swift

(6 条评论) (1 个反应) (0 位负责人)Swift (1,618 个派生)batch import

enhancementhelp wanted

仓库指标

星标: (10,145 个星标)
PR 合并指标: (平均合并 6天 17小时) (30 天内合并 4 个 PR)

描述

As far as I can tell, you can't currently run a Full-text search and order by rank in SQLite.swift.

SELECT * FROM fts WHERE fts MATCH ? ORDER BY bm25(fts);
SELECT * FROM fts WHERE fts MATCH ? ORDER BY rank;

Is this feature currently available? If not, how do we order the results of a Full-text search by relevance? Is there currently a workaround?

贡献者指南

研究方向: 研究如何在SQLite.swift的FTS查询中实现按排名排序，包括支持bm25或类似的排名函数。查看现有的FTS功能并考虑如何扩展。
技术栈: swift
领域: backend
议题类型: 功能
难度: 3
预计时间: 半天
活动状态: 活跃
清晰度: 基本清晰
前置要求: SwiftSQLite
新手友好度: 60