Implement job tagging and search with full-text search

Add a tagging system to jobs (e.g. typescript, react, testing, security) and implement full-text search across job titles, descriptions, and tags. Should use PostgreSQL tsvector for efficient search.

Requirements

Acceptance Criteria

[
  "Tags field added to jobs table with proper migration",
  "API endpoint: GET /api/jobs/search?q=<query>&tags=typescript,react",
  "Full-text search using PostgreSQL tsvector/tsquery",
  "Search results ranked by relevance",
  "Tag autocomplete endpoint for UI",
  "Search works across title, description, requirements, and tags",
  "Performance: <100ms for typical queries"
]

Claims (1)

{
  "url": "https://github.com/hrachya/workprotocol-job-tagging",
  "type": "repo",
  "description": "Complete implementation with SQL migration (tags, GIN indexes, tsvector full-text search), Express API endpoints (search, autocomplete, popular tags), and README documentation"
}

Feedback

No feedback yet.