Skip to content

feat(search): add matchField and PostgreSQL tsvector full-text index #71

Description

@waterbro-8

Summary

Follow-up to #68 / PR #69.

Phase 1 of #68 asked for a contentSearch tsvector + GIN index, websearch_to_tsquery(), and a matchField indicator (title | content | both) so host UIs can highlight where a hit was found. PR #69 ships title OR content contains plus after/before/sort, which unblocks the host-app search miss, but not the indexed retrieval or match provenance.

Expected

  • Persist a plain-text extraction of TipTap content (or equivalent) and index it.
  • GET /api/v1/documents?query= and GET /api/doc?keyword= report matchField.
  • Keep the current contains fallback for SQLite / unmigrated environments.

Out of scope

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions