Build a search page on your Postgres feed

SELECT id, title, company->>'name' AS company, locations, date_posted
FROM jobs
WHERE to_tsvector('english', coalesce(title, '') || ' ' || coalesce(description, ''))
        @@ websearch_to_tsquery('english', 'registered nurse')   -- Keyword search
  AND workplace_type = 'Remote'                                  -- Job type
  AND employment_type = 'Full-time'                              -- Job type
  AND locations @> '[{"country": "United States"}]'              -- Location
  AND date_posted >= now() - interval '30 days'                  -- Newest jobs first
ORDER BY date_posted DESC
LIMIT 20;

-- Company: by name, website or industry
WHERE company @> '{"name": "Acme"}'
WHERE company @> '{"industries": ["Software"]}'

-- Skills: a must-have skill
WHERE qualifications @> '{"must_have": {"skills": [{"name": "Python"}]}}'

-- Salary: a floor, within one currency and pay period
WHERE compensation->>'currency' = 'USD'
  AND compensation->>'period' = 'year'
  AND (compensation->>'min')::numeric >= 100000

-- Language: an ISO 639-1 code
WHERE language = 'en'

-- Live jobs only, newest first (feeds that keep expired jobs)
WHERE expired_at IS NULL
ORDER BY date_posted DESC

-- First page
SELECT id, title, date_posted FROM jobs
WHERE date_posted IS NOT NULL
ORDER BY date_posted DESC, id DESC
LIMIT 20;

-- Next page: pass the date_posted and id of the last row you showed
SELECT id, title, date_posted FROM jobs
WHERE date_posted IS NOT NULL
  AND (date_posted, id) < ($1, $2)
ORDER BY date_posted DESC, id DESC
LIMIT 20;

SELECT workplace_type, count(*)
FROM jobs
WHERE to_tsvector('english', coalesce(title, '') || ' ' || coalesce(description, ''))
        @@ websearch_to_tsquery('english', 'registered nurse')
GROUP BY workplace_type;

SELECT * FROM jobs WHERE updated_at > $1 ORDER BY updated_at;