Method initFactsFts

src/session/store.ts:355–381

* Build a full-text index over `session_facts` so memory can be SEARCHED, not just dumped * newest-first. Uses an FTS5 external-content table (no data duplication — it indexes the * existing rows) kept in sync by triggers, plus a one-time rebuild for rows that predate it. * All best-effort:

()

    }
    const rows = this.db.prepare(
      `SELECT DISTINCT fact FROM session_facts WHERE cwd = ? AND scope = 'project' ORDER BY id DESC LIMIT ?`,
    ).all(cwd, limit) as { fact: string }[];
    return rows.map(r => r.fact);
  }

  private ftsReady = false;

  /**
   * Build a full-text index over `session_facts` so memory can be SEARCHED, not just dumped
   * newest-first. Uses an FTS5 external-content table (no data duplication — it indexes the
   * existing rows) kept in sync by triggers, plus a one-time rebuild for rows that predate it.
   * All best-effort: if this SQLite build lacks FTS5, searchFacts falls back to a LIKE scan.
   */
  private initFactsFts(): void {
    try {
      this.db.exec(`
        CREATE VIRTUAL TABLE IF NOT EXISTS session_facts_fts USING fts5(fact, content='session_facts', content_rowid='id');
        CREATE TRIGGER IF NOT EXISTS session_facts_ai AFTER INSERT ON session_facts BEGIN
          INSERT INTO session_facts_fts(rowid, fact) VALUES (new.id, new.fact);
        END;
        CREATE TRIGGER IF NOT EXISTS session_facts_ad AFTER DELETE ON session_facts BEGIN
          INSERT INTO session_facts_fts(session_facts_fts, rowid, fact) VALUES('delete', old.id, old.fact);
        END;
        CREATE TRIGGER IF NOT EXISTS session_facts_au AFTER UPDATE ON session_facts BEGIN
          INSERT INTO session_facts_fts(session_facts_fts, rowid, fact) VALUES('delete', old.id, old.fact);
          INSERT INTO session_facts_fts(rowid, fact) VALUES (new.id, new.fact);
        END;
      `);
      // Backfill rows that existed before the index/triggers (FTS empty but facts present).
      const ftsN = (this.db.prepare(`SELECT count(*) AS n FROM session_facts_fts`).get() as { n: number }).n;