Method searchFacts

src/session/store.ts:387–411

* Search remembered facts by relevance (FTS5 bm25 rank), scoped like getFactsByScope. * Empty/again-unusable query ⇒ []. Falls back to a LIKE scan when FTS5 isn't available.

(query: string, scope: 'project' | 'user', cwd: string, limit = 20)

      const factN = (this.db.prepare(`SELECT count(*) AS n FROM session_facts`).get() as { n: number }).n;
      if (ftsN === 0 && factN > 0) {
        this.db.exec(`INSERT INTO session_facts_fts(session_facts_fts) VALUES('rebuild')`);
      }
      this.ftsReady = true;
    } catch (e: any) {
      logger.debug('FTS over facts unavailable; recall search will fall back to LIKE', { err: e?.message });
      this.ftsReady = false;
    }
  }

  /**
   * Search remembered facts by relevance (FTS5 bm25 rank), scoped like getFactsByScope.
   * Empty/again-unusable query ⇒ []. Falls back to a LIKE scan when FTS5 isn't available.
   */
  searchFacts(query: string, scope: 'project' | 'user', cwd: string, limit = 20): string[] {
    const where = scope === 'user' ? `f.scope = 'user'` : `f.cwd = ? AND f.scope = 'project'`;
    const scopeArgs = scope === 'user' ? [] : [cwd];
    const match = buildFtsMatch(query);
    if (this.ftsReady && match) {
      try {
        const rows = this.db.prepare(
          `SELECT f.fact AS fact FROM session_facts_fts ft JOIN session_facts f ON f.id = ft.rowid
           WHERE session_facts_fts MATCH ? AND ${where} ORDER BY rank LIMIT ?`,
        ).all(match, ...scopeArgs, limit * 4) as { fact: string }[];
        return dedupe(rows.map(r => r.fact)).slice(0, limit);
      } catch (e: any) {
        logger.debug('FTS search failed; falling back to LIKE', { err: e?.message });
      }
    }