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